Job fails when executed by a sequence

dsxneitek · Post by **dsxneitek** » Fri Jun 21, 2013 4:00 pm

I have the

tablex --> transformer --> tablex_upd

It was working fine but now it just failed when it was executed by the sequence... If I executed the job alone, it works fine...

chulett · Post by **chulett** » Fri Jun 21, 2013 6:18 pm

Going to need a wee bit more information than that to be able to help you. I split this post out from the five year old one you jumped on the end of - is your error related somehow? Regardless, we'll need the details of your error please. And next time, please start your own post when needing help with an issue.

chulett · Post by **chulett** » Mon Jun 24, 2013 9:26 am

Please do not continue to run around and jump on the end of anything you can find that you think is related. I've deleted those posts and added the details for you in this post.

dsxneitek wrote:I'm having the same error message but before it I get the

"ORA 0006 deadlock detected while waiting for resource"

and then after telling it could not perform the update, now it shows the:
" ORA-24381: error(s) in array DML. "

This fails when I exectue the sequence and in the sequence is a job that does the update but if I execute the job alone, this errors do not appear.

Let's keep the conversation here, please.

rsomiset · Post by **rsomiset** » Mon Jun 24, 2013 9:37 am

Could you please give us the details of on how many nodes and partitions the sequence job ran when it failed and the parallel job ran when it succeeded?

--
Raj

priyadarshikunal · Post by **priyadarshikunal** » Mon Jun 24, 2013 12:52 pm

Along with that are you writing to that table from more than one job in that sequence.