It's all about the answers!

Ask a question

Is there a way to run the WI data collection job independent of (i.e. offline to) the JTS ?

long TRUONG (3654121147) | asked Jul 07 '14, 8:38 p.m.
 Our WI job run for days, it last failed on Jun 18th, after running for 7 days, 22 hrs; since, various scheduled maintenance, physical host crashes, and JTS crashes had prevented any successful WI job. The last good WI job was on June 9th.

We just wonder if we ever catch up with a good WI job. 
Is there any way to run (and update the Warehouse) the WI job by itself or together with the full collection, independent of any JTS interruption ?
Or is there a way to "save & continue" so we can restart the WI job after a JTS interruption ?
We are on CLM 4.0.3 without  RQM, and do not use RTC Source Control nor Build.

Lily Wang commented Jul 08 '14, 2:12 a.m.

As I known, the recovery checkpoints for ETL feature has been introduced in RTC 4.0.1. Please see

But this may not help on your issue because:
1. The feature is used for initial ETL collection
2. The feature breaks ETL into 50 days trunk. But your issue was happened since 9th-Jun, which less than 50 days till today.
In your case, I suggest you contact Rational support and found why the work item ETL job run for such a long time, which seemed not correct. Also JTS should not crash due to the ETL, which maybe another issue.

long TRUONG commented Jul 08 '14, 8:25 p.m.

Thx for the tip Lily. We do have a long running [PMR 53034,49R,000], which is still open, for the slowness of the WI collection job. SWAT will advise us if we should submit a separate PMR for the failed WI job.

 We don't believe any JTS or server host crashes were due to the ETLs.

One answer

permanent link
Stephanie Bagot (2.1k1513) | answered Jul 15 '14, 11:26 a.m.
You seem like a good candidate for the new DCC feature. Depending on what version you are on, it may be better to move to DCC, which eliminates a lot of bottlenecks found in typical Java ETL performance. You can search the information center for "Data Collection Component" and review the documentation (note this is available in 5.0).

long TRUONG commented Jul 15 '14, 6:34 p.m. | edited Jul 15 '14, 7:04 p.m.

Thx Stephanie for the DCC feature. Unfortunately the DCC is introduced with 5.0.1 (or is it 5.0), and our upgrade policy prevent us from jumping to last release 5.0 from our scheduled mid-Sep upgrade to 4.0.6. It looks like our PMR will result in a hotfix:Defect: (for a method that fetches states added since a given time).

Your answer

Register or to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.