Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Rational Insight few Data is missing and update only missing data

 Hi All,

We had huge data migration to RTC and those are created in Insight with ETL jobs. RTC work tickets are created in Request  table but few tables like "Request Relational Link"  are not updated and when we create report using links though Work Tickets are present these are not listed because of missing Relational Links.

 Can I know how to track these and rerun the ETL jobs?
 I know that ETL jobs run as per schedule,I think it updates the Requests(In Insight) which are recently updated in RTC.
Is there way to get difference of WTs in RTC and Insight and update those in Insight?

Thanks,
Kavita

0 votes



One answer

Permanent link
Hello Kavita,

you might need to run a Full ETL job for RTC.
It's available through the data manager client in the Insight Catalog:
Rational insight ETL > Builds and JobStreams > Jobs > RTC Jobs > RTC_ODSX.X.X_FullLoad

Note: if you have a large RTC repository this job can take a considerable time to execute (up to several days).
Make sure that the scheduled ETL jobs are temporarily disabled until the Full Load completes.

Best Regards,

Francesco Chiossi



0 votes

Comments

Hi Francesco,

As our RTC repository has huge data. Is there other way like creating query with time frame/ WI type so that only those work tickets get updated.
 Please let me know how to do that or any document on this.

Thanks,
Kavita
 

Your answer

Register or log in 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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: Aug 20 '15, 6:49 a.m.

Question was seen: 3,189 times

Last updated: Aug 30 '15, 10:23 a.m.

Confirmation Cancel Confirm