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
Oracle deadlock problem
Moderators: chulett, rschirm, roy
Re: Oracle deadlock problem
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.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
Regards,
Abburi
Abburi
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.
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.
Ankita