Troubleshooting
Problem
An ODBC data source was created to access an Azure Synapse database.
The "SQL Statement failed" error appears when we click the "Preview" button in Architect, in the TI process creation dialog.
If we try to run the process, the following error appears in tm1server.log:
SQLState: 37000 SQLMsg: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Cursor support is not an implemented feature for SQL Server Parallel DataWarehousing TDS endpoint.
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCTEW","label":"IBM Planning Analytics Local"},"ARM Category":[{"code":"a8m3p000000PC6lAAG","label":"Planning Analytics-\u003EArchitect"},{"code":"a8m3p000000PC9LAAW","label":"Planning Analytics-\u003EServer Data Tier"}],"ARM Case Number":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"All Versions"},{"Product":{"code":"SSKVSF","label":"Planning Analytics on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
More support for:
IBM Planning Analytics Local
Component:
Planning Analytics->Architect, Planning Analytics->Server Data Tier
Software version:
All Versions
Operating system(s):
Windows
Document number:
6858049
Modified date:
09 May 2025
UID
ibm16858049
Manage My Notification Subscriptions