Solved

WorkflowInstanceTasks table has reached 87% of the threshold (43301/50000)

  • 3 April 2023
  • 3 replies
  • 139 views

Badge +1

i got this warning on central administration and purge not affected on decreasing number of rows, any idea how i can deal with this table keeping in consideration this is a production area.

 

icon

Best answer by Garrett 3 April 2023, 13:24

View original

3 replies

Userlevel 6
Badge +16

Hi @emanabdelhalim 

 

Refer to the Help Manual

https://help.nintex.com/en-US/nintex2019/current/sp2019/DatabaseDesign/MonitorWorkflowData.htm

 

You need to purge the Workflow data. Refer here

https://help.nintex.com/en-US/nintex2019/current/sp2019/DatabaseDesign/PurgeWorkflowData.htm

 

Pls read the entire document first. Avoid reading one part or section and immediate take action. 
If you are new or this is your first time, Perform a backup first.

Badge +1

thanks @Garrett  for your replay, i already read this articles before but as i mentioned purge data not reduce rows on WorkflowInstanceTasks table it still the same

i need steps to clean this table WorkflowInstanceTasks something like the Purge or shall i delete them directly from database?

Badge

thanks @Garrett  for your replay, i already read this articles before but as i mentioned purge data not reduce rows on WorkflowInstanceTasks table it still the same

i need steps to clean this table WorkflowInstanceTasks something like the Purge or shall i delete them directly from database?

 

Same issue here

Reply