Troubleshooting
Problem
Planning Analytics on Cloud - ODBC connection to SQL Server fails due to lack of cursor support in SQL Server
Symptom
Test the connection from PA Workspace Secure Gateway or Architect, error in TM1 Server Log:
ERROR 2023-01-25 18:34:11.967 TM1.SQLAPI 37000[Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Cursor support is not an implemented feature for SQL Server Parallel DataWarehousing TDS endpoint.
Cause
Microsoft Azure Data Warehouse does not support all of the features of a typical SQL Server or SQL Azure database. Azure Data Warehouse does not support server side cursors. For example, when using a driver such as the Microsoft SQL Server ODBC driver to connect to Azure Data Warehouse, the driver/query needs to be configured to not use cursors or errors will occur on certain queries.
Resolving The Problem
Edited the query to include SET NOCOUNT ON at the beginning such as:
SET NOCOUNT ON
--SQL query code here--
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":"a8m0z000000boHzAAI","label":"Planning Analytics-\u003EPlanning Analytics On Cloud Specific-\u003ESecure Gateway Cloud Only"}],"ARM Case Number":"TS011864749","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]
Was this topic helpful?
Document Information
Modified date:
21 March 2023
UID
ibm16964818