Sqlexception when use GetWorklistItems method

Hi Laszlo,

I'm assuming your service code is using the SourceCode.Workflow.Management API when calling GetWorklistItems().

First, double check to make sure the account making the call for the worklist has Admin rights to K2. If it does and you're still seeing SQL Server kick this error, I would suggest opening a ticket with Nintex support to see if they can help you dig deeper. 

Jason

Hi David!

I think i found the problem. We use a filter before call GetWorklistItems to filter a special serial numbers and actions to the user.

This is the part of the code:

foreach (var item in serialNumbers)
{
var splitted = item.Split('_');
var procinstid = int.Parse(splitted[0]);
var activity = int.Parse(splitted[1]);

wCrit.AddRegularFilter(WorklistFields.ProcInstID, Comparison.Equals, procinstid, RegularFilter.FilterCondition.OR_OPEN);
wCrit.AddRegularFilter(WorklistFields.ActInstDestId, Comparison.Equals, activity, RegularFilter.FilterCondition.AND_CLOSE);
}

WorklistItems wlistitems = wms.GetWorklistItems(wCrit);

If the number of the serialNumbers is greater than 95 the error will occur

Thanks for help, at first I'll create a new case to the support because it's seems very easy to fix the dynamic slq (change DECLARE @paramlist NVARCHAR(4000) to DECLARE @paramlist NVARCHAR(Max))