It's all about the answers!

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

×6,107
×1,235
×94
×42
×37

question asked: Aug 14 '12, 11:15 a.m.
question was seen: 11,966 times
last updated: Jun 06 '13, 4:14 p.m.

Related questions

RRDI setup - Exception while logging onto report server

1
Prasun Roy (167●4●8●13) | asked Aug 14 '12, 11:15 a.m.
edited Aug 14 '12, 1:12 p.m.
 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

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Rahul Singh Bhadauriya (28●2●17●20) | answered Mar 12 '13, 9:14 a.m.
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,
0
permanent link
Manoj Panda (393●4●67●62) | answered Apr 01 '13, 10:26 a.m.
JAZZ DEVELOPER
Hello,
 After a long gap , i tried again but same issue. This time I have WAS 8.0.0.3 64 bit, DB2 9.7 64 bit and RRDI 2.0 64 bit.

0
permanent link
Rafael Rodriguez Montes (230●13●130●258) | answered Jun 06 '13, 4:14 p.m.
 The same issue but with SQL Server 2008 R2 64 bits, web sphere 6.1.0.45 32 bits... 

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.