Skip to main content

Kindly help

 

When I call "OpenWorklist" function to get tasks from k2 databases the k2 engine generate script for this and it work fine for some user and get time out for another

 

I run sql profiler to track this execution and I found this issue in that script

 

This query case the problem of inbox when user delegates other users.

 

When try to measure execution plan of query I found that it create temp table and insert data on it and then execute 4 delete statements.

First, one take approximately 97% of execution plan.

 

I attach the script.

 

Regards

 

Few follow up questions:

 

  1. What is the size of the worklist of the user you are having the issue? The worklist query is a very expensive query so when you have worklists with a large number of items it eats up resources.
  2. How is the over all health of the SQL Server?
  3. Have you opened a ticket with K2 support on this issue?

Be prepared to answer numbers 1 and 2 in your support ticket as support will ask those same questions.

 

S.

 

 

 


Reply