It's all about the answers!

Ask a question

ETL process died - how do I debug?

Jackie Albert (1.6k14744) | asked Oct 17 '13, 10:06 a.m.
My ETL has been running with no problems lately, but last night it died with an unusual failure
[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

permanent link
Thomas Mathews (10614) | answered Oct 17 '13, 2:02 p.m.

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.

Hope this help!

Your answer

Register or to post your answer.