Sql Failed from TI Process , able to execute with same user on ssms

[manu0521]

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,

[manu0521]

Adding

Begin

and

End

Fixed the issue