Troubleshooting
Problem
This happens when MSSQL is on Azure.
Within Planning Analytics, when you execute a simple query, it errors saying: Error executing SQL query.
Symptom
If you look at the corresponding tm1server.log, you see: Cursor support is not an implemented feature for SQL Server Parallel DataWarehousing TDS endpoint.
Resolving The Problem
There were some ODBC changes made in Planning Analytics version 2.0.9.13 and above. If you are using any of those versions, as a workaround, you can add the following line to the top of your query:
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":"SSD29G","label":"IBM Planning Analytics"},"ARM Category":[{"code":"a8m3p000000PC9LAAW","label":"Planning Analytics-\u003EServer Data Tier"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]
Was this topic helpful?
Document Information
Modified date:
17 January 2023
UID
ibm16855861