Database error: ORA-00942: table or view does not exist

[Former Member]

Hi All,

There is webi report which is migrated from 3.1 to 4.0 and its working fine in 3.1 Dev but showing "Database error: ORA-00942: table or view does not exist. (IES 10901) (WIS 10901)" in 4.0 Dev.

Please Help

Thanks & Regards

Mohit Gupta

[Former Member]

Hi Mohit,

Are both XI 3.1 and XI 4.x reports pointing to same reporting database and instance? I would doubt that as there would be seperate environments all together.

Check if all tables and views have been migrated from XI 3.x reporting database to XI 4.x reporting database.

Take out the SQL and check if all tables inside FROM clause exist in your reporting database of XI 4.x.

In case the reporting database is same, compare the SQLs generated in both XI 3.x and XI 4.x.

Regards,

Yuvraj

[former_member142702]

Do you use access restrictions in your universe to override the table names (table mapping) or the connection used?

Best regards

Stratos

[Former Member]

This error happens while BO tries execute an SQL statement that references a table or view that either does not exist, that you do not have access to, or that belongs to another schema and you didn't reference the table by the schema name.

Try below steps : One of them must work.

1. Generate the SQL from BOBJ webi report and run from a cleint tool like Toad or SQL developer. If the query runs the issue is with BOBJ server config or connection . If if does not you should be able to identify which of the table gives the issue. I assume it works fine in 3.1

2. Refresh the structure of universe table if it throws any issues. If it does fix the issue by checking TNSfile or security of the connection or schema name.

3.If the universe does not have any issue with any of the tables try creating a report using the same tables that throw the error if it works or not.

If this error occurred because you do not have access to the table or view, you will need to have the owner of the table/view.

[manikandan_elumalai]

kindly check whether you have the related entry in your Oracle TNSNAMES.ora file. You can also try check using Tnsping for the appropriate database.

[Former Member]

Hi Mohit,

Please check if you are using the correct user id and password for the database logon and that the user has the required rights to access the objects.

Thanks
Sabal