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.
Cause
Azure Synapse does not support cursors
Resolving The Problem
Add the following line before the SQL statement:
SET NOCOUNT ON
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":"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"}]
Was this topic helpful?
Document Information
Modified date:
27 January 2023
UID
ibm16858049