Universe and Report Error

building reports webintelligence
1

We have just moved the reports and universe to a test server. I can login into the Server itself and the Universe connection is OK.(Business Objects XI)

But when I try to create a Webi report on that Universe I get the following error.

“Query 1 - Maconomy

Database error: ORA-00942: table or view does not exist
. Contact your Business Objects administrator or database supplier for more information. (Error: WIS 10901)”

AND when I try to open existing reports I get the following error…

“An Internal error occurred while calling the ‘openDocumentMDP’ API. (Error:WIS 30270) (Error:INF)”

Any help/suggestions will be greatly appreciated……I’m STUCK

Many thanks
:?

Sims786 (BOB member since 2006-04-04)

2

Hi,

Confirm select grant on required tables in the database from your Database administrator.

Thanks & Regards
Pravin G.

pravin_gaikwad :india: (BOB member since 2010-03-27)

3

:? pravin

Not sure what you mean…I have checked the Universe and made the owner to all tables new owner BOTEST…

Can you clarify the how I would “Confirm select grant on required tables in the database from your Database administrator”

Many thanks for your help

Sims786 (BOB member since 2006-04-04)

4

You must be using some DB User_id for universe connection, right? That database ID should have SELECT access on all the database tables/views which are used in the universe, it seems that your database is Oracle, right?

Prashant Purohit :india: (BOB member since 2009-02-18)

5

Its very strange as some tables in the Universe allow me to return the “Table Values” and I can create reports from that Universe Class but others Tables Values return the error

“Exception: DBD, ORA-04063: view “BOTEST.CUSTOMER” jas errors State: N/A”

Any ideas pls

Many thanks

:hb:

Sims786 (BOB member since 2006-04-04)

6

So the DB User don’t have access on such views/tables (eg; CUSTOMER)…

Prashant Purohit :india: (BOB member since 2009-02-18)

7

It has BOTEST has the owner. How do I check if DB user if DB users has access to the views??

Many thank

Sims786 (BOB member since 2006-04-04)

8

Log on to SQL*plus with the user specified in the universe connection (which may be different to the one you use for general SQL queries).

Do a SELECT * FROM ViewName

If you can’t access it, you’ll get the ORA error you got before.