Tm1 sql and load issue
Posted: 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,
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,