JR49166: ISTOOL IMPORT MAY FAIL WITH DUPLICATEIMPORTIDENTITYEXCEPTION FOR TABLE DEFINITION WITH MULTIPLE FOREIGN KEYS.

InfoSphere Information Server, Version 11.5 for Linux
InfoSphere Information Server, Version 11.5.0.1 for Windows
InfoSphere Information Server, Version 11.5.0.2 for Linux
InfoSphere Information Server, Version 11.5.0.2 for AIX
InfoSphere Information Server, Version 11.5.0.2 for Windows
InfoSphere Information Server, Version 11.5.0.1 for AIX

APAR status

• Closed as program error.

Error description

• Istool import may fail with DuplicateImportIdentityException
  for table definition with multiple foreign keys.
  

Local fix

• Use DSX import
  

Problem summary

• When importing DataStage metdata using istool or ismanager an
  identity model is used to try
  and determine if an object being imported should replace an
  existing object.
  Each object in the import set must have a unique identitity.
  Because of an error in the definition of the identity function
  it is possible for more than one
  valid DSForeignKeyDef objects to have the same identity
  resulting in an import failure.
  

Problem conclusion

• Changing the identity function to include the id of the related
  table and the name of the referenced
  column thus ensuring uniqueness in all cases.
  

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

• Fixed component name

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• R910 PSY

     UP

• R912 PSY

     UP