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:

  1. From the Developer Folder List, expand Administration, and then select Database Instance Manager.
  2. Right-click the name of the database instance that you want to modify and select Edit.
  3. On the General tab, select the Database connection type as Microsoft Excel 2000/2003.
  4. Click OK.

For the change to take effect, you must restart the Intelligence Server that uses this database instance.