It's all about the answers!

Ask a question

[closed] RM - Full ETL Load

VK L (8177152159) | asked Jan 06 '15, 2:03 a.m.
closed Jan 08 '15, 8:34 a.m.
 Hi All,
What is the sequence of jobs to execute for a full data load on RM-Data Warehouse.

I tried a Requirements - full load and it failed. Due to this, all the data is missing in RRDI.

Please advise.


The question has been closed for the following reason: "The question is answered, right answer was accepted" by valli Jan 08 '15, 8:34 a.m.

Accepted answer

permanent link
Francesco Chiossi (5.7k11119) | answered Jan 06 '15, 2:58 a.m.
Hello Valli,


Running the data collection jobs

The sequence in which the jobs are run is:
  • Jazz Team Server/Common and Repository
  • Rational Team Concert/Common and Repository
  • Rational Quality Manager/Common and Repository
  • Rational Team Concert/APT and SCM
  • Rational Team Concert/Work Items and Build
  • Rational Quality Manager/Work Items
  • Rational Quality Manager/Quality Management
  • Jazz Team Server/Requirements
  • Jazz Team Server/Star

Regarding your problem, some lookup tables (links or relations between different elements) are cleaned and repopulated every time the job is executed.
If this is the data you are missing the regular delta load for all applications might be enough to fix it.

Best Regards,

Francesco Chiossi
VK L selected this answer as the correct answer

VK L commented Jan 06 '15, 3:15 a.m.

 Delta Load is updating only the recent changes and all the historical data is completely missing.

I just get 10 rows in place of 100 rows of data.

One other answer

permanent link
VK L (8177152159) | answered Jan 06 '15, 3:05 a.m.
 Hi Francesco,
Issue came up after i executed the Full-load of "Requirements" job under RM-Admin page. The full load failed with errors and thereafter, there is not much data in the RM-DW-Tables

Link to error related post:

The delta jobs for RRC is not fixing the issue. Please advise.