ETL process died - how do I debug?
My ETL has been running with no problems lately, but last night it died with an unusual failure
Is there any way to get more information about this status message to understand what caused my process to die? I've done some searching and found no information so far.
[INTERNAL - 00:07:24] JobStream Node 57 'RTC_Workitem4.0.1'; Pending -> Executing
[INTERNAL - 00:07:24] JobStream Node 57 'RTC_Workitem4.0.1'; initializing
[PROGRESS - 00:07:25] JobStream Node 57 'RTC_Workitem4.0.1'; executing (pid 4444)
[DETAIL - 00:07:26] JobStream Node 57 'RTC_Workitem4.0.1'; component 'RTC_Workitem4.0.1', RunId 21, AuditId 1519228
[INTERNAL - 03:46:40] JobStream Node 57 'RTC_Workitem4.0.1'; Executing -> Failed
[PROGRESS - 03:46:40] JobStream Node 57 'RTC_Workitem4.0.1'; failed [process died - status 143]
[VARIABLE - 03:46:40] RESULT = FALSE
Is there any way to get more information about this status message to understand what caused my process to die? I've done some searching and found no information so far.
One answer
Hello Jackie,
Is this ETL being executed from DM or is it being executed as a published task on the BI server ?
If being executed from DataManager I would suggest enabling all logging from within DM < by right clicking on the job and selecting properties >
Click on logging tab and enable all the tracing and click ok.
Also, checking ri_jdbc.log and the ccm.log or rtc.log.
Insight MustGather Document.
http://www-01.ibm.com/support/docview.wss?uid=swg21645071
Hope this help!