Skip to main content
Nintex Community Menu Bar
Solved

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

  • April 3, 2023
  • 3 replies
  • 254 views

Forum|alt.badge.img+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.

 

Best answer by Garrett

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.

3 replies

Garrett
Forum|alt.badge.img+16
  • Scout
  • Answer
  • April 3, 2023

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.


Forum|alt.badge.img+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?


Forum|alt.badge.img
  • Novice
  • October 2, 2023

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