RRDI setup - Exception while logging onto report server
While trying to setup RRDI on the Reporting Server, I am getting errors with the following configuration:
Content DB - On Report Server (Oracle 11g Release 2)
DataWareHouse DB - On Database server (Oracle 11g). There is a single database with all the CLM products pointing to it and have separate Tablespaces for RQM, RTC, JTS and Datawarehouse.
WAS 8.5
CLM 4.0
RRDI 2.0
When I am trying to Validate the "Configure Data Warehouse" step, I get an error that says "The schema RIDW is not empty. No objects can exist under this schema. Drop all objects before continuing."
Is it mandatory to have separate database (instead of Tablespace) for separate CLM tools, in order to access the Datawarehouse from RRDI.
----------------------------------------------------------------------------------------------------------------------------------------------
I tried to create a DataWareHouse DB on the Report Server as a separate DB, then the setup goes through to the last step.
But while executing "Initialize and Set the Rational Reporting style" (in the Build and Deploy Reporting Components step), I get an error that says "No dw connection is found."
And the Report Server log in fails with a java.lang.NullPointerException.
I would greatly appreciate any help regarding this.
13 answers
Hi All,
I am facing the same problem as discussed by Manoj here.
I am getting error while Rational Reporting Setup, In the Tab Build and Deploy Reporting Components.
WAS Version is : 6.1.0.0
you will find the full details with snapshots on the following link
https://jazz.net/forum/questions/105623/error-cannot-connect-to-reporting-server-while-installing-ibm-rational-insight
https://jazz.net/forum/questions/104988/error-using-sql-server-2008-r2-database-for-rational-insight-setup
Logs are as follows:
03/12/2013 10:01:20,784 INFO com.ibm.rational.rrdi.setup.resources.ResourceService : CRRRA0137I: Loading the model
03/12/2013 10:01:20,878 INFO com.ibm.rational.rrdi.setup.resources.ResourceService : CRRRA0139I: Loaded the model
03/12/2013 10:01:38,862 INFO com.ibm.rational.rrdi.setup.biserver.service.WasDeploymentService : CRRRA2024I: Replace the web.xml file and related files.
03/12/2013 10:01:39,080 INFO com.ibm.rational.rrdi.setup.biserver.service.WasDeploymentService : CRRRA2025I: Change the system.xml file.
03/12/2013 10:01:42,502 INFO com.ibm.rational.rrdi.setup.resources.ResourceService : CRRRA0137I: Loading the model
03/12/2013 10:01:42,549 INFO com.ibm.rational.rrdi.setup.resources.ResourceService : CRRRA0139I: Loaded the model
03/12/2013 10:01:42,596 INFO com.ibm.rational.rrdi.setup.resources.ResourceService : CRRRA0137I: Loading the model
03/12/2013 10:01:42,658 INFO com.ibm.rational.rrdi.setup.resources.ResourceService : CRRRA0139I: Loaded the model
03/12/2013 10:01:42,721 INFO com.ibm.rational.rrdi.setup.biserver.service.WasDeploymentService : CRRRA2029I: Change and save the Cognos configuration.
03/12/2013 10:02:41,469 INFO com.ibm.rational.rrdi.setup.biserver.service.WasDeploymentService : CRRRA2030I: Prepare to deploy p2pd.ear file on the WebSphere Application Server.
03/12/2013 10:02:41,469 INFO com.ibm.rational.rrdi.setup.biserver.service.WasDeploymentService : CRRRA2031I: Check whether the p2pd.ear file was deployed.
03/12/2013 10:03:37,421 INFO com.ibm.rational.rrdi.setup.biserver.service.WasDeploymentService : CRRRA2032I: The p2pd.ear file was already deployed.
03/12/2013 10:05:50,512 INFO com.ibm.rational.rrdi.setup.resources.ResourceService : CRRRA0137I: Loading the model
03/12/2013 10:05:50,559 INFO com.ibm.rational.rrdi.setup.resources.ResourceService : CRRRA0139I: Loaded the model
03/12/2013 10:05:50,637 INFO com.ibm.rational.rrdi.setup.resources.ResourceService : CRRRA0137I: Loading the model
03/12/2013 10:05:50,653 INFO com.ibm.rational.rrdi.setup.resources.ResourceService : CRRRA0139I: Loaded the model
03/12/2013 10:05:50,684 INFO com.ibm.rational.rrdi.setup.resources.DWConnectionService : CRRRA0116I: No dw connection is found.
03/12/2013 10:05:50,856 INFO com.ibm.rational.rrdi.setup.resources.ResourceService : CRRRA0137I: Loading the model
03/12/2013 10:05:50,903 INFO com.ibm.rational.rrdi.setup.resources.ResourceService : CRRRA0139I: Loaded the model
03/12/2013 10:05:50,981 INFO com.ibm.rational.rrdi.setup.biserver.service.WasDeploymentService : CRRRA2038I: Connect to the report server.
03/12/2013 10:05:51,137 ERROR com.ibm.rational.rrdi.setup.steps.DeployCognosToWASStepService : com.ibm.rational.rrdi.setup.biserver.common.RRDIBIServerException: CRRRA2083E: Cannot connect to the report server.
Thanks,
I am facing the same problem as discussed by Manoj here.
I am getting error while Rational Reporting Setup, In the Tab Build and Deploy Reporting Components.
WAS Version is : 6.1.0.0
you will find the full details with snapshots on the following link
https://jazz.net/forum/questions/105623/error-cannot-connect-to-reporting-server-while-installing-ibm-rational-insight
https://jazz.net/forum/questions/104988/error-using-sql-server-2008-r2-database-for-rational-insight-setup
Logs are as follows:
03/12/2013 10:01:20,784 INFO com.ibm.rational.rrdi.setup.resources.ResourceService : CRRRA0137I: Loading the model
03/12/2013 10:01:20,878 INFO com.ibm.rational.rrdi.setup.resources.ResourceService : CRRRA0139I: Loaded the model
03/12/2013 10:01:38,862 INFO com.ibm.rational.rrdi.setup.biserver.service.WasDeploymentService : CRRRA2024I: Replace the web.xml file and related files.
03/12/2013 10:01:39,080 INFO com.ibm.rational.rrdi.setup.biserver.service.WasDeploymentService : CRRRA2025I: Change the system.xml file.
03/12/2013 10:01:42,502 INFO com.ibm.rational.rrdi.setup.resources.ResourceService : CRRRA0137I: Loading the model
03/12/2013 10:01:42,549 INFO com.ibm.rational.rrdi.setup.resources.ResourceService : CRRRA0139I: Loaded the model
03/12/2013 10:01:42,596 INFO com.ibm.rational.rrdi.setup.resources.ResourceService : CRRRA0137I: Loading the model
03/12/2013 10:01:42,658 INFO com.ibm.rational.rrdi.setup.resources.ResourceService : CRRRA0139I: Loaded the model
03/12/2013 10:01:42,721 INFO com.ibm.rational.rrdi.setup.biserver.service.WasDeploymentService : CRRRA2029I: Change and save the Cognos configuration.
03/12/2013 10:02:41,469 INFO com.ibm.rational.rrdi.setup.biserver.service.WasDeploymentService : CRRRA2030I: Prepare to deploy p2pd.ear file on the WebSphere Application Server.
03/12/2013 10:02:41,469 INFO com.ibm.rational.rrdi.setup.biserver.service.WasDeploymentService : CRRRA2031I: Check whether the p2pd.ear file was deployed.
03/12/2013 10:03:37,421 INFO com.ibm.rational.rrdi.setup.biserver.service.WasDeploymentService : CRRRA2032I: The p2pd.ear file was already deployed.
03/12/2013 10:05:50,512 INFO com.ibm.rational.rrdi.setup.resources.ResourceService : CRRRA0137I: Loading the model
03/12/2013 10:05:50,559 INFO com.ibm.rational.rrdi.setup.resources.ResourceService : CRRRA0139I: Loaded the model
03/12/2013 10:05:50,637 INFO com.ibm.rational.rrdi.setup.resources.ResourceService : CRRRA0137I: Loading the model
03/12/2013 10:05:50,653 INFO com.ibm.rational.rrdi.setup.resources.ResourceService : CRRRA0139I: Loaded the model
03/12/2013 10:05:50,684 INFO com.ibm.rational.rrdi.setup.resources.DWConnectionService : CRRRA0116I: No dw connection is found.
03/12/2013 10:05:50,856 INFO com.ibm.rational.rrdi.setup.resources.ResourceService : CRRRA0137I: Loading the model
03/12/2013 10:05:50,903 INFO com.ibm.rational.rrdi.setup.resources.ResourceService : CRRRA0139I: Loaded the model
03/12/2013 10:05:50,981 INFO com.ibm.rational.rrdi.setup.biserver.service.WasDeploymentService : CRRRA2038I: Connect to the report server.
03/12/2013 10:05:51,137 ERROR com.ibm.rational.rrdi.setup.steps.DeployCognosToWASStepService : com.ibm.rational.rrdi.setup.biserver.common.RRDIBIServerException: CRRRA2083E: Cannot connect to the report server.
Thanks,
page 2of 1 pagesof 2 pages