Failed to connect RIDW data source connection in Cognos

Anurag Rajput (80●1●16●23) | asked Aug 09 '13, 12:33 p.m.
edited Aug 09 '13, 1:10 p.m.

HI All,

I am trying to configure RRDI 2.0.3 with Clm 4.0.1. While Deploying reporting components I am getting a warning message as "The RIDW data source connection in Cognos failed to connect. Check if the database client is installed correctly or additional configuration is required".

How can i solve this issue? Any help would be appreciated.

Below are the details of rrdi_setup.log file

08/09/2013 12:35:38,836 INFO com.ibm.rational.rrdi.setup.internal.AppInitializer : G:\RRDI_I~1\setup\tool\JAZZTE~1\server\conf\rrdi

08/09/2013 12:43:25,525 INFO com.ibm.rational.rrdi.setup.service.SelfRegisterService : CRRRA0179I: Begin setup of Jazz Team Server

08/09/2013 12:44:06,959 INFO com.ibm.rational.rrdi.setup.biserver.utils.BIServerUtil : Repo Tools

Provisioning using "G:\RRDI_Installation_Path\setup\tool\JazzTeamServer\server\conf\jts\provision_profiles".

Jazz Foundation - Core Libraries, Version 4.0 (RJF-I20120531-1400)

CRJAZ1728E An unexpected error has been detected. See the log file "G:\RRDI_Installation_Path\setup\tool\JazzTeamServer\server\repotools-jts_setup.log" for more details.

08/09/2013 12:44:06,966 INFO com.ibm.rational.rrdi.setup.service.SelfRegisterService : CRRRA0180I: Complete setup of Jazz Team Server

08/09/2013 12:45:14,849 INFO com.ibm.rational.rrdi.setup.service.SelfRegisterService : CRRRA0179I: Begin setup of Jazz Team Server

08/09/2013 12:45:18,780 INFO com.ibm.rational.rrdi.setup.biserver.utils.BIServerUtil : Repo Tools

Provisioning using "G:\RRDI_Installation_Path\setup\tool\JazzTeamServer\server\conf\jts\provision_profiles".

Jazz Foundation - Core Libraries, Version 4.0 (RJF-I20120531-1400)

CRJAZ1728E An unexpected error has been detected. See the log file "G:\RRDI_Installation_Path\setup\tool\JazzTeamServer\server\repotools-jts_setup.log" for more details.

08/09/2013 12:45:18,783 INFO com.ibm.rational.rrdi.setup.service.SelfRegisterService : CRRRA0180I: Complete setup of Jazz Team Server

08/09/2013 12:47:25,390 INFO com.ibm.rational.rrdi.setup.service.SelfRegisterService : CRRRA0179I: Begin setup of Jazz Team Server

08/09/2013 12:48:21,241 INFO com.ibm.rational.rrdi.setup.biserver.utils.BIServerUtil : Repo Tools

Provisioning using "G:\RRDI_Installation_Path\setup\tool\JazzTeamServer\server\conf\jts\provision_profiles".

Jazz Foundation - Core Libraries, Version 4.0 (RJF-I20120531-1400)

Requesting setup steps from server: https://teklap14.gsc.zz:10443/jts

--- Starting Setup For Application: "Rational Jazz Team Server (https://teklap14.gsc.zz:10443/jts/)" ---

Executing step: Introduction

Welcome to the Jazz Team Server RepoTools setup wizard! This setup wizard contains configuration steps for the applications you just installed.

Initializing other locally installed applications. This may take a few moments...

Executing step: Configure Public URI

This Jazz Team Server generates absolute URIs to resources used in stored artifacts, in mail notifications, feeds, for copying to the system clipboard, for Web access and for stable resource identification across all applications. These URIs are rooted by a "Public URI" declared for this Jazz Team Server.

These generated URIs may be referenced in contexts that are outside of the local network in which clients typically access your server (e.g., from another internet domain, or outside a corporate firewall). For example, you may have a proxy server outside your firewall that forwards these requests to the originating Jazz Team Server inside your local network, and you want these public URIs to be generated relative to that proxy. Therefore it is important that you choose a public URI that is fully qualified, and likely to remain stable over time. For additional help, please see the Planning your URIs topic.

Once the resources have been stored in the repository of this Jazz Team Server, the public URI (which includes the fully qualified hostname) cannot be changed. If the application moves to another server, the URI must remain stable, using DNS to re-route the hostname to another physical machine.

Using properties file entry: configure.public.uri.page:server.webapp.url=https://teklap14.gsc.zz:10443/jts

Using properties file entry: configure.public.uri.page:server.webapp.url.confirm=true

Performing configuration validation...

Updating service property configurations...

Executing step: Configure Database

By default, this Jazz Team Server includes a pre-configured database using a JDBC connection. You can either keep this default or choose a different database vendor and/or connection type.

The type of connection pool to use (either J2EE or JDBC).

Using properties file entry: configure.database.page:db.type=JDBC

The JDBC vendor.

Using properties file entry: configure.database.page:db.vendor=DERBY

Using properties file entry: configure.database.page:db.jdbc.location=conf/jts/derby/repositoryDB

Performing configuration validation...

Updating service property configurations...

Executing step: Configure Data Warehouse Database

The type of connection pool to use (either J2EE or JDBC).

Using properties file entry: data.warehouse.page:db.type=JDBC

The JDBC vendor.

Using properties file entry: data.warehouse.page:db.vendor=DERBY

Using properties file entry: data.warehouse.page:db.jdbc.location=conf/jts/derby/warehouseDB

Using properties file entry: data.warehouse.page:db.net.port=1527

Performing configuration validation...

Updating service property configurations...

Executing step: Configure E-mail Notification

Some Server and Application components use e-mail to communicate with users. By default, e-mail notifications are not enabled. To enable e-mail notification, select "Enabled", set the e-mail configuration properties, and optionally select which set of users should receive e-mails (by default all users receive e-mail).

Subscribers of work items and other collaboration artifacts can be notified of changes via e-mail. This property is the global switch for enabling and disabling e-mail notifications.

Using properties file entry: configure.email.page:notification.mail.enabled=false

Performing configuration validation...

Updating service property configurations...

Executing step: Configure User Registry

Jazz Team Server relies on a user registry to provide basic information about users and groups. You may choose one of these options for your user registry:

The user registry used for authentication and user import. Valid types are LDAP, TOMCAT, DETECT, and UNSUPPORTED.

Using properties file entry: user.registry.page:user.registry.type=DETECT

Performing configuration validation...

Updating service property configurations...

Executing step: Create Administrative User

You are currently logged in as the default user (ADMIN). You may now create an administrator account that will be created in the Jazz Team Server. Your new account will have the JazzAdmins role, which will allow you to log in to the Admin UI.

Using properties file entry: create.user.page:userId=ADMIN

Using properties file entry: create.user.page:password=********

Using properties file entry: create.user.page:name=Setup Admin

Using properties file entry: create.user.page:emailAddress=none@none.none

Performing validation...

Validation error for service "com.ibm.team.repository.service.internal.setup.ContributorValidationRestService":

CRJAZ2161E The new user could not be created because a user with the user id "ADMIN" already exists.

CRJAZ2438E An error occurred while invoking the service https://teklap14.gsc.zz:10443/jts/service/com.ibm.team.repository.service.internal.IAdminRestService/contributor.

CRJAZ2247E There was an error executing setup: "CRJAZ2161E The new user could not be created because a user with the user id "ADMIN" already exists.". Check the log for more details.

CRJAZ2236E There was an error executing setup: "CRJAZ2161E The new user could not be created because a user with the user id "ADMIN" already exists."

Check the log at "G:\RRDI_Installation_Path\setup\tool\JazzTeamServer\server\repotools-jts_setup.log" for more information.

08/09/2013 12:48:21,248 INFO com.ibm.rational.rrdi.setup.service.SelfRegisterService : CRRRA0180I: Complete setup of Jazz Team Server

08/09/2013 12:49:16,781 INFO com.ibm.rational.rrdi.setup.service.SelfRegisterService : CRRRA0179I: Begin setup of Jazz Team Server

08/09/2013 12:49:16,884 INFO com.ibm.rational.rrdi.setup.service.SelfRegisterService : CRRRA0171I: status:200

08/09/2013 12:49:16,903 INFO com.ibm.rational.rrdi.setup.service.SelfRegisterService : CRRRA0171I: status:200

08/09/2013 12:49:16,904 INFO com.ibm.rational.rrdi.setup.service.SelfRegisterService : CRRRA0174I: root service is:https://teklap14.gsc.zz:10443/rrdi/scr

08/09/2013 12:49:16,905 INFO com.ibm.rational.rrdi.setup.service.SelfRegisterService : RRDI Setup (https://teklap14.gsc.zz:10443/rrdi)CRRRA0175I: is registered with the Jazz Team Server.

08/09/2013 12:49:16,925 INFO com.ibm.rational.rrdi.setup.service.SelfRegisterService : CRRRA0171I: status:302

08/09/2013 12:49:39,680 INFO com.ibm.rational.rrdi.setup.service.SelfRegisterService : CRRRA0179I: Begin setup of Jazz Team Server

08/09/2013 12:50:50,782 INFO com.ibm.rational.rrdi.setup.service.SelfRegisterService : CRRRA0179I: Begin setup of Jazz Team Server

08/09/2013 12:51:04,414 INFO com.ibm.rational.rrdi.setup.service.SelfRegisterService : CRRRA0179I: Begin setup of Jazz Team Server

08/09/2013 12:51:04,469 INFO com.ibm.rational.rrdi.setup.service.SelfRegisterService : CRRRA0171I: status:408

08/09/2013 12:51:04,487 INFO com.ibm.rational.rrdi.setup.service.SelfRegisterService : CRRRA0171I: status:200

08/09/2013 12:51:04,488 INFO com.ibm.rational.rrdi.setup.service.SelfRegisterService : CRRRA0174I: root service is:https://teklap14.gsc.zz:10443/rrdi/scr

08/09/2013 12:51:04,488 INFO com.ibm.rational.rrdi.setup.service.SelfRegisterService : RRDI Setup (https://teklap14.gsc.zz:10443/rrdi)CRRRA0175I: is registered with the Jazz Team Server.

08/09/2013 12:51:04,505 INFO com.ibm.rational.rrdi.setup.service.SelfRegisterService : CRRRA0171I: status:200

08/09/2013 12:54:51,536 INFO com.ibm.rational.rrdi.setup.service.SelfRegisterService : CRRRA0179I: Begin setup of Jazz Team Server

08/09/2013 12:54:51,587 INFO com.ibm.rational.rrdi.setup.service.SelfRegisterService : CRRRA0171I: status:302

08/09/2013 12:54:51,607 INFO com.ibm.rational.rrdi.setup.service.SelfRegisterService : CRRRA0171I: status:200

08/09/2013 12:54:51,607 INFO com.ibm.rational.rrdi.setup.service.SelfRegisterService : CRRRA0174I: root service is:https://teklap14.gsc.zz:10443/rrdi/scr

08/09/2013 12:54:51,608 INFO com.ibm.rational.rrdi.setup.service.SelfRegisterService : RRDI Setup (https://teklap14.gsc.zz:10443/rrdi)CRRRA0175I: is registered with the Jazz Team Server.

08/09/2013 12:54:52,410 INFO com.ibm.rational.rrdi.setup.service.SelfRegisterService : CRRRA0171I: status:200

08/09/2013 14:07:48,262 INFO com.ibm.rational.rrdi.setup.resources.ResourceService : CRRRA0137I: Loading the model

08/09/2013 14:07:49,097 INFO com.ibm.rational.rrdi.setup.resources.ResourceService : CRRRA0139I: Loaded the model

08/09/2013 14:07:49,100 INFO com.ibm.rational.rrdi.setup.resources.ResourceService : CRRRA0115I: No DBMS is found.

08/09/2013 14:11:49,835 INFO com.ibm.rational.rrdi.setup.resources.ResourceService : CRRRA0137I: Loading the model

08/09/2013 14:11:49,838 INFO com.ibm.rational.rrdi.setup.resources.ResourceService : CRRRA0139I: Loaded the model

08/09/2013 14:11:49,966 INFO com.ibm.rational.rrdi.setup.resources.ResourceService : CRRRA0137I: Loading the model

08/09/2013 14:11:49,968 INFO com.ibm.rational.rrdi.setup.resources.ResourceService : CRRRA0139I: Loaded the model

08/09/2013 14:11:49,970 INFO com.ibm.rational.rrdi.setup.resources.DatabaseConfigurationService : CRRRA0114I: No database configuration is found.

08/09/2013 14:11:49,991 INFO com.ibm.rational.rrdi.setup.resources.ResourceService : CRRRA0137I: Loading the model

08/09/2013 14:11:49,993 INFO com.ibm.rational.rrdi.setup.resources.ResourceService : CRRRA0139I: Loaded the model

08/09/2013 14:23:44,376 INFO com.ibm.rational.rrdi.setup.steps.EnterpriseContentStoreStepService : CRRRA0068I: Start to validate the database.

08/09/2013 14:23:44,402 INFO com.ibm.rational.rrdi.setup.resources.ResourceService : CRRRA0137I: Loading the model

08/09/2013 14:23:44,404 INFO com.ibm.rational.rrdi.setup.resources.ResourceService : CRRRA0139I: Loaded the model

08/09/2013 14:23:44,447 INFO com.ibm.rational.rrdi.setup.db.common.RRDIPreReqCreateDatabase : 1- RRDIPreReqCreateDatabase

08/09/2013 14:23:44,448 INFO com.ibm.rational.rrdi.setup.db.common.RRDIPreReqCreateDatabase : 1- RRDIPreReqCreateDatabase.validatePreReqDBCreation()

08/09/2013 14:23:44,448 INFO com.ibm.rational.rrdi.setup.db.common.RRDIPreReqCreateDatabase : RRDIPreReqCreateDatabase.validatePreReq()

08/09/2013 14:23:44,449 INFO com.ibm.rational.rrdi.setup.db.common.RRDIPreReqCreateDatabase : RRDIPreReqCreateDatabase.isLocalSetup()

08/09/2013 14:23:44,449 INFO com.ibm.rational.rrdi.setup.db.common.RRDIPreReqCreateDatabase : RRDIPreReqCreateDatabase.canCreateDatabase()

08/09/2013 14:23:44,449 INFO com.ibm.rational.rrdi.setup.db.common.RRDIPreReqCreateDatabase : RRDIPreReqCreateDatabase.canCreateDB2Database()

08/09/2013 14:23:44,450 INFO com.ibm.rational.rrdi.setup.db.common.RRDIPreReqCreateDatabase : RRDIPreReqCreateDatabase.getDB2UserGroupInformation()

08/09/2013 14:23:46,452 INFO com.ibm.rational.rrdi.setup.db.common.RRDIPreReqCreateDatabase : RRDIPreReqCreateDatabase.getWinAdminGroup()

08/09/2013 14:23:46,453 INFO com.ibm.rational.rrdi.setup.db.common.RRDIPreReqCreateDatabase : RRDIPreReqCreateDatabase.setWinAdminGroup()

08/09/2013 14:23:48,525 INFO com.ibm.rational.rrdi.setup.db.common.RRDIPreReqCreateDatabase : RRDIPreReqCreateDatabase.getDosCodepage()

08/09/2013 14:23:50,529 INFO com.ibm.rational.rrdi.setup.db.common.RRDIPreReqCreateDatabase : RRDIPreReqCreateDatabase.databaseExists()

08/09/2013 14:23:50,530 INFO com.ibm.rational.rrdi.setup.db.common.RRDIPreReqCreateDatabase : RRDIPreReqCreateDatabase.DB2DatabaseExists()

08/09/2013 14:23:50,531 INFO com.ibm.rational.rrdi.setup.db.common.RRDIPreReqCreateDatabase : RRDIPreReqCreateDatabase.attachToDB2CurrentInstance()

08/09/2013 14:23:50,532 INFO com.ibm.rational.rrdi.setup.db.common.RRDIPreReqCreateDatabase : RRDIPreReqCreateDatabase.getDB2CurrentInstance()

08/09/2013 14:23:50,534 INFO com.ibm.rational.rrdi.setup.db.common.RRDIPreReqCreateDatabase : RRDIPreReqCreateDatabase.setDB2CurrentInstance()

08/09/2013 14:23:52,539 INFO com.ibm.rational.rrdi.setup.db.common.RRDIPreReqCreateDatabase : RRDIPreReqCreateDatabase.getDB2CurrentInstance()

08/09/2013 14:24:24,547 INFO com.ibm.rational.rrdi.setup.db.common.RRDIPreReqCreateDatabase : RRDIPreReqCreateDatabase.attachConnUserToDB2CurrentInstance()

08/09/2013 14:24:24,549 INFO com.ibm.rational.rrdi.setup.db.common.RRDIPreReqCreateDatabase : RRDIPreReqCreateDatabase.getDB2CurrentInstance()

08/09/2013 14:24:24,551 INFO com.ibm.rational.rrdi.setup.db.common.RRDIPreReqCreateDatabase : RRDIPreReqCreateDatabase.getDB2CurrentInstance()

08/09/2013 14:25:28,562 INFO com.ibm.rational.rrdi.setup.steps.EnterpriseContentStoreStepService : CRRRA0069I: Exit to validate the database.

08/09/2013 14:33:16,528 INFO com.ibm.rational.rrdi.setup.resources.ResourceService : CRRRA0137I: Loading the model

08/09/2013 14:33:16,530 INFO com.ibm.rational.rrdi.setup.resources.ResourceService : CRRRA0139I: Loaded the model

08/09/2013 14:33:16,578 INFO com.ibm.rational.rrdi.setup.db.common.RRDICreateDatabase : 1- RRDICreateDatabase

08/09/2013 14:33:16,579 INFO com.ibm.rational.rrdi.setup.db.common.RRDICreateDatabase : 1- RRDICreateDatabase.executeDBCreation()

08/09/2013 14:33:16,579 INFO com.ibm.rational.rrdi.setup.db.common.RRDICreateDatabase : RRDICreateDatabase.validatePreReq()

08/09/2013 14:33:16,580 INFO com.ibm.rational.rrdi.setup.db.common.RRDICreateDatabase : RRDICreateDatabase.isLocalSetup()

08/09/2013 14:33:16,580 INFO com.ibm.rational.rrdi.setup.db.common.RRDICreateDatabase : RRDICreateDatabase.canCreateDatabase()

08/09/2013 14:33:16,580 INFO com.ibm.rational.rrdi.setup.db.common.RRDICreateDatabase : RRDICreateDatabase.canCreateDB2Database()

08/09/2013 14:33:16,581 INFO com.ibm.rational.rrdi.setup.db.common.RRDICreateDatabase : RRDICreateDatabase.getDB2UserGroupInformation()

08/09/2013 14:33:18,583 INFO com.ibm.rational.rrdi.setup.db.common.RRDICreateDatabase : RRDICreateDatabase.getWinAdminGroup()

08/09/2013 14:33:18,585 INFO com.ibm.rational.rrdi.setup.db.common.RRDICreateDatabase : RRDICreateDatabase.setWinAdminGroup()

08/09/2013 14:33:20,597 INFO com.ibm.rational.rrdi.setup.db.common.RRDICreateDatabase : RRDICreateDatabase.getDosCodepage()

08/09/2013 14:33:22,607 INFO com.ibm.rational.rrdi.setup.db.common.RRDICreateDatabase : RRDICreateDatabase.databaseExists()

08/09/2013 14:33:22,608 INFO com.ibm.rational.rrdi.setup.db.common.RRDICreateDatabase : RRDICreateDatabase.DB2DatabaseExists()

08/09/2013 14:33:22,610 INFO com.ibm.rational.rrdi.setup.db.common.RRDICreateDatabase : RRDICreateDatabase.attachToDB2CurrentInstance()

08/09/2013 14:33:22,611 INFO com.ibm.rational.rrdi.setup.db.common.RRDICreateDatabase : RRDICreateDatabase.getDB2CurrentInstance()

08/09/2013 14:33:22,612 INFO com.ibm.rational.rrdi.setup.db.common.RRDICreateDatabase : RRDICreateDatabase.setDB2CurrentInstance()

08/09/2013 14:33:24,618 INFO com.ibm.rational.rrdi.setup.db.common.RRDICreateDatabase : RRDICreateDatabase.getDB2CurrentInstance()

08/09/2013 14:33:56,624 INFO com.ibm.rational.rrdi.setup.db.common.RRDICreateDatabase : RRDICreateDatabase.attachConnUserToDB2CurrentInstance()

08/09/2013 14:33:56,625 INFO com.ibm.rational.rrdi.setup.db.common.RRDICreateDatabase : RRDICreateDatabase.getDB2CurrentInstance()

08/09/2013 14:33:56,626 INFO com.ibm.rational.rrdi.setup.db.common.RRDICreateDatabase : RRDICreateDatabase.getDB2CurrentInstance()

08/09/2013 14:35:00,637 INFO com.ibm.rational.rrdi.setup.db.common.RRDICreateDatabase : RRDICreateDatabase.createDatabase()

08/09/2013 14:35:00,639 INFO com.ibm.rational.rrdi.setup.db.common.RRDICreateDatabase : RRDICreateDatabase.createDB2Database()

08/09/2013 14:39:02,805 INFO com.ibm.rational.rrdi.setup.db.common.RRDIDBConnection : Database connection URL: jdbc:db2://localhost:50000/RICM

08/09/2013 14:39:07,109 INFO com.ibm.rational.rrdi.setup.steps.EnterpriseContentStoreStepService : CRRRA0066I: Start to run script.

08/09/2013 14:39:07,193 INFO com.ibm.rational.rrdi.setup.resources.ResourceService : CRRRA0137I: Loading the model

08/09/2013 14:39:07,197 INFO com.ibm.rational.rrdi.setup.resources.ResourceService : CRRRA0139I: Loaded the model

08/09/2013 14:39:07,207 INFO com.ibm.rational.rrdi.setup.db.common.RRDIDBConnection : Database connection URL: jdbc:db2://localhost:50000/RICM

08/09/2013 14:39:09,718 INFO com.ibm.rational.rrdi.setup.steps.EnterpriseContentStoreStepService : CRRRA0070I: Create buffer pool on DB2.

08/09/2013 14:39:09,811 INFO com.ibm.rational.rrdi.setup.steps.EnterpriseContentStoreStepService : CRRRA0071I: Create table space on DB2.

08/09/2013 14:39:10,373 INFO com.ibm.rational.rrdi.setup.steps.EnterpriseContentStoreStepService : CRRRA0067I: Exit the running of the script.

08/09/2013 14:39:45,710 INFO com.ibm.rational.rrdi.setup.resources.ResourceService : CRRRA0137I: Loading the model

08/09/2013 14:39:45,712 INFO com.ibm.rational.rrdi.setup.resources.ResourceService : CRRRA0139I: Loaded the model

08/09/2013 14:39:45,712 INFO com.ibm.rational.rrdi.setup.resources.DatabaseConfigurationService : Enter 'com.ibm.rational.rrdi.setup.resources.DatabaseConfigurationService' service 'doPost'

08/09/2013 14:39:45,731 INFO com.ibm.rational.rrdi.setup.resources.DatabaseConfigurationService : Exiting 'com.ibm.rational.rrdi.setup.resources.DatabaseConfigurationService' service 'doPost'

08/09/2013 14:39:45,827 INFO com.ibm.rational.rrdi.setup.resources.ResourceService : CRRRA0137I: Loading the model

08/09/2013 14:39:45,829 INFO com.ibm.rational.rrdi.setup.resources.ResourceService : CRRRA0139I: Loaded the model

08/09/2013 14:39:45,829 INFO com.ibm.rational.rrdi.setup.resources.DatabaseConfigurationService : CRRRA0114I: No database configuration is found.

08/09/2013 14:39:45,839 INFO com.ibm.rational.rrdi.setup.resources.ResourceService : CRRRA0137I: Loading the model

08/09/2013 14:39:45,840 INFO com.ibm.rational.rrdi.setup.resources.ResourceService : CRRRA0139I: Loaded the model

08/09/2013 14:47:28,520 INFO com.ibm.rational.rrdi.setup.steps.EnterpriseDataWarehouseStepService : CRRRA0123I: Start to validate the database.

08/09/2013 14:47:28,548 INFO com.ibm.rational.rrdi.setup.resources.ResourceService : CRRRA0137I: Loading the model

08/09/2013 14:47:28,552 INFO com.ibm.rational.rrdi.setup.resources.ResourceService : CRRRA0139I: Loaded the model

08/09/2013 14:47:28,561 INFO com.ibm.rational.rrdi.setup.db.common.RRDIDBConnection : Database connection URL: jdbc:db2://localhost:50000/RIDW

08/09/2013 14:47:29,936 INFO com.ibm.rational.rrdi.setup.db.common.RRDIDBConnection : Database connection URL: jdbc:db2://localhost:50000/RIDW

08/09/2013 14:47:32,309 ERROR com.ibm.rational.rrdi.setup.db.common.RRDIDBException : CRRRD4710E: Connection to the database cannot be established. Make sure that the connection information, the user, and credentials are valid. Make sure that the driver is properly set up and that the correct communication protocols have been configured on the database. Refer to the DBMS error message and code for details.

Error Code: 4710

SQL ERROR: [jcc][t4][2013][11249][3.57.82] Connection authorization failure occurred. Reason: User ID or Password invalid. ERRORCODE=-4214, SQLSTATE=28000

08/09/2013 14:47:32,312 ERROR com.ibm.rational.rrdi.setup.db.common.RRDIDBException : CRRRD4786E: The report user rptuser cannot connect to the data warehouse. Validate the connection information and credentials supplied, and also ensure that the user has the authority to connect to the database. Make sure that the correct communication protocols are set up on the database server.CRRRD4710E: Connection to the database cannot be established. Make sure that the connection information, the user, and credentials are valid. Make sure that the driver is properly set up and that the correct communication protocols have been configured on the database. Refer to the DBMS error message and code for details.

Error Code: 4710

SQL ERROR: [jcc][t4][2013][11249][3.57.82] Connection authorization failure occurred. Reason: User ID or Password invalid. ERRORCODE=-4214, SQLSTATE=28000

Error Code: 4786

08/09/2013 14:47:32,313 ERROR com.ibm.rational.rrdi.setup.steps.EnterpriseDataWarehouseStepService : com.ibm.rational.rrdi.setup.db.common.RRDIDBException: CRRRD4786E: The report user rptuser cannot connect to the data warehouse. Validate the connection information and credentials supplied, and also ensure that the user has the authority to connect to the database. Make sure that the correct communication protocols are set up on the database server.CRRRD4710E: Connection to the database cannot be established. Make sure that the connection information, the user, and credentials are valid. Make sure that the driver is properly set up and that the correct communication protocols have been configured on the database. Refer to the DBMS error message and code for details.

Error Code: 4710

SQL ERROR: [jcc][t4][2013][11249][3.57.82] Connection authorization failure occurred. Reason: User ID or Password invalid. ERRORCODE=-4214, SQLSTATE=28000

Error Code: 4786

com.ibm.rational.rrdi.setup.db.common.RRDIDBException: CRRRD4786E: The report user rptuser cannot connect to the data warehouse. Validate the connection information and credentials supplied, and also ensure that the user has the authority to connect to the database. Make sure that the correct communication protocols are set up on the database server.CRRRD4710E: Connection to the database cannot be established. Make sure that the connection information, the user, and credentials are valid. Make sure that the driver is properly set up and that the correct communication protocols have been configured on the database. Refer to the DBMS error message and code for details.

Error Code: 4710

SQL ERROR: [jcc][t4][2013][11249][3.57.82] Connection authorization failure occurred. Reason: User ID or Password invalid. ERRORCODE=-4214, SQLSTATE=28000

Error Code: 4786

at com.ibm.rational.rrdi.setup.dw.RRDIReportUserValidation.IsValidDB2RptUserLight(RRDIReportUserValidation.java:254)

at com.ibm.rational.rrdi.setup.dw.RRDIReportUserValidation.checkUserExistsLight(RRDIReportUserValidation.java:92)

at com.ibm.rational.rrdi.setup.steps.EnterpriseDataWarehouseStepService.validateDatabase(EnterpriseDataWarehouseStepService.java:419)

at com.ibm.rational.rrdi.setup.steps.EnterpriseDataWarehouseStepService.handleActions(EnterpriseDataWarehouseStepService.java:718)

at com.ibm.rational.rrdi.setup.steps.AbstractStepService.doPost(AbstractStepService.java:222)

at com.ibm.rational.rrdi.setup.steps.EnterpriseDataWarehouseStepService.doPost(EnterpriseDataWarehouseStepService.java:732)

at com.ibm.team.jfs.app.servlet.AppContainerServlet.dispatchRequest(AppContainerServlet.java:176)

at com.ibm.team.jfs.app.servlet.AppContainerServlet.service(AppContainerServlet.java:281)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)

at org.eclipse.equinox.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:61)

at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:126)

at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:76)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)

at org.eclipse.equinox.servletbridge.BridgeServlet.service(BridgeServlet.java:120)

at com.ibm.team.repository.server.servletbridge.JazzServlet.service(JazzServlet.java:68)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at com.ibm.team.repository.server.servletbridge.BridgeFilter.processDelegate(BridgeFilter.java:133)

at com.ibm.team.repository.server.servletbridge.BridgeFilter.doFilter(BridgeFilter.java:154)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)

at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:336)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)

at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:987)

at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579)

at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:307)

at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)

at java.lang.Thread.run(Thread.java:736)

08/09/2013 14:47:32,316 ERROR com.ibm.rational.rrdi.setup.steps.EnterpriseDataWarehouseStepService : CRRRA0131E: An error happened when validating the database. 'com.ibm.rational.rrdi.setup.db.common.RRDIDBException: CRRRD4786E: The report user rptuser cannot connect to the data warehouse. Validate the connection information and credentials supplied, and also ensure that the user has the authority to connect to the database. Make sure that the correct communication protocols are set up on the database server.CRRRD4710E: Connection to the database cannot be established. Make sure that the connection information, the user, and credentials are valid. Make sure that the driver is properly set up and that the correct communication protocols have been configured on the database. Refer to the DBMS error message and code for details.

Error Code: 4710

SQL ERROR: [jcc][t4][2013][11249][3.57.82] Connection authorization failure occurred. Reason: User ID or Password invalid. ERRORCODE=-4214, SQLSTATE=28000

Error Code: 4786'.

08/09/2013 14:47:32,317 INFO com.ibm.rational.rrdi.setup.steps.EnterpriseDataWarehouseStepService : CRRRA0124I: Exit to validate the database.

08/09/2013 14:50:20,765 INFO com.ibm.rational.rrdi.setup.steps.EnterpriseDataWarehouseStepService : CRRRA0123I: Start to validate the database.

08/09/2013 14:50:20,791 INFO com.ibm.rational.rrdi.setup.resources.ResourceService : CRRRA0137I: Loading the model

08/09/2013 14:50:20,793 INFO com.ibm.rational.rrdi.setup.resources.ResourceService : CRRRA0139I: Loaded the model

08/09/2013 14:50:20,801 INFO com.ibm.rational.rrdi.setup.db.common.RRDIDBConnection : Database connection URL: jdbc:db2://localhost:50000/RIDW

08/09/2013 14:50:22,102 INFO com.ibm.rational.rrdi.setup.db.common.RRDIDBConnection : Database connection URL: jdbc:db2://localhost:50000/RIDW

08/09/2013 14:50:24,365 ERROR com.ibm.rational.rrdi.setup.db.common.RRDIDBException : CRRRD4710E: Connection to the database cannot be established. Make sure that the connection information, the user, and credentials are valid. Make sure that the driver is properly set up and that the correct communication protocols have been configured on the database. Refer to the DBMS error message and code for details.

Error Code: 4710

SQL ERROR: [jcc][t4][2013][11249][3.57.82] Connection authorization failure occurred. Reason: User ID or Password invalid. ERRORCODE=-4214, SQLSTATE=28000

08/09/2013 14:50:24,371 ERROR com.ibm.rational.rrdi.setup.db.common.RRDIDBException : CRRRD4786E: The report user anurag cannot connect to the data warehouse. Validate the connection information and credentials supplied, and also ensure that the user has the authority to connect to the database. Make sure that the correct communication protocols are set up on the database server.CRRRD4710E: Connection to the database cannot be established. Make sure that the connection information, the user, and credentials are valid. Make sure that the driver is properly set up and that the correct communication protocols have been configured on the database. Refer to the DBMS error message and code for details.

Error Code: 4710

SQL ERROR: [jcc][t4][2013][11249][3.57.82] Connection authorization failure occurred. Reason: User ID or Password invalid. ERRORCODE=-4214, SQLSTATE=28000

Error Code: 4786

08/09/2013 14:50:24,373 ERROR com.ibm.rational.rrdi.setup.steps.EnterpriseDataWarehouseStepService : com.ibm.rational.rrdi.setup.db.common.RRDIDBException: CRRRD4786E: The report user anurag cannot connect to the data warehouse. Validate the connection information and credentials supplied, and also ensure that the user has the authority to connect to the database. Make sure that the correct communication protocols are set up on the database server.CRRRD4710E: Connection to the database cannot be established. Make sure that the connection information, the user, and credentials are valid. Make sure that the driver is properly set up and that the correct communication protocols have been configured on the database. Refer to the DBMS error message and code for details.

Error Code: 4710

SQL ERROR: [jcc][t4][2013][11249][3.57.82] Connection authorization failure occurred. Reason: User ID or Password invalid. ERRORCODE=-4214, SQLSTATE=28000

Error Code: 4786

com.ibm.rational.rrdi.setup.db.common.RRDIDBException: CRRRD4786E: The report user anurag cannot connect to the data warehouse. Validate the connection information and credentials supplied, and also ensure that the user has the authority to connect to the database. Make sure that the correct communication protocols are set up on the database server.CRRRD4710E: Connection to the database cannot be established. Make sure that the connection information, the user, and credentials are valid. Make sure that the driver is properly set up and that the correct communication protocols have been configured on the database. Refer to the DBMS error message and code for details.