SYMPTOM:
When executing reports using Strategy Developer 9.x, the following error occurs:
Status: Execution failed
Error: SQL Generation Complete
QueryEngine encountered error: Execute Query failed. Error type: Odbc error. Odbc operation attempted: SQLExecDirect. Base object not found. Original SQLSTATE was 42704.
Error in Process method of Component: QueryEngineServer, Project Layered Inventory PROD, Job 973, Error Code= -2147212544.
CAUSE:
This error is caused by incorrect SQL statements defined for the Warehouse Catalog.
ACTION:
To resolve this issue, the user must modify the catalog SQL for retrieving the tables from the Warehouse.
If the tables have a prefix in the database, the SQL must be changed so it will pull the table name as prefix.table_name.
The SQL statements required will be different depending on the database used. Contact the Database Administrator for more details.
