[MicroStrategy][Oracle] MicroStrategy Oracle ODBC Driver Error Message with “Driver does not support this function

 Issue:

When executing dossiers or reports in MicroStrategy using Oracle as a data warehouse with parameterized queries enabled, users encounter the error message:

"Error: QueryEngine encountered error: OdbcPreparedStatement::GetParameterDataTypes() failed. [IM001:0: on SQLHANDLE] [Microsoft][ODBC Driver Manager] Driver does not support this function."

This issue arises when attempting parameterized queries, and the feature is confirmed to be enabled.

Root Cause: The error is caused by the Oracle ODBC Driver encountering a limitation – it does not support the SQLDescribeParam function. This limitation becomes apparent when executing parameterized queries in MicroStrategy.

Fix: To address the issue, users need to check and add a specific parameter for Windows-created Oracle ODBC DSN (Data Source Name).

For Oracle Linux ODBC DSN and Oracle ODBC DSN-less connection strings, the parameter "EnableDescribeParam = 1" should be added.

This action ensures compatibility and resolves the "driver does not support this function" error.

Note: MicroStrategy's Technology team is currently reviewing the situation for potential enhancement in an upcoming MicroStrategy release. Always refer to MicroStrategy's documentation for the latest information and updates related to specific versions.

LINK: https://community.microstrategy.com/s/article/KB484759-MicroStrategy-Oracle-ODBC-Driver-Error-Message-with-Driver-does-not-support-this-function?language=en_US