JR31445: INFORMATION ANALYZER ABORTS DURING POOLING OF THE TABLE NAMES WHILE IMPORTING META DATA

APAR status

• Closed as program error.

Error description

• Information Analyzer aborts during pooling of the table names
  while importing meta data
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  users using ODBC Connector.
  ****************************************************************
  PROBLEM DESCRIPTION:
  Metadata import through Connector Import Wizard or from
  Information
  Analyzer from a datasource connecting to SQLServer 2005, fails
  with
  'Invalid State' message, when the tables have complex
  relationships.
  ****************************************************************
  RECOMMENDATION:
  The problem has been fixed. Apply the patch.
  The fix has been included in the IS 8.1 FP1. Apply the FixPack1
  for IS 8.1.
  ****************************************************************
  

Problem conclusion

• MDI fails with the following error when the table has complex
  relationships
  like 'foreign keys referencing indexed columns' and
  'composite foreign keys referencing indexed colulmns'.
  
  'An exception occurred while trying to receive the response
  fromthe handler:
     An exception was received from the handler: Invalid state'.
  

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:

Modules/Macros

• ODBC
  

Fix information

• Fixed component name

  WIS INFORM ANAL

• Fixed component ID

  5724Q36IA

Applicable component levels

• R810 PSN

     UP