JR32478: CANNOT USE DATASTAGE CLIENT SHARED METADATA MANAGEMENT UI TO DELETE

APAR status

• Closed as program error.

Error description

• Cannot use DataStage Client Shared Metadata Management UI to
  delete
  items from Repository.  Repository is growing too large with too
  many
  old unused objects which cannot be deleted since delete function
  does
  not work
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  InfoSphere Information Server 8.0.1 FP1a, Windows
  ****************************************************************
  PROBLEM DESCRIPTION:
  Unable to delete a shared table by using the IBM InfoSphere
  DataStage Designer client Metadata Management tool if table is
  being referenced by another table through a foreign key.
  ****************************************************************
  RECOMMENDATION:
  None.
  ****************************************************************
  

Problem conclusion

• Updated ASBNode\lib\java\connectoraccess-clientextn.jar to add
  logic to delete any foreign key objects that are related to the
  referenced table object.
  

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

• CLIENT
  

Fix information

• Fixed component name

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• R801 PSN

     UP