IBM Support

TM1.SQLAPI 01000[Microsoft][ODBC Driver Manager] Cursor library not used. Load failed

Troubleshooting


Problem

The following error appears in tm1server.log:
TM1.SQLAPI 01000[Microsoft][ODBC Driver Manager] Cursor library not used. Load failed

Cause

Enhanced SQL error logging in tm1server.log since 2.0.9.4

Resolving The Problem

From the documentation:

As of Planning Analytics 2.0.9.4, the TM1 Server now processes more ODBC driver errors and reports them in the server message log (tm1server.log). As a result, you may see SQL errors in tm1server.log that were not previously reported.

These errors from the ODBC driver have always existed, but were not written to the server message log prior to Planning Analytics 2.0.9.4. The errors are discoverable using the tracing capability of your ODBC administrator tool.

Any SQL errors reported in tm1server.log originate from the ODBC driver. You can use these errors to review issues with your ODBC driver and to pursue support with your ODBC vendor.

Document Location

Worldwide

[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSD29G","label":"IBM Planning Analytics"},"ARM Category":[{"code":"a8m50000000KzJdAAK","label":"Modelling->Turbo Integrator"},{"code":"a8m0z000000blfjAAA","label":"Troubleshooting"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]

Document Information

Modified date:
26 July 2021

UID

ibm16475251