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