DSXchange

Hi,
I am using Oracle as target with 'User defined update only' option.
While running the job with 4 node configuration it's throwing deadlock problem to update approx. 63,000 records .
There is no duplicate record in the input stream, what could be the reason ?

Thanks in advance !
Ankita

ankita wrote:Hi,
I am using Oracle as target with 'User defined update only' option.
While running the job with 4 node configuration it's throwing deadlock problem to update approx. 63,000 records .
There is no duplicate record in the input stream, what could be the reason ?

Thanks in advance !
Ankita

Check is there any other process trying to do the update or insert at the same time, when your job is running to do the same.

Try running on a single node, just for debuggin purposes and see if the problem persists.

With single node it's running fine in dev, but the same job is running in production with 4 node configuration without any issue.
It's failing even with input hash partitoned with keys.

Why can it fail with 4 node ? Can it fail even if records are different but
belong to same Oracle block ?

No other job is running in dev, so there should not be any parallel process trying to load same table.

What is the exact error message that you are getting?

The error message starts with " Open failed for update " followed by the update query and finally with below error code,

sqlcode is: -60
esql complaint: ORA-00060: deadlock detected while waiting for resource

Ask your DBA to check the trace file to get exacts on what exactly happened.