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

RCR to RRDI

Questions
Tags
Users
Badges
Angelo Corna
(263●5●83●83) edited
Sep 16 '13, 5:20 a.m.
We've an RQM 2.0.1.1 environment with RCR 1.0 and now we're migrating to 3.0.1 version.
Following the infocenter instructions, after the RQM repository migration, we need to run the jts/setup.
On DatawareHouse configuration step, if I specify the RCR DW db (RIDW), RQM say me that the DB is reachable but there aren't the tables and propose me to create them (so, probably, all the DW data will be deleted). 
Is correct to specify the RCR DW db or must I create another empty db (but at this point I don't know how can I migrate the DW data from RIDW db to new DW db)?

Thanks in advance.
Bye.

0 votes

3 answers
5,525 views
0 votes

3 answers

Permanent link
Francesco Chiossi
(5.7k●1●11●19) Sep 16 '13, 5:18 a.m.
Hello Angelo,

from the following document: Reporting and the upgrade process
http://pic.dhe.ibm.com/infocenter/clmhelp/v3r0m1/topic/com.ibm.jazz.install.doc/topics/c_understand_upgrade_reporting.html

If you have Rational Quality Manager version 2 with Rational Common Reporting

You can upgrade the Rational Common Reporting solution that was available with Rational Quality Manager version 2.0.1 and above to Rational Reporting for Development Intelligence, which adds additional reporting support for Requirements Management and the ability to author and customize reports. Rational Reporting for Development Intelligence requires a separate installation (see Installing Rational Reporting for Development Intelligence).

If you are using Rational Common Reporting, you should upgrade Rational Quality Manager before upgrading the other products. In the post-upgrade setup, while specifying the data warehouse, you should select the existing Rational Common Reporting data warehouse as the common data warehouse for all of the version 3 applications. This will allow for a smooth migration of your version 2 reporting data.

After upgrading the data warehouse using the setup wizard, do not run the data collection jobs in Rational Common Reporting. You must uninstall Rational Common Reporting and install Rational Reporting for Development Intelligence before you can run any Cognos-based reports. If you run the data collection jobs in Rational Common Reporting after the upgrade, the data in the data warehouse will be duplicated or corrupted.

For additional details about Rational Reporting for Development Intelligence, see Architecture of Rational Reporting for Development Intelligence.


Best Regards
Francesco

0 votes

Permanent link
Angelo Corna
(263●5●83●83) Sep 16 '13, 8:35 a.m.
 Francesco,

thanks for your response.
I've already see the instructions attached from you but unfortunately, like explained on my post, on DatawareHouse configuration step, if I specify the RCR DW db (RIDW), RQM say me that the DB is reachable but there aren't the tables and propose me to create them (so, probably, all the DW data will be deleted). 

Any ideas?

Thanks in advance.

0 votes

Permanent link
Francesco Chiossi
(5.7k●1●11●19) Sep 16 '13, 8:50 a.m.
Hello Angelo,

I never went through this scenario myself, but I think there could definitely be less tables in the RCR DW compared to the CLM one, so maybe that's what the message is referencing.

If you have a test environment available, one approach could be to try creating the tables and validate afterwards that the old RQM data is still visible in the tables.

Best Regards
Francesco

0 votes

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.

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
× 2,357
× 403
× 119

Question asked: Sep 14 '13, 11:22 a.m.

Question was seen: 5,525 times

Last updated: Sep 16 '13, 8:50 a.m.

Confirmation Cancel Confirm