Tm1 sql and load issue

Post Reply
manu0521
Posts: 124
Joined: Wed Nov 26, 2014 8:32 pm
OLAP Product: IBM TM1, Planning Analytics
Version: PA 2.0.5
Excel Version: 2016

Tm1 sql and load issue

Post by manu0521 » Sat Jun 05, 2021 11:22 am

HI,

I am having this error in error log.

[Microsoft][ODBC Driver Manager] Cursor library not used. Load failed

Tried to run a ti with a sql on it , Sql is pretty simple and returns only few rows , the issue happens when i dont save the ti process and just try to go to variable table after previewing sample data.

In Paw I see the process is running processexecute sql query but never ends .

I was not able to stop the service normally and it goes to stopping state . Taskkill also gives me an issue .SO I had to restart the box . Do you guys have any suggestions on how to debug this .

14616 [4] ERROR 2021-06-05 07:43:40.160 TM1.SQLAPI 01000[Microsoft][ODBC SQL Server Driver][SQL Server]Changed database context to 'dwh_core'.
14616 [4] ERROR 2021-06-05 07:43:40.160 TM1.SQLAPI 01000[Microsoft][ODBC SQL Server Driver][SQL Server]Changed language setting to us_english.

Thanks,

Post Reply