SYMPTOM:
The following error message appears when executing certain reports in Strategy Desktop 9.4.1 - Developer 10.x:
Report: xxxxxx
Job: 830
Status: Execution failed
Error: SQL Generation Complete
QueryEngine encountered error: Execute Query failed. Error type: Odbc error. Odbc operation attempted: SQLExecDirect. ORA-00904: "A14"."TABLE_NAME": invalid identifier
Error in Process method of Component: QueryEngineServer, PROJECT_NAME, Job 830, Error Code= -2147212544.
Starting Time: 14:58:06
CAUSE:
The referred column name no longer exists on the database side; however, this alteration was not applied on the Strategy side too.
ACTION:
Alter the affected table on the database side in order to have same structure as well in the Strategy Warehouse Catalog.
Note: Follow the steps in the following Strategy Knowledge Base technical note in order to remove data warehouse columns that are mapped to Strategy objects:
KB9954: How to properly remove data warehouse columns that are mapped to MicroStrategy objects
Refer to the following Strategy Knowledge Base article for more information:
