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.
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.