Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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