SYMPTOM:
An error message appears when executing a report with an attribute ID set to "Text" in Strategy Developer 9.x-10.x:
Sample Code/Error
Error: SQL Generation Complete
QueryEngine encountered error: Execute Query failed. Error type: Odbc error. Odbc operation attempted: SQLExecDirect. ORA-00904: "ATTRIBUTE_ELEMENT": invalid identifier
Error in Process method of Component: QueryEngineServer, PROJECT_NAME, Job 1390, Error Code= -2147212544.
CAUSE:
The attribute ID form 'Format' is set to 'Text'. However, the column alias data type is set to 'Integer', as shown below:
ACTION:
Change the column alias data type to a proper text format such as VarChar.
