Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

installing RRDI 2.0 on an existing Oracle DW on JTS 3.0.1.1

Questions
Tags
Users
Badges
Keng Lim
(6●1●4●3) Sep 10 '12, 8:13 a.m.
 I am trying to install RRDI 2.0 to an existing JTS 3.0.1.1 instance that is already using an Oracle database.

The RICM connected OK on the setup.

However I am now on the Configure Data Warehouse page and when defining my existing Oracle DW datastore,
I get error message .......

CRRRA0131E : An error happened when validating the database .......
ERROR : ORA-00942 : table or view does not exist.

I think I need to run an upgrade script on the existing DW but which one ? 

0 votes

2 answers
3,991 views
0 votes

2 answers

Permanent link
Marc Nehme
JAZZ DEVELOPER (276●1●5●7) Sep 11 '12, 12:33 p.m.
Hi Keng, is there more information regarding this error reference which table or view is missing? Can you check the rrdi_setup.log located in <rrdiinstalldir>\setup\logs and check for more info around which table/view the wizard is complaining about?

0 votes

Comments
Keng Lim
Sep 11 '12, 3:17 p.m.

Hi Marc, i did check the logs. Same message as the one posted. Nothing more. I will need to check with the dba to see if they is anything in oracle. Do you know of any switch/setting ?

Krzysztof Kaźmierczyk
May 06 '13, 7:45 a.m.

Hi Keng,
Did you have the chance to fix this? What was the root cause of the issue?

Permanent link
Mark Prout
(134●1●15●10) Sep 10 '12, 11:17 a.m.
I'm not sure that this is even a supported environment, RRDI 2.0 is for use only against CLM v4.  When upgrading to CLM v4 you need to upgrade the DW.

-1 votes

Comments
Keng Lim
Sep 10 '12, 11:23 a.m.

Hi Mark, I believe it is.

Goto to the RRDI 1.0.2 download site from CLM 3 optional downloads. It will tell you that it is best to use the latest version and leads you to RRDI 2.0

However if you have the instructions to upgrade the DW the do pass them on

Mark Prout
Sep 10 '12, 11:53 a.m.

Hi Keng

The following link is useful; https://jazz.net/help-dev/clm/topic/com.ibm.rational.rrdi.admin.doc/topics/c_upgrading_rrdi.html

If it was possible to upgrade just the DW I am unaware of any published way to upgrade the Java based ETLs found within each of the CLM pillars to v4 ETLs, this could prove to be the next challenge.

Your answer

Register or log in 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.

Ask a question
Guidelines
FAQ
Search context
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
× 2,357

Question asked: Sep 10 '12, 8:13 a.m.

Question was seen: 3,991 times

Last updated: May 06 '13, 7:45 a.m.

Confirmation Cancel Confirm