cancel
Showing results for 
Search instead for 
Did you mean: 
Ramprasad
Nintex Newbie

Issue with workflow Timer Job

In central Administration, it is found that workflow timerjob is not running.It is getting always paused.Due to this approval in nintex workflow is not completed.Also many workflows are in starting stage.

 

Restarting the Timer job, Purging the nintex workflow history, Clearing the timer config cache didnot help to resolve this.Also no mail notification which is configured in workflow is not sent to the user.Please advise.

 

_5r6798.pngworkflowtimerjob status

Labels: (1)
0 Kudos
Reply
3 Replies
Nintex Employee
Nintex Employee

Re: Issue with workflow Timer Job

Hi,
Timer job issues are always hard to diagnose.
I suggest contacting Nintex support for this issue.

If you want to continue investigation I suggest looking at how many rows are in the dbo.workflowProgress table in the nintex content database(s). Make sure its under around 10 million rows.

Doing test 1 and 2 from the following document may also give you an insight as to what your issues may be.
https://community.nintex.com/t5/Nintex-for-SharePoint/Workflow-performance-analysis-tests-and-proble...
0 Kudos
Reply
Ramprasad
Nintex Newbie

Re: Issue with workflow Timer Job

Thanks for your Timely Reply ,It is found out that 179 million records in workflow Progress Table. SO I have Purged the Workflow History using SQL Query. But It is found out that Records from the workflow Progress Table is not reduced after the Purging. Should I need to use any other Approach for Purging the Workflow history.

 

Please advise me to reduce the Size of workflow Progress Table.

0 Kudos
Reply
Nintex Employee
Nintex Employee

Re: Issue with workflow Timer Job

Hi,

I suggest using the script and directions on the follwoing blog to purge the Workflow Progress table.
https://community.nintex.com/t5/Community-Blogs/How-to-purge-large-Nintex-Workflow-History-list-and-...

I also suggest that you purge the workflow History lists first.
0 Kudos
Reply