Problem:::
I tried to open the existing server job in datastage designer, but unable to view the data in the respective input and output stages. I got the following error "IRATEST..ORAOCI8_10: ORA-00932: inconsistent datatypes IRATEST..ORAOCI8_10.DSLink1: DSP.Open GCI $DSP.Open error -2. "
Any solution to the above said problem.......
Datastage server job {OCI stage}
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54595
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Welcome aboard! :D
This message usually indicates that the column definitions in your job design (in the OCI stage) do not match the data type in the actual columns in the Oracle table.
Make sure that they match absolutely.
Import the table definition using the OCI plug-in (in Manager use Import > Table Definitions > Plug-In Meta Data Definitions...) and inspect the result. (You can use View Data if one table has been selected.)
Perhaps even clear the column definitions from your OCI stage and load the freshly-imported ones.
This message usually indicates that the column definitions in your job design (in the OCI stage) do not match the data type in the actual columns in the Oracle table.
Make sure that they match absolutely.
Import the table definition using the OCI plug-in (in Manager use Import > Table Definitions > Plug-In Meta Data Definitions...) and inspect the result. (You can use View Data if one table has been selected.)
Perhaps even clear the column definitions from your OCI stage and load the freshly-imported ones.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.