Question Re: Reg: Webi Report Error Table or View does not exist in Technology Q&A

Reg: Webi Report Error Table or View does not exist

Former Member — Fri, 29 Nov 2013 13:48:20 GMT

Hi ,

When i tried to open the below report am getting the following error. But am able to open rest of the reports under the same universe.

I really appreciate your help on this issue. I couldn't get the root cause of this issue.

Thanks & Regards,

Kumar

Re: Reg: Webi Report Error Table or View does not exist

former_member184594 — Fri, 29 Nov 2013 13:54:25 GMT

The problem is not related to WebI. The tables or views which your report based on is deleted or no longer exist in your Oracle database.

Go to your database and check if the tables you are trying to reach are there and after that check your universe.

Re: Reg: Webi Report Error Table or View does not exist

Former Member — Fri, 29 Nov 2013 14:03:39 GMT

Hi Zahid,

Thanks for the Reply

I got it, but some more doubts

1. we have only 20fields which we are using in "Contracts by planner" report from the same universe of what other reports was build.

2. almost all the fields which used in this report was used in other reports as well.

3. as per your statement if their is a table deleted then all the reports which was using the field from the deleted table will get the error.

4. if that is not the case then this report alone is using fields from different tables than other reports.

Requesting you to please clarify on this.

Thanks & Regards,

Kumar

Re: Reg: Webi Report Error Table or View does not exist

former_member184594 — Fri, 29 Nov 2013 14:37:33 GMT

Check the universe integrity if you can parse all the objects. It may be just one object that based on the table deleted causing this problem.

Check if you can see the SQL code generated in WebI. Try to run this code in your datbase directly instead of running in WebI.

I am telling you this error is NOT related to WebI.

Re: Reg: Webi Report Error Table or View does not exist

Former Member — Mon, 02 Dec 2013 06:40:58 GMT

Hi Kumar,

Try creating a another report with the same objects and check if it works fine. If the new reports running without error then your current report might got corrupted and giving error. Creating another report is the better option then.

Re: Reg: Webi Report Error Table or View does not exist

Former Member — Mon, 02 Dec 2013 06:46:23 GMT

Hi,

There is a problem with Data base, may be one of the table which you used in your current report, does not exist or there might be some process going behind ETL end. Check with your ETL team.