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

Rational Insight : migrateDW to the current version

Questions
Tags
Users
Badges
Kiran A
(31●2●5●61) Apr 16 '18, 4:33 a.m.

Hi All,


I am in the process of doing staging server for Rational Insight (1.1.1.6) and done with the CLM staging server and its up (CLM 5.0.2). While configuring IBM Rational Insight Data Warehouse in Rational Insight Setup page I got this warning message "The database was created with a previous version. Run the migrateDW migration tool to migrate the data warehouse to the current version." 

Can anyone tell me/guide me, what is that exact problem for the warning message and Do I need to migrate Data Warehouse to proceed further activities?

Any solution...

Thanks and Regards,
Kiran

0 votes

Comments
Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Apr 16 '18, 7:57 a.m.

I would suggest to search the documentation of Insight for migrateDW

2 answers
3,632 views
0 votes

2 answers

Permanent link
Cathy Xu
(390●1●5●15) Apr 16 '18, 9:37 p.m.

Hi Kiran,

You need to have a machine with Rational Insight Development Tools installed and run migrateDW command:
Windows
migrateDW.exe -dbServer hostname -dbPort port_number -dbName database_name -dbType database_type -dbUser user_name -dbPassword password -modifyViews -migrate
Linux, AIX
migrateDW.sh -dbServer hostname -dbPort port_number -dbName database_name -dbType database_type -dbUser user_name -dbPassword password -modifyViews -migrate

For more details:
https://www.ibm.com/support/knowledgecenter/SSRL5J_1.1.1.6/com.ibm.rational.raer.migrating.doc/topics/t_migrate_dw.html

1 vote

Permanent link
Jackie Albert
(1.6k●1●49●47) Apr 16 '18, 9:02 a.m.

 Yes, you'll need to apply some changes to the data warehouse.  There are some CLM-specific tables that are needed besides the default Insight tables.  It should be covered by the "repotools upgradeWarehouse" step,  and as previously suggested the documentation covers the steps.

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
× 7,592

Question asked: Apr 16 '18, 4:33 a.m.

Question was seen: 3,632 times

Last updated: Apr 16 '18, 9:37 p.m.

Confirmation Cancel Confirm