JR31677: UNABLE TO PERFORM MULTI-COLUMN PRIMARY KEY ANALYSIS

APAR status

• Closed as fixed if next.

Error description

• Unable to perform multicolumn primary key analysis. The
  "analyze full table" option encounters errors related to
  deleting artifacts and the "create data sample" option
  encounters error with column length validations.
  
  Information Analyzer 8.1
  Windows Server 2003
  SQL Server repository
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  IA 81 users prior to rollup patch RP2 who are running
  Multi-column Primary Key analysis against a SQL server
  repository
  ****************************************************************
  PROBLEM DESCRIPTION:
  Unable to perform multicolumn primary key analysis. The
  "analyze full table" option encounters errors related to
  
  deleting artifacts and the "create data sample" option
  
  encounters error with column length validations.
  ****************************************************************
  RECOMMENDATION:
  User should upgrade to IA 81 RUP2. This change is also included
  in 8.1 Fix Pack 1.
  ****************************************************************
  

Problem conclusion

• In IA 81 RUP2 and later, users will be able to run MCPK
  Analysis against a SQL Server repository
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels

• R810 PSN

     UP