JR39039: DUPLICATE COLUMNS ARE NOT CAUGHT DURING EXPORT. THIS CAUSES SUBSEQUENT IMPORT ERRORS IN ISTOOL

IBM InfoSphere Information Server, Version 8.5 Fix Pack 2

APAR status

• Closed as new function.

Error description

• Customer encountered "DupliccateIdentityException" while
  importing .isx file via istool command due to duplicate columns
  exist in the export file
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  Affects users who are importing table definitions from
  Orchestrate schema definitions
  ****************************************************************
  PROBLEM DESCRIPTION:
  The Orchestrate Schema Definition importer does not prevent the
  creation of table definitions that contain duplicate column
  names.
  ****************************************************************
  RECOMMENDATION:
  Apply patch to prevent creation of table definitions with
  duplicate column names or edit schema definitions to remove
  duplicates before importing.
  ****************************************************************
  

Problem conclusion

• Orchestrate Schema Definition importer has been fixed so that it
  prevents creation of table definitions with duplicate names
  

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

• R810 PSY

     UP

• R850 PSY

     UP