Problem when processing PX job with 4 nodes
Posted: Tue Sep 16, 2003 1:15 pm
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 only, so I have defined only this field as the key in the oracle stage.
When I have run my job with one node set in the configuration file ($APT_CONFIG_FILE), the job went through fine. Now when I have repeated the execution with 4 nodes, the job is getting aborted and the following error is being thrown.
Please help if any of you have any solution to this. Any information is also very helpful to me.
WriteOrd1.LkOutToWriteOrd1,3: Open failed for update. Update is:
sqlcode is: -60
esql complaint: ORA-00060: deadlock detected while waiting for resource
Thanks in advance,
Srinivas.
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 only, so I have defined only this field as the key in the oracle stage.
When I have run my job with one node set in the configuration file ($APT_CONFIG_FILE), the job went through fine. Now when I have repeated the execution with 4 nodes, the job is getting aborted and the following error is being thrown.
Please help if any of you have any solution to this. Any information is also very helpful to me.
WriteOrd1.LkOutToWriteOrd1,3: Open failed for update. Update is:
sqlcode is: -60
esql complaint: ORA-00060: deadlock detected while waiting for resource
Thanks in advance,
Srinivas.