JR60225: CMT IS DROPPING THE WHERE CLAUSE SPECIFIED ON ORACLE EE STAGES USED AS LOOKUP

Download the mod pack for IBM InfoSphere Information Server 11.7.1.0 In-Place Upgrade

APAR status

• Closed as program error.

Error description

• When migrating from Oracle EE stage to Oracle CC stage using
  Connector migration tool, the WHERE clause specified in the
  Oracle EE stage configured for lookup is dropped in the
  corresponding migrated connector stage
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  Jobs migration from Oracle EE to Oracle CC using CMT.
  ****************************************************************
  PROBLEM DESCRIPTION:
  Using Connector migration tool, migrating an Oracle EE job(with
  Oracle EE stage in lookup context) to Oracle CC job is
  generating a wrong select statement as the migration is dropping
  the where clause as specified in Oracle EE stage.
  
  This happens only after the patch JR58821 or later ones are
  applied.
  ****************************************************************
  RECOMMENDATION:
  Apply patch JR60225 on Client tier
  ****************************************************************
  

Problem conclusion

• Fixed the code to generate the correct Select statement.
  

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

• RB50 PSY

     UP