RRDI setup - Exception while logging onto report server

Prasun Roy

(167●4●8●13) 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.

1 vote

13 answers

19,654 views

1 vote

13 answers

Permanent link

Jin Peng

JAZZ DEVELOPER (96●3●4) Aug 14 '12, 10:34 p.m.

The RRDI setup must use empty database as DataWareHouse DB. For your scenario. you can setup first, and then configure CLM products pointing to the DataWareHouse DB next.

For the second question, is it Oracle 64bit or Oracle 32bit? and Have you set LD_LIBRARY_PATH to include oracle lib path before WAS started? Something like:
SET LD_LIBRARY_PATH=%LD_LIBRARY_PATH%:%ORACLE_HOME%\lib

2 votes

Comments

Prasun Roy

Aug 15 '12, 11:05 a.m.

Thanks Jin, for your quick response, I am using 32bit Oracle, RRDI and WAS and I have the LD_LIBRARY_PATH set but still getting the exception. Below is the log from the setup. 10:08:07,016 [http-bio-10443-exec-14] INFO .rational.rrdi.setup.resources.DWCon nectionService - CRRRA0116I: No dw connection is found. 10:08:07,034 [http-bio-10443-exec-15] INFO .ibm.rational.rrdi.setup.resources.R esourceService - CRRRA0137I: Loading the model 10:08:07,035 [http-bio-10443-exec-15] INFO .ibm.rational.rrdi.setup.resources.R esourceService - CRRRA0139I: Loaded the model 10:08:07,049 [http-bio-10443-exec-24] INFO l.rrdi.setup.biserver.service.WasDep loymentService - CRRRA2038I: Connect to the report server. CRRRA3001I: Connecting to the report server... 10:08:09,262 [http-bio-10443-exec-24] INFO l.rrdi.setup.biserver.service.WasDep loymentService - CRRRA2039I: Log onto the report server. 10:08:09,277 [http-bio-10443-exec-24] ERROR onal.rrdi.setup.steps.DeployCognosTo WASStepService - java.lang.NullPointerException

Jin Peng

JAZZ DEVELOPER Aug 15 '12, 11:21 p.m.

Please make sure the configuration for Oracle is correct, and then click "Depoy" button again. 1) Set ORACLE_BASE and ORACLE_HOME environments 2) Open Oracle SqlPlus, testing the connect is okay for DataWareHouse DB

Permanent link

Leonardo Marzo

(249●6●48●52) Aug 15 '12, 6:08 p.m.

I have the same problem when trying to install RRDI. Why the DW must be empty? The data warehouse that we're using has data from the last 3 months. Is there any way to install RRDI without dropping an existent DW?

I will appreciate any help you may give us.

Regards,

0 votes

Permanent link

Jin Peng

JAZZ DEVELOPER (96●3●4) Aug 15 '12, 10:53 p.m.

Leonardo,
For your case which is migrating from previous RRDI version, you need select to run the scenario "Upgrade to this version of Rational Reporting" in the first page of setup.

0 votes

Comments

Prasun Roy

Aug 15 '12, 11:14 p.m.

Jin, Do you have any suggestion for me, I'm stuck on the last step and unable to complete the setup. Thanks

Leonardo Marzo

Aug 15 '12, 11:30 p.m.

Jin, we didn't install previous versions of RRDI, so it is not an upgrade. We upgraded JTS, CCM and RQM from 3.0.1.3 to 4.0, and now we're trying to install RRDI. We set up DW in 3.0.1.3 and then DW worked properly in 4.0

Permanent link

Jin Peng

JAZZ DEVELOPER (96●3●4) Aug 15 '12, 11:40 p.m.

Leonardo,
I am afraid it is not a supported scenario. For your case, you can skip the step of "Configure Data Warehouse", the way is change the URL from ".../steps/3" to "../steps/4"

0 votes

Permanent link

Leonardo Marzo

(249●6●48●52) Aug 16 '12, 10:03 a.m.

Thanks for your answer Jin. However, in the step "Configure Data Warehouse" it says "The data warehouse is a database used for reporting and analytics. You can point to an existing data warehouse or specify values to create a new data warehouse"

So, I think it is a supported scenario. If I skip the step, will I be able to point RRDI to the DW later?

Thanks,

0 votes

Permanent link

Jin Peng

JAZZ DEVELOPER (96●3●4) Aug 19 '12, 10:54 p.m.

Yes, you can skip the step, in "Build and Deploy reporting components" you could met warning that it cannot create the data warehouse data source connection. You can miss it and use the Cognos administrative page to create the data warehouse data source later when logging to the report server.

0 votes

Comments

Leonardo Marzo

Aug 20 '12, 5:20 p.m.

Thanks for your answer. Could you tell me what's the URL to access the COgnos administrative page? Thanks

Permanent link

Jin Peng

JAZZ DEVELOPER (96●3●4) Aug 20 '12, 10:55 p.m.

The default URL is: http://hostname:9090/reporting

0 votes

Comments

Leonardo Marzo

Aug 21 '12, 8:14 a.m.

I accessed this URL but I don't find any option to configure the DW there

Leonardo Marzo

Aug 21 '12, 11:10 a.m.

Jin, the problem is that, in the "Launch" menu I only find the option "Drill-through Definitions". I don't see the option "IBM Cognos Administration". Could you please tell me why It may be happening?

Permanent link

Jin Peng

JAZZ DEVELOPER (96●3●4) Aug 24 '12, 3:22 a.m.

The reason is uncertain, please raise a PMR to the support team for your case.

0 votes

Comments

Prasun Roy

Sep 13 '12, 5:12 p.m.

It seems RRDI doesn't work with WAS 8.5 and you need to use WAS 8.0 for the setup otherwise the setup fails on the last step. I installed WAS 8.0 and tried to setup RRDI and it went through without any issues.

1 vote

Permanent link

Manoj Panda

JAZZ DEVELOPER (393●4●67●62) Dec 20 '12, 12:31 p.m.

Hi Prasun/All,
I am using WAS 8.0.0.3 (32 bit), DB2 , CLM 4.0.1 and RRDI 2.0.1 (32 bit). I am facing the similar issue when i reach to the last step while setting up the RRDI.

From the RRDI log file, i am getting following error.

12/20/2012 22:32:58,044 INFO com.ibm.rational.rrdi.setup.resources.DWConnectionService : CRRRA0116I: No dw connection is found.
12/20/2012 22:32:58,077 INFO com.ibm.rational.rrdi.setup.resources.ResourceService : CRRRA0137I: Loading the model
12/20/2012 22:32:58,080 INFO com.ibm.rational.rrdi.setup.resources.ResourceService : CRRRA0139I: Loaded the model
12/20/2012 22:32:58,104 INFO com.ibm.rational.rrdi.setup.biserver.service.WasDeploymentService : CRRRA2038I: Connect to the report server.
12/20/2012 22:32:58,600 ERROR com.ibm.rational.rrdi.setup.steps.DeployCognosToWASStepService : com.ibm.rational.rrdi.setup.biserver.common.RRDIBIServerException: CRRRA2083E: Cannot connect to the report server.

Any Idea!!!

0 votes

Comments

Prasun Roy

Dec 20 '12, 2:52 p.m.

Hi Manoj, For starters, Which version of DB2 you are using (32bit or 64 bit). Make sure you use 32 bit DB2 as rest of your configuration is 32 bit. Exactly same issue is reported for Oracle database, refer to the link Workaround : RRDI Setup exception. So you need to make sure that the DB2 database instance is created with the same name as the Service that represents the instance.

Permanent link

Manoj Panda

JAZZ DEVELOPER (393●4●67●62) Dec 20 '12, 10:51 p.m.

Thanks Prasun for your quick reply,
I understand that all the bits should be same including DB2. Yes I have 64 bit DB2 but 32bit of WAS. This may be one of the issue. your 2nd statement is "DB2 database instance is created with the same name as the Service that represents the instance"

Could you please explain with an example.

0 votes

Comments

Prasun Roy

Jan 04 '13, 7:53 a.m.

Hi Manoj, Hope your issue is resolved by now. I'll try to elaborate on my 2nd statement. If you use Oracle or DB2 then for every database instance you create the database system creates a windows service that represents the respective databases. Every service has its own port no and a unique name. External system address the databse using this service name and port no. While creating a database instance you get an option to select a name for the database and the corresponding service. Its a good practice to select a common name for both.

YOGESH LOKHANDE

Apr 01 '13, 10:18 a.m.

I have same issue but DB is SQL server 2008 R2

Items per page:

1–15 items

page 1of 1 pagesof 2 pages

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.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers

Answers and Comments

Question details

configuration

× 6,180

rational-insight

× 1,225

datawarehouse

× 94

rational-rrdi

× 42

setup

× 37

Question asked: Aug 14 '12, 11:15 a.m.

Question was seen: 19,654 times

Last updated: Jun 06 '13, 4:14 p.m.

RRDI setup - Exception while logging onto report server

13 answers

19,654 views

1 vote

13 answers

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Your answer

Follow this question

Question details

Related questions