Hi

Please try set 'Use Native SQL Execution' to 'false' on your SQL servicr instance and testing again. it should resolve this issue.

Please have a look at some of the  possible ways of going about the solutifon:

Unable to a connect to SQL Server Instance when connecting through Azure SQL Service

https://community.k2.com/t5/K2-blackpearl-Articles/Unable-to-a-connect-to-SQL-Server-Instance-when-connecting/ta-p/94228

SQL script error during installation of 4.7 CU (TRY_CONVERT is not a recognized)

https://community.k2.com/t5/K2-blackpearl-Articles/SQL-script-error-during-installation-of-4-7-CU-TRY-CONVERT-is/ta-p/97395

------------------------------------------------------------------------------------------------------------------------------------------------------------------

------------------------------------------------------------------------------------------------------------------------------------------------------------------

Based on the symptoms above, you may need to verify the records in the column mentioned in the error message. (Check for empty values or values in the wrong format) as one "bad record" is enough for the List method to fail.)

The fact that other methods are working indicates that there are no issues with the SmartObject itself, but rather a problem caused by data.  You can resolve this by deleting the incorrect entry / entries.

Ref: https://help.k2.com/support-services/kbt154607

-----------------------------------------------------------------------------------------------------------------------------------------------------------------

-----------------------------------------------------------------------------------------------------------------------------------------------------------------

Hope this helps you.

Hi ProInception

This issue has been resolved by setting the service instance to use SQL native execution. The impact of this is to help with the performance of SQL based smart objects. You can have a look at the video below in regards to this.

https://help.k2.com/displaycontent.aspx?id=5998

Regards

Elvis