Repository Database is upgraded from 8i to 9i

server administration Web Intelligence 6.x Servers
1

Hi ,
We have BO5.x and webi2…73 ,The Repository Database is upgraded from 8i to 9i (Schema name ,userid and server is the same just the version has been changed from 8i to 9i)
When we try to retrieve/publish documents the reports from repository we are getting error

Error During Import(DX0005)
ORA-00942 table or view does not exist
DB Error -942(DX0045)

Is it Database upgrade related error or Some BO related error? Does anyone know how to resolve it any clues?

manjunarayan4 (BOB member since 2005-04-06)

2

Where are you receiving this error - in webi or BO?
The Error_Messages guide from BO explains what the problem is - Repository /Domain access is not happening.
Check your middleware and use an Oracle tool to see if you can access the table space/instance where your repository is.

MikeD :south_africa: (BOB member since 2002-06-18)

3

I am getting this issue in Full Client BO . I did not try with Webi. Do you think its because of Database upgrade error or a BO related error.

manjunarayan4 (BOB member since 2005-04-06)

4

My guess is that it is related to your upgrade if nothing changed in your BO environment. Perhaps it is something simple, like the DBA did not grant select on the repository tables to the BO oracle ID. Check things like that first.

We upgraded from 8i to 10g last year with no problems.

Good luck! :smiley:

Andrew Mitchell :canada: (BOB member since 2003-06-09)