It's all about the answers!

Ask a question

Rational Insight : migrateDW to the current version


Kiran A (311561) | asked 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


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

I would suggest to search the documentation of Insight for migrateDW

2 answers



permanent link
Cathy Xu (3901515) | answered 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


permanent link
Jackie Albert (1.6k14947) | answered 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.

Your answer


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