Troubleshooting
Problem
A TI process that worked in a previous version of IBM Planning Analytics appears to hang on the call to the underlying data source.
Symptom
There are a few symptoms that can be observed:
- tm1odbcproxy64.exe PID running in Task Manager on the server where the TI is being executed
- SQLAPI and/or ODBC traces indicate the TI is waiting on results from SQLExecDirectW
- TI worked previously in previous versions of Planning Analytics such as 2.0.9.9
- SQL statement uses a view with an underlying stored procedure, directly calls a stored procedure, or uses cursors
Environment
Planning Analytics 2.0.9.18 - not tested but might occur on version 2.0.9.13+.
ODBC Driver 13 for SQL Server
ODBC Driver 17 for SQL Server
Resolving The Problem
To resolve the issue, prefix the SQL statement with the following:
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":"a8m3p000000LQtUAAW","label":"Planning Analytics"}],"ARM Case Number":"TS014220964","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]
Was this topic helpful?
Document Information
Modified date:
10 October 2023
UID
ibm17049230