[MicroStrategy][Oracle] 'Optional feature not implemented' error message appears when attempting to run a query with 'CURRENT_TIMESTAMP' function using the MicroStrategy ODBC Driver for Oracle Wire Protocol

 Issue:

Users encounter an 'Optional feature not implemented' error when executing a query with the 'CURRENT_TIMESTAMP' function using the MicroStrategy ODBC Driver for Oracle Wire Protocol. This function, crucial for generating current date or timestamp columns in reports, triggers the error due to a specific setting.

Message:

Execute Query failed. Error type: Odbc error. Odbc operation attempted: SQLExecDirect. Optional feature not implemented.

Root Cause:

The error results from the absence of the 'Enable Timestamp With Timezone' setting in the DSN for the MicroStrategy ODBC Driver for Oracle Wire Protocol. This setting is necessary to support the 'CURRENT_TIMESTAMP' function.

Fix:

Enable 'Enable Timestamp With Timezone' in the ODBC DSN's 'Advanced' tab.

Use the MicroStrategy Connectivity Configuration Wizard to create the DSN, ensuring the correct setting.

If created on Unix, set EnableTimestampWithTimeZone=1 in the odbc.ini file.

Note: For existing DSNs created with the MicroStrategy Connectivity Configuration Wizard, use the Microsoft ODBC Data Source Administrator to modify the 'Enable Timestamp With Timezone' setting.

Summarization: The 'Optional feature not implemented' error arises when using the 'CURRENT_TIMESTAMP' function with the MicroStrategy ODBC Driver for Oracle Wire Protocol. To resolve, enable 'Enable Timestamp With Timezone' in the DSN settings using the MicroStrategy Connectivity Configuration Wizard or manual adjustments on Unix.