We are running BOBJ 4.3. For a report I developed two derived tables, Native SQL Server, that performs a pivot. The SQL in both derived tables validate in the Universe.
I wrote the reports and all seems fine. Until I close the report, reopen and refresh. One of the queries gives me the following error:
The following database error occurred: [Data Federator Driver] [Server] Invalid table or view identifier ‘drv__Submission’. For information about this error, please refer to SAP Knowledge Base Article 2054721 on the SAP Support Portal. (IES 10901)
The other query will refresh fine. I can edit the report and run the change data source wizard and the report will run fine until I save, exit and rerun the report. I even tried to delete the derived table giving me the issue and rebuild under another name. Still the same error message. The SQL runs fine in SQL Management Studio, it validates when building the derived table and the query will return results in the business layer.
Any ideas?
1 Like
It turns out WEBI wasn’t using the derived table name in building the sql. It was doing with Table__162 as(sql) but it was referencing the derived table name in the actual SQL for the report. Had to revert to a custom SQL and correct it.
1 Like
I hate how it does that. Makes lots of things more complicated.
Glad you found the issue.