Four Stars

[resolved] Question on use of tOracleRollback & tOracleCommit

Hi,
If I want to do a rollback whenever any component in my job fails, will the way I have my tOracleRollback and tOracleCommit components set up do that? Or is it only going to do a commit or rollback whenever the tOracleOutput component is successful or unsuccessful?
1 ACCEPTED SOLUTION

Accepted Solutions

Re: [resolved] Question on use of tOracleRollback & tOracleCommit

Only on the start component... both the rollback and commit will be connected.
for example

tDBInput--->tMap--->tDBOutput
| |
OnOK OnError
| |
| rollback
commit
4 REPLIES

Re: [resolved] Question on use of tOracleRollback & tOracleCommit

use "OnSubjobOK" from the start component of the particular subjob (the one with a green background, the start of the flow) rather than onComponentOK on the DB output.
as a rule of thumb, onComponentOK should be avoided. This connector can have different behavior depending on the source component-- so unless you know what you're doing, its a good idea to just avoid using it all together.
Four Stars

Re: [resolved] Question on use of tOracleRollback & tOracleCommit

So would I have to set it on only the first component or would I have to set OnSubjobOK for every component up to the Staging Table tOracleOutput component? What about the tOracleRollback? How would the rollback know what the table name that it needs to commit or rollback if it isn't coming out of the Staging Table tOracleOutput component? Thanks.

Re: [resolved] Question on use of tOracleRollback & tOracleCommit

Only on the start component... both the rollback and commit will be connected.
for example

tDBInput--->tMap--->tDBOutput
| |
OnOK OnError
| |
| rollback
commit
Four Stars

Re: [resolved] Question on use of tOracleRollback & tOracleCommit

Great, I got it. Thanks so much John for your help!