Unexpected oracle update commit after an tOracleOutputBulkExec failure

Anonymous — Fri, 29 Jul 2016 10:35:35 GMT

Hello all,

This is my first post, i don't know if i put into the right place.

So let me explain my problem :

I have a daily job running on linux for a customer. Lastly i had an issue due to "sqlldr" was missing when i tried to use the tOracleOutputBulkExec component. This was due to an misconfiguration, but the thing is that my job commited an update (tOracleRow), however i have just a final commit totally at the end...

My job : Start (0)-> update a field (no commit on tOracleRow) (1) -> select and insert via tOracleOutputBulkExec (2) -> a lot of thing (3) -> commit (4).

So the job crash at step 2 and don't do other things, but it commits step 1. I have checked the java code, there is no commit on error.There is no commit option on the tOracleRow.
Do you have an idea? Is a way to rollback all the job if this error is raised?
The job was created on Talend 5.6.
Thanks for looking on this problem.

Best regards,
Sébastien

Re: Unexpected oracle update commit after an tOracleOutputBulkExec failure

Anonymous — Sat, 30 Jul 2016 14:45:54 GMT

I am not sure about the behaviour of Oracle if the connection will closed uncommitted. I always recommend a controlled way. Use at step 2 the OnSubjobError trigger and trigger a tOracleRollback with a following tDie.
By the way, you should use an explicit tOracleConnection component and use it in the components, only this way you span a transaction over multiple steps!

topic Re: Unexpected oracle update commit after an tOracleOutputBulkExec failure in Talend Studio

Unexpected oracle update commit after an tOracleOutputBulkExec failure

Re: Unexpected oracle update commit after an tOracleOutputBulkExec failure