11.501:Oracle Partitioned Read(Backward compatibility issue)

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
rkashyap
Premium Member
Premium Member
Posts: 532
Joined: Fri Dec 02, 2011 12:02 pm
Location: Richmond VA

11.501:Oracle Partitioned Read(Backward compatibility issue)

Post by rkashyap »

During testing of 11.5.0.1, we found that jobs with Oracle Connector partitioned reads fail with the error given below. These jobs worked fine in DataStage 9.12.

Code: Select all

Error message: ORA-00904: "FACT_SLS"."ROWID": invalid identifier
Workaround for this issue
Change Oracle Connector's property 'Table name for partitioned reads' to specify both the 'Table name' and 'Alias'.

i.e. If FROM clause of the SQL executed in Oracle Connector is FROM EDW.FACT_SLS FS and in DataStage 9.12, value of 'Table name for partitioned reads' is EDW.FACT_SLS, then in 11.5.0.1 it needs to be changed to EDW.FACT_SLS FS
rkashyap
Premium Member
Premium Member
Posts: 532
Joined: Fri Dec 02, 2011 12:02 pm
Location: Richmond VA

Post by rkashyap »

Engineering is looking into this issue. I will post updates in this forum.
rkashyap
Premium Member
Premium Member
Posts: 532
Joined: Fri Dec 02, 2011 12:02 pm
Location: Richmond VA

Post by rkashyap »

IBM has released patch JR56688for addressing this issue.
Post Reply