Sql Failed from TI Process , able to execute with same user on ssms
Posted: Thu Nov 19, 2020 9:54 pm
Hi ,
I am having an issue where I have a sql in my ti and it fails .
The test connection is sucessfull . Few tables fails, but when tested the same tables in sql server management studio works fine.
The error i am getting is
19828 [50] ERROR 2020-11-19 21:38:50.245 TM1.SQLAPI 37000[Microsoft][ODBC SQL Server Driver][SQL Server]Internal Query Processor Error: The query processor could not obtain access to a required interface.
I am also seeing some error like
19828 [50] ERROR 2020-11-19 21:28:02.573 TM1.SQLAPI 37000[Microsoft][ODBC SQL Server Driver][SQL Server]Cursors are not supported on a table which has a clustered columnstore index.
19828 [50] ERROR 2020-11-19 21:29:11.239 TM1.SQLAPI 37000[Microsoft][ODBC SQL Server Driver][SQL Server]Cursors are not supported on a table which has a clustered columnstore index.
Did anyone face similar issue, I checked with dba and table access looks good.
Thanks,
I am having an issue where I have a sql in my ti and it fails .
The test connection is sucessfull . Few tables fails, but when tested the same tables in sql server management studio works fine.
The error i am getting is
19828 [50] ERROR 2020-11-19 21:38:50.245 TM1.SQLAPI 37000[Microsoft][ODBC SQL Server Driver][SQL Server]Internal Query Processor Error: The query processor could not obtain access to a required interface.
I am also seeing some error like
19828 [50] ERROR 2020-11-19 21:28:02.573 TM1.SQLAPI 37000[Microsoft][ODBC SQL Server Driver][SQL Server]Cursors are not supported on a table which has a clustered columnstore index.
19828 [50] ERROR 2020-11-19 21:29:11.239 TM1.SQLAPI 37000[Microsoft][ODBC SQL Server Driver][SQL Server]Cursors are not supported on a table which has a clustered columnstore index.
Did anyone face similar issue, I checked with dba and table access looks good.
Thanks,