It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×42,788
×7,386
×5,999
×94

question asked: Oct 05 '15, 8:59 a.m.
question was seen: 2,585 times
last updated: Oct 05 '15, 10:47 a.m.

Related questions

FAQ - How this Forum works

Datawarehouse jobs not running. Seems to be errors in the setup. How much data will be lost if they are recreated

0
Michael Johnson (44●6●18) | asked Oct 05 '15, 8:59 a.m.

I installed RTC 5.0.2 and everything seemed fine until we realized that there was no status of datawarehouse jobs ever being run.  This is on Oracle 11g. 

My question is:  If I drop all of the datawarehouse tables and user and recreate - would the historical data be recreated from the ccm tables.  What am I going to lose? 

Accepted answer

0
permanent link
Krzysztof Kaźmierczyk (7.4k●3●75●103) | answered Oct 05 '15, 9:13 a.m.
Hi Michael,
Historical data from data warehouse is recreated for RTC.

But I would focus on the errors you have:
1. Which data warehouse collection solution are you using (old application jobs or DCC)?
2. Do you see any error messages in log files?
Michael Johnson selected this answer as the correct answer
Comments
Michael Johnson commented Oct 05 '15, 10:18 a.m. | edited Oct 05 '15, 10:47 a.m.

Hey Krzysztof,

I am not using DCC. 

So, here is the back story.  

I initially installed RTC 6.0.  This (for some reason did not go well).  I decided to reinstall, but with 5.0.2.  I did not want to lose my 6.0 progress and decided to install the 5.0.2 tablespaces in another area.  I believe my mess up is that I dropped all of the users except my datawarehouse user (which was still pointing at the index files in the old directory, but had new dw.dbf and dw_temp.dbf files in the new directory). 

So...rookie mistake - now I am trying to save my 5.0.2 install. 

Question 1:

If I drop all of the dw tables/dw user and recreate - do I lose anything? 

Question 2:

If I installed DCC - would all of this get fixed?

Thanks for your quick response. 

Basically, I have all of the DW index files in the wrong location.  If I drop these and the DW tables and recreate - will the data from the projects be recreated?

Krzysztof Kaźmierczyk commented Oct 05 '15, 10:45 a.m.

Question 1:

If I drop all of the dw tables/dw user and recreate - do I lose anything? 

Answer 1:

No, you will not loose the data


Question 2:

If I installed DCC - would all of this get fixed?

Answer 2:

No need to install DCC here. Just correct your mess in the data warehouse.

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.