Skip to main content
Nintex Community Menu Bar

Sometimes need to run a report that filters with:

- specific process

- specific activity

- date range

- Action = Approve

 

Report to list the destination user that approved.

 

serverlog.actinstdest table has 11,457,455 rows.

serverlog.procinst has 657,772 rows.

 

I get timed outs using ActivityInstanceDestination SmO.   K2 5.2 FP27.

Direct query in SQL server table via joins is fast.

 

How have you guys tackled this issue?

Good day 


 


Because of this high volume of dataSet "serverlog.actinstdest table has 11,457,455 rows.


serverlog.procinst has 657,772 rows." Could you please install latest CU,


NB:- I recomment you follow this kb(http://help.k2.com/kb003190)


 


get it in this link https://portal.k2.com/products/k25-2may2019cumulativeupdate or https://portal.k2.com/products/k25-2may2019cu-fp1


 


I believe this should improve the performance as the was fix included, should you find tthis post useful kindly mark such as Kudu and/or Solution, to assist other community members absorbing relevant content on researches.


 


Thanks & regards;


Widson.


Thanks, we'll apply this CU when we get a chance. Does it improve the performance, or just extends the timeout threshold?
Hi PYao;

Yes*, please also check out with this kb(https://help.k2.com/kb002789) for performance and threshold feature issues.

please mark as kudos and/or Accepted solution if you find the provided information of use.

Regards;
Widson.

Reply