MicroStrategy ONE
Freeform SQL Report Error
When you run a Freeform SQL report, you might see the following error message:
Error: SQL Generation CompleteQueryEngine encountered error. Execute Query failed. Error type: ODBC error. ODBC operation attempted: SQLExecDirect. [37000-3100 on HSTMT][Microsoft][ODBC Excel driver] Syntax error [missing operator] in query expression `pa0.DAY_DATE WJXBFSO` Error in process method of Component: QueryEngineServer, Project MicroStrategy Tutorial, Job 1098, Error Code=-2147212544.
This error message can result from an incorrect setting in the database instance. If the database instance is using a Microsoft Excel file as a data source and the database instance type is set to Generic DBMS, there is a change in the syntax. This change in the syntax generates the error message.
To avoid this, change the Database connection type of the database instance to Microsoft Excel 2000/2003 as follows:
- From the Developer Folder List, expand Administration, and then select Database Instance Manager.
- Right-click the name of the database instance that you want to modify and select Edit.
- On the General tab, select the Database connection type as Microsoft Excel 2000/2003.
- Click OK.
For the change to take effect, you must restart the Intelligence Server that uses this database instance.