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

Uninstall Data Warehouse in RTC 4.0.3

Questions
Tags
Users
Badges
Kegham Anbarjian
(23●1●7●11) Nov 24 '14, 9:07 p.m.

Hello,

Does anyone know if there is a way to uninstall the Data Warehouse in RTC 4.0.3 running on Oracle 11g DB? I cloned an existing 11g RTC 4.0.3 'Production' database, and I set up the clone in a new environment. I was able to successfully connect RTC 4.0.3 to the cloned DB, inclduing connectivity to JTS, RRC, CCM, and QM, but I am experiencing problems connecting to the DW. I tried to set it up in the RTC Setup Wizard without success. I am wondering if I am missing on changing something in teamserver.properties files, as I tried different changes without success. 

My thought is to uninstall DW along with its schema and data files for VNF_32K, VNF_IDX, VSTR_32K, VSTR_IDX. I am not sure if I should also include the schemas ODM_DATA and RIS_TEMP.

Any helpful suggestion would be much appreciated.

Thanks,

Kevin

0 votes

1 answer
7,845 views
0 votes

One answer

Permanent link
Donald Nong
(14.5k●6●14) Nov 24 '14, 9:57 p.m.
If you would like to use the existing DW (the cloned copy), you can at least let us know what problems you had when trying to the connect to the DW. You can check the teamserver.properties file for all the lines containing "datawarehouse". Alternatively, check the "Data Warehouse" section in the "Advanced Properties" page after you log on to /ccm/admin.
If you really want to "uninstall" data warehouse, check the "dropping the data warehouse" section in the below article.
https://jazz.net/wiki/bin/view/Main/MoreControlOverTheOracleDataWarehouseSetup

1 vote

Comments
Kegham Anbarjian
Nov 24 '14, 11:57 p.m.
Hi Donald, My apologies for missing to include the details of the problem. I guess I have been more focused on learning the procedure for a DW uninstall, rather than trying to fix the error message.  I am attaching the error message which I am getting in the Setup Wizard. I know for fact that the syntax is correct. I am wondering if it has to do with a unique Consumer Key, which is why I thought of doing a clean DW uninstall, then re-install. Thanks, Kevin

Donald Nong
Nov 25 '14, 12:07 a.m.
If it complains about the syntax, maybe you can check "I do not wish ..." to disable the data warehouse first, then re-run the setup and enter the connection information. P.S. Is it possible that the "Database Table Space Folder" parameter is not right? It is system-dependent and likely not correct for your clone system.

Kegham Anbarjian
Nov 25 '14, 5:26 a.m.
I have tried your suggestions, including entering the correct path for the database space folder, without success. Thanks for the URL for uninstalling the DW. I think it's going to be my last resort. Kevin

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
× 7,622
× 2,382

Question asked: Nov 24 '14, 9:07 p.m.

Question was seen: 7,845 times

Last updated: Nov 25 '14, 5:26 a.m.

Confirmation Cancel Confirm