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

[closed] RM - Full ETL Load

Questions
Tags
Users
Badges
VK L
(817●7●157●159) 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.

Thanks.

0 votes

2 answers
6,805 views
0 votes

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.7k●1●11●19) Jan 06 '15, 2:58 a.m.
Hello Valli,

from:

Running the data collection jobs
http://www-01.ibm.com/support/knowledgecenter/SSYMRC_5.0.2/com.ibm.rational.reporting.admin.doc/topics/t_running_the_data_collection_jobs.html

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

0 votes

Comments
VK L
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
(817●7●157●159) 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.

Thanks.

0 votes

Ask a question
Guidelines
FAQ
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
× 6,177
× 403

Question asked: Jan 06 '15, 2:03 a.m.

Question was seen: 6,805 times

Last updated: Jan 08 '15, 8:34 a.m.

Confirmation Cancel Confirm