SQL SmartObject List methods set to Rollback on failed transaction, returns the following error:
You can simulate the error for the list method in dbo.SimpleTable if 'Use Native SQL Execution' is set to false and transaction is also set to rollback. If you set this property to true but rollback is retained, then you will not get an error.
If this is set to rollback, it causes a deadlock. This is reproducible in SQL Management Studio:
CREATE TYPE [tmp_cd75e2ebb5794467b39691937010c611] AS TABLE(
Value0 Int NOT NULL,
Value1 Int NOT NULL )
declare @myPK [tmp_cd75e2ebb5794467b39691937010c611];
This looks to be a Microsoft SQL issue: https://dba.stackexchange.com/questions/52900/can-i-create-a-user-defined-table-type-and-use-it-in-t....
For now, switching the transaction type to Continue would be the workaround.
If there are a lot of SmartObjects involved, you may use the script below to update this in bulk. Please remember to make a back-up of the K2 database before proceeding:
1. Get SmartObjects which has methods set to Rollback.
2. Update the transaction Continue.