Open failed for update
Posted: Thu Jun 03, 2010 3:30 am
Hi,
i searched for this error but was not able to find solution.
i am running my job on 4 node and its updating 1 million records.
I am using oracle enterprise stage for reading and writing the data.
I am reading same table in source and trying to update after dome transformation in target stage.
What would be possible cause of job being getting aborted.
i searched for this error but was not able to find solution.
i am running my job on 4 node and its updating 1 million records.
I am using oracle enterprise stage for reading and writing the data.
I am reading same table in source and trying to update after dome transformation in target stage.
Code: Select all
ORA,3: Open failed for update: (...)
update is: SQL Statement
sqlcode is: -60
esql complaint: ORA-00060: deadlock detected while waiting for resource
ORA,3: Unable to use a record for update
ORA,3: Records inserted: 0 (...)
ORA,3: the runLocally() of operator [ORA], partition 3 of 4, processID 5460100 on node3 failed.
ORA,3: Input 0 consumed 53 records.
ORA,3: Output 0 produced 0 records.
ORA,3: Operator terminated abnormally: runLocally did not return APT_StatusOk