Table does not exist ; ORA-00942

[Former Member]

How do I fix this ?

[former_member195290]

Hi David,

You should check the SCN Network first for similar kind of issues.

Check this:

http://scn.sap.com/thread/3438952

Regards,

Javed

[Former Member]

Several reasons for this:

The user defined in the universe connection does not have select privileges on the table

The table name is spelt wrong (e.g. when building a derived table)

The schema name needs to be stated explicitly when identifying the table.

The table/view has been removed or renamed - check with your dba.

[former_member219634]

Hi David,

When you got this error message : refresh universe struture, create a webi document, refresh a crystal report, in IDT, in designer, etc?

Did you check that the table exists in data base according to shema used on the connection?

Best Regards

Ines