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

Post Reply
manu0521
Posts: 94
Joined: Wed Nov 26, 2014 8:32 pm
OLAP Product: TM1
Version: 9.5
Excel Version: 2010

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

Post by manu0521 » 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,

manu0521
Posts: 94
Joined: Wed Nov 26, 2014 8:32 pm
OLAP Product: TM1
Version: 9.5
Excel Version: 2010

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

Post by manu0521 » Fri Nov 20, 2020 2:15 pm

Adding

Begin

and

End

Fixed the issue

Post Reply