How to Log Errors In every Component of tOracleDBRow in a single Job.

[AbassYawar]

how can i trace and catch errors of Each Component in the job having errors in TDBRow if any in sql queries.

when i use tlogcatcher it catches the error of first error only when tdie is marked on , it marks only that error and rest of the job fails.

Any solution for that.

[Alaor_Silva]

Hi @Abass Yawar​,

Try to use the Catcher completely separated from the other SubJobs,

Then for the Catcher configuration use according to your needs

 

If you want to catch the error from all the Oracle components, don't let them die on Error,

[AbassYawar]

Thanks @Alaor Silva​ 

i have tried this but, the job fails when it encounters an error in any of the components and doesn't move forward.

i want is to catch errors on each tdbrow if any but without job failure.

while as when i use the die on error then the job does catch error but the job fails and doesn't move forward.

Any solution for that.😥

[Anonymous]

@Abass Yawar​ You need to move the tDBRow.... to child job and use tRunJob to call the child job in main job, eg:

child job1:

tDBRow--bababa

child job2:

tDBRow..bababa

main job:

tRunJob1(call child job1)

|onsubjobok

tRunJob2(call child job2)

Uncheck 'die on error' box on each tRunJob, use tLogCapther to capture the error the components encounters an error.

Regards

Shong