It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×2,353
×403

question asked: Aug 30 '12, 11:27 a.m.
question was seen: 4,088 times
last updated: Aug 30 '12, 2:46 p.m.

Related questions

problem connecting to existing 3.x data warehouse from new install of RRDI 2.0

0
Robin Parker (326●3●37●39) | asked Aug 30 '12, 11:27 a.m.
edited Aug 30 '12, 11:33 a.m.
Hi there,

We need to move our RRDI application server to our database server.
We already have RRDI v2.0  running on another server against the existing content store and data warehouse databases. Both the servers are running RHEL 5.x

We have not upgraded to CALM v4.0 yet so the data warehouse is still at v 3.0.x

I have shut down the existing RRDI and using the instructions, have installed WebSphere v8.0 and RRDI v2.0 on the database server.
I have started the setup wizard and run the server.config-linux.sh
I have successfully connected to port 10443 and run through the wizard, completing steps Configure Database Management System and Configure Content Store Database without error.
On the step Configure Data Warehouse  I fill out all the fields to the best of my knowledge and click Validate whereupon I receive the following error:

CRRRA0131E: An error happened when validating the database. 'com.ibm.rational.rrdi.setup.db.common.RRDIDBException: '.

There is nothing of interest in any of the logs in /opt/IBM/RRDI/setup/tool/JazzTeamServer/server/logs but the tomcat log contains the following:

16:08:00,091 [http-bio-10443-exec-16]  INFO .ibm.rational.rrdi.setup.resources.ResourceService  - CRRRA0137I: Loading the model
16:08:00,091 [http-bio-10443-exec-16]  INFO .ibm.rational.rrdi.setup.resources.ResourceService  - CRRRA0137I: Loading the model
16:08:00,093 [http-bio-10443-exec-16]  INFO .ibm.rational.rrdi.setup.resources.ResourceService  - CRRRA0139I: Loaded the model
16:08:00,093 [http-bio-10443-exec-16]  INFO .ibm.rational.rrdi.setup.resources.ResourceService  - CRRRA0139I: Loaded the model
16:08:00,093 [http-bio-10443-exec-16]  INFO .rrdi.setup.resources.DatabaseConfigurationService  - Enter 'com.ibm.rational.rrdi.setup.resources.DatabaseConfigurationService' service 'doPost'
16:08:00,093 [http-bio-10443-exec-16]  INFO .rrdi.setup.resources.DatabaseConfigurationService  - Enter 'com.ibm.rational.rrdi.setup.resources.DatabaseConfigurationService' service 'doPost'
16:08:00,125 [http-bio-10443-exec-16]  INFO .rrdi.setup.resources.DatabaseConfigurationService  - Exiting 'com.ibm.rational.rrdi.setup.resources.DatabaseConfigurationService' service 'doPost'
16:08:00,125 [http-bio-10443-exec-16]  INFO .rrdi.setup.resources.DatabaseConfigurationService  - Exiting 'com.ibm.rational.rrdi.setup.resources.DatabaseConfigurationService' service 'doPost'
16:08:00,305 [http-bio-10443-exec-8]  INFO .ibm.rational.rrdi.setup.resources.ResourceService  - CRRRA0137I: Loading the model
16:08:00,305 [http-bio-10443-exec-8]  INFO .ibm.rational.rrdi.setup.resources.ResourceService  - CRRRA0137I: Loading the model
16:08:00,306 [http-bio-10443-exec-8]  INFO .ibm.rational.rrdi.setup.resources.ResourceService  - CRRRA0139I: Loaded the model
16:08:00,306 [http-bio-10443-exec-8]  INFO .ibm.rational.rrdi.setup.resources.ResourceService  - CRRRA0139I: Loaded the model
16:08:00,307 [http-bio-10443-exec-8]  INFO .rrdi.setup.resources.DatabaseConfigurationService  - CRRRA0114I: No database configuration is found.
16:08:00,307 [http-bio-10443-exec-8]  INFO .rrdi.setup.resources.DatabaseConfigurationService  - CRRRA0114I: No database configuration is found.
16:08:00,342 [http-bio-10443-exec-25]  INFO .ibm.rational.rrdi.setup.resources.ResourceService  - CRRRA0137I: Loading the model
16:08:00,342 [http-bio-10443-exec-25]  INFO .ibm.rational.rrdi.setup.resources.ResourceService  - CRRRA0137I: Loading the model
16:08:00,343 [http-bio-10443-exec-25]  INFO .ibm.rational.rrdi.setup.resources.ResourceService  - CRRRA0139I: Loaded the model
16:08:00,343 [http-bio-10443-exec-25]  INFO .ibm.rational.rrdi.setup.resources.ResourceService  - CRRRA0139I: Loaded the model
16:08:49,260 [http-bio-10443-exec-13]  INFO rdi.setup.steps.EnterpriseDataWarehouseStepService  - CRRRA0123I: Start to validate the database.
16:08:49,260 [http-bio-10443-exec-13]  INFO rdi.setup.steps.EnterpriseDataWarehouseStepService  - CRRRA0123I: Start to validate the database.
16:08:49,333 [http-bio-10443-exec-21]  INFO .ibm.rational.rrdi.setup.resources.ResourceService  - CRRRA0137I: Loading the model
16:08:49,333 [http-bio-10443-exec-21]  INFO .ibm.rational.rrdi.setup.resources.ResourceService  - CRRRA0137I: Loading the model
16:08:49,335 [http-bio-10443-exec-21]  INFO .ibm.rational.rrdi.setup.resources.ResourceService  - CRRRA0139I: Loaded the model
16:08:49,335 [http-bio-10443-exec-21]  INFO .ibm.rational.rrdi.setup.resources.ResourceService  - CRRRA0139I: Loaded the model
16:08:49,346 [http-bio-10443-exec-13]  INFO ibm.rational.rrdi.setup.db.common.RRDIDBConnection  - Database connection URL: jdbc:db2://localhost:50000/RIDW
16:08:49,346 [http-bio-10443-exec-13]  INFO ibm.rational.rrdi.setup.db.common.RRDIDBConnection  - Database connection URL: jdbc:db2://localhost:50000/RIDW
16:08:49,440 [http-bio-10443-exec-13]  INFO ibm.rational.rrdi.setup.db.common.RRDIDBConnection  - Database connection URL: jdbc:db2://localhost:50000/RIDW
16:08:49,440 [http-bio-10443-exec-13]  INFO ibm.rational.rrdi.setup.db.common.RRDIDBConnection  - Database connection URL: jdbc:db2://localhost:50000/RIDW
16:08:49,975 [http-bio-10443-exec-13] ERROR .ibm.rational.rrdi.setup.db.common.RRDIDBException  -
16:08:49,975 [http-bio-10443-exec-13] ERROR .ibm.rational.rrdi.setup.db.common.RRDIDBException  -
16:08:49,976 [http-bio-10443-exec-13] ERROR rdi.setup.steps.EnterpriseDataWarehouseStepService  - com.ibm.rational.rrdi.setup.db.common.RRDIDBException:
16:08:49,976 [http-bio-10443-exec-13] ERROR rdi.setup.steps.EnterpriseDataWarehouseStepService  - com.ibm.rational.rrdi.setup.db.common.RRDIDBException:
16:08:49,977 [http-bio-10443-exec-13] ERROR rdi.setup.steps.EnterpriseDataWarehouseStepService  - CRRRA0131E: An error happened when validating the database. 'com.ibm.rational.rrdi.setup.db.common.RRDIDBException: '.
16:08:49,977 [http-bio-10443-exec-13] ERROR rdi.setup.steps.EnterpriseDataWarehouseStepService  - CRRRA0131E: An error happened when validating the database. 'com.ibm.rational.rrdi.setup.db.common.RRDIDBException: '.
16:08:49,977 [http-bio-10443-exec-13]  INFO rdi.setup.steps.EnterpriseDataWarehouseStepService  - CRRRA0124I: Exit to validate the database.
16:08:49,977 [http-bio-10443-exec-13]  INFO rdi.setup.steps.EnterpriseDataWarehouseStepService  - CRRRA0124I: Exit to validate the database.

I cannot see anything that I can begin to debug with in there and am stuck as result.

Does anyone have any suggestion on how I should proceed?

Many Thanks,

Robin.

One answer

Most liked answers ↑|Newest answers|Oldest answers

1
permanent link
Rosa Naranjo (2.9k●1●17●23) | answered Aug 30 '12, 2:46 p.m.
FORUM MODERATOR / JAZZ DEVELOPER
Are you trying to connect to the same (same as your existing RRDI 2.0) DW db from your new RRDI 2.0 installation? If so, then try to locate the connection parameters to the DB.  perhaps this ( //localhost:50000/RIDW ) is not the correct location of your existing DW db.

Post a screenshot of your setup page. What does it suggest as the default connection parameter to located the RIDW.  Does it look something like this:  //localhost:50000/RIDW:user=user1;password={password};

Review the required information worksheet:  http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0/index.jsp?topic=%2Fcom.ibm.rational.rrdi.admin.doc%2Ftopics%2Fc_preinstall_info_worksheet.html

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.