JR50458: CONNECTOR IMPORT WIZARD FAILS TO IMPORT TABLE DEFINITION IN CONNECTOR IMPORT WIZARD WHEN MULTIPLE TABLES ARE SELECTED AN

Download REST API Rollup Patch for Information Server DataStage

APAR status

• Closed as program error.

Error description

• Connector Import wizard fails to import table definition in
  Connector import wizard when multiple tables are selected and
  an existing DataConnection is specified.
  

Local fix

Problem summary

• Connector Import wizard fails to import table definition in
  Connector import wizard when multiple tables are selected and an
   existing DataConnection is specified.
  When multiple tables are selected the Connector Import Wizard
  loops calling the Connector Access Service
  to import each table's metdata and create a DataCollection
  object. We then call ConvertDataCollection
  to create DSTableDefinition object from that DataCollection.
  Both classes DataCollection and DSTableDefinition have
  relationships to the DataConnection object.
  So on the first import CAS creates a DataCollection and sets a
  relationship to the DataConnection object
  DataStage then goes on to create a DSTableDefinition and set a
  relationship to the same DataConnection object.
  So far so good.
  On the second import CAS creates another DataCollection and sets
  another relationship to the DataConnection object.
  At this point DataStage creates another DSTableDefinition and
  tries to set a relationship to the DataConnection.
  DataStage finds the DataConnection object in its cache but it is
  stale becaue of the relationship set by CAS.
  When we call synchronizeCache() to refresh the DataConnection
  object we get a ObjectIsImmutableException because
  the DataConnection object also has a relationship to a
  DSTableDefinition whihc is in the cache and stale.
  

Problem conclusion

• The solution is to catch the ObjectIsImmutableException, or its
  wrapper InvalidParameterUsageException, and
  call flushCache(). This discards all cached objects and we then
  re-read the latest version of the object from
  the 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

• Fixed component name

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• R910 PSY

     UP