JR59966: Remove key expressions generated in Oracle Connector select statement after migrating an Oracle Enterprise job.

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

APAR status

• Closed as program error.

Error description

• In a job if Oracle EE stage is in lookup context and the job is
  migrated using connector migration tool, then key expressions
  are being added in the select statement of Oracle connector
  stage. This causes the job to abort because of wrong SQL.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  Users migrating Oracle operator jobs with Oracle EE stage in
  lookup context to Oracle Connector jobs.
  ****************************************************************
  PROBLEM DESCRIPTION:
  In a job if Oracle EE stage is in lookup context and the job is
  migrated
  using connector migration tool, then key expressions are being
  added
  to the select statement in the migrated Oracle connector stage.
  This causes the job to abort because of wrong SQL.
  ****************************************************************
  RECOMMENDATION:
  Apply Patch JR59966 on Client tier and remigrate the problematic
  job again.
  ****************************************************************
  

Problem conclusion

• The code was fixed to not append key expressions when the lookup
   context operator is migrated to connector.
  

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