Dear All,
I have a parallel extender job which reads records from a sequential file. I am using upsert write method with 'Auto-generated update only' mode to update the record. There are 3 key fields defined in the actual oracle database table.
Key1, Key2, Key3.
My update is based on key1 and key2 only, so I have defined only these keys in the oracle stage. When I have run my job for small number of records, the updation worked fine. Now when I have run the same job for some huge number of records the job is getting aborted and is giving the following error. I am not able to figure out which record is exactly creating problem.
Please help if any of you have any solution to this. Any information is also very helpful to me.
Error message:
WriteTable2.LkOutToWriteTable2,2: Open failed for update.
sqlcode is: -1008
esql complaint: ORA-01008: not all variables bound
Thanks in advance,
Srinivas.
Problem with oracle stage in PX jobs
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 18
- Joined: Mon Jul 07, 2003 12:56 am
- Location: India
quote:Originally posted by dlvsrinivas
[br]I have a parallel extender job which reads records from a sequential file. I am using upsert write method with 'Auto-generated update only' mode to update the record. There are 3 key fields defined in the actual oracle database table.
Key1, Key2, Key3.
WriteTable2.LkOutToWriteTable2,2: Open failed for update.
sqlcode is: -1008
esql complaint: ORA-01008: not all variables bound
Ensure that your Column Propogation is turned off for the job. Apparently, you have the input file with a different format that was expected, and DataStage PX propagate those extra columns.
-T.J.
* * *
... now if this can make breakfast, my life is complete.
[br]I have a parallel extender job which reads records from a sequential file. I am using upsert write method with 'Auto-generated update only' mode to update the record. There are 3 key fields defined in the actual oracle database table.
Key1, Key2, Key3.
WriteTable2.LkOutToWriteTable2,2: Open failed for update.
sqlcode is: -1008
esql complaint: ORA-01008: not all variables bound
Ensure that your Column Propogation is turned off for the job. Apparently, you have the input file with a different format that was expected, and DataStage PX propagate those extra columns.
-T.J.
* * *
... now if this can make breakfast, my life is complete.