OpenWorklist timeouterrors after upgrade from Sp2a to Sp4a

Hi Blake

Thanks for getting back to me.

Unfortunately we need process data (we filter and sort the data) so we can't set NoData to true.

Thanks for the advice and I've been investigating further on the SQL aspect of the problem.

When the OpenWorkList call is made K2 starts processing. The K2 log file shows that it has opened the worklist for the user, then opens the worklist displaying the count, number of bytes and time taken (about 4 seconds). It then starts sending and receiving to load each WorkListItem. This is shown in SQL Profiler as executing the stored procedure kfieldOnDemand for each process instance. While the process is running the web app will timeout with the “Thread was being aborted” error in the event log, but within SQL Profiler it is still processing through all the process instances until complete.

As mentioned in my original post we have already indexed the K2 database, which included the tables that kfieldOnDemand references. The SQL statement that is built (as we are now on SP4) takes only 20 milliseconds.

Is there anyway of configuring OpenWorkList to wait for all the data? or any other ideas?

Paresh

Hi All,

         I am new user for this k2 forum.

my application used k2 rom.When I open ,K2Connection.OpenWorklist(worklistCriteria),

worklist.count is 0,there should be 1 actually I think.How can I solve please help me ?

daniel_1978

Hi Smully,

                   Thanks for your reply.Please see muy code below

WorklistCriteria wlCriteria = new WorklistCriteria();
            wlCriteria.AddFilterField(WCLogical.And, WCField.ProcessData, DataField.Agreement_ID, WCCompare.Equal,
                                     Agreement_ID.ToString());          
wlCriteria.AddFilterField(WCLogical.And, WCField.ProcessFolio, WCCompare.Equal, AgreementNumber);
wlCriteria.AddFilterField(WCLogical.And, WCField.ActivityName, WCCompare.NotEqual, "Global Reminder");

Worklist wl = K2Connection.OpenWorklist(wlCriteria);

I have created 2 agreement,ID-2010-0022 and ID-2010-0042 since last week,now Once I open

ID-2010-0042 is still ok that wl count is returning 1 but ID-2010-0022 is returning 0 and I can't do

other process if I got return is 0.This problem is happen after 2 or 3 days of that I have created

agreements.Is that something we need to change any timeing status or whichever in k2 workflow

side to get the worklist?Please any replys are very helpfull for me.Thanks alot

Regards,

daniel_1978