It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×42,785
×10,907
×7,381
×3,952

question asked: Nov 20 '12, 6:35 a.m.
question was seen: 3,254 times
last updated: Nov 20 '12, 8:12 a.m.

Related questions

FAQ - How this Forum works

DataWarehouse issues

0
Mark Ireland (261●1●57●48) | asked Nov 20 '12, 6:35 a.m.
We have problems with our DW in that when we look at DW status we get that the data warehouse is not configured.
We have gone through setup and it is all clear.
The logs show the issue as :-

"java.sql.SQLException: ORA-00942: table or view does not exist"

We wondered if the following would resolve?

Backup DB's
Drop / recreate DW
Rerun setup OR repotools-<all_apps> -createWarehouse

Finally, How do we find out what table or view it is upset over?

Regards

Mark.

One answer

Most liked answers ↓|Newest answers|Oldest answers

0
permanent link
Mark Ireland (261●1●57●48) | answered Nov 20 '12, 8:12 a.m.
Required a stop a start after rerunning the setup and ensuring the oracle user have correct perms.

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.