Solved

Workflows not starting

  • 20 June 2023
  • 4 replies
  • 94 views

Badge +4

On items creation, workflows are not getting triggered. Workflow setting is also set such workflow should trigger in item creation. It issue occurs ranmdomly, where some items gets tiggered while some doesnot.

icon

Best answer by majid_sahib 7 July 2023, 23:38

View original

4 replies

Userlevel 1
Badge +5

Hi @SM123 

Please send us the result of these steps:
 

It might be a performance issue
Please provide the following info:
 
1.  How many items are in your 'NintexWorkflowHistory' lists?  (should be under 5,000 items)
Navigate to Http://SiteName/Lists/NintexWorkflowHistory and check how many items are present.
or 
go to Site Settings --> find a Nintex Workflow group -->click on the "Manage workflow history lists" link
 
2.  How many workflow tasks are in the Task List this workflow utilizes?  (should be under 5,000 items)
Navigate to the task list your workflow/task action is configured to use and check how many items are present

3.  How many rows are in your 'dbo.WorkflowProgress' table in your Nintex Workflow databases (SQL)?  
 
5.  Also, please create a and run a simple workflow test on the same SiteCollection : and provide us with the result.
- using Nintex workflow : START -> Log history -> Pause 5 min -> Log history -> END     save/publish and run, does it run and complete within 5 min?
- using SharePoint Designer workflow (SPD) : START -> Log history -> Pause 5 min -> Log history -> END     save/publish and run, does it run and complete within 5 min?

Also, would you be able to check How many items are in the SharePoint table [ScheduledWorkItems] ? this table should be in the SharePoint content DB.
 it might be that the SPTimer job is so busy processing this job queue when it comes to processing a workflow with Pause action.

 

Thanks,Majid
  

Userlevel 5
Badge +20

Hi @SM123 
Have you resolved your issue?

Badge +4

Hi @SM123 

Please send us the result of these steps:
 

It might be a performance issue
Please provide the following info:
 
1.  How many items are in your 'NintexWorkflowHistory' lists?  (should be under 5,000 items)
Navigate to Http://SiteName/Lists/NintexWorkflowHistory and check how many items are present.
or 
go to Site Settings --> find a Nintex Workflow group -->click on the "Manage workflow history lists" link
 
2.  How many workflow tasks are in the Task List this workflow utilizes?  (should be under 5,000 items)
Navigate to the task list your workflow/task action is configured to use and check how many items are present

3.  How many rows are in your 'dbo.WorkflowProgress' table in your Nintex Workflow databases (SQL)?  
 
5.  Also, please create a and run a simple workflow test on the same SiteCollection : and provide us with the result.
- using Nintex workflow : START -> Log history -> Pause 5 min -> Log history -> END     save/publish and run, does it run and complete within 5 min?
- using SharePoint Designer workflow (SPD) : START -> Log history -> Pause 5 min -> Log history -> END     save/publish and run, does it run and complete within 5 min?

Also, would you be able to check How many items are in the SharePoint table [ScheduledWorkItems] ? this table should be in the SharePoint content DB.
 it might be that the SPTimer job is so busy processing this job queue when it comes to processing a workflow with Pause action.

 

Thanks,Majid
  

 

Hi Majid,

How do you clean up the NintexWorkflowHistory lists and workflow task lists if they are well over 5,000 items?

Thanks,

Jamie

Userlevel 1
Badge +5

Hi Jamie @SM123 

regarding the Nintex history list please follow these steps : 

for workflow Task List : please follow these steps : 

 

As best practice: if you believe your workflow design would create too many History List items and too many Tasks, its best practice for that specific workflow to have its own history and task list as following :

New Task for specific workflow : 

New History List : https://help.nintex.com/en-us/nintex2013/help/workflow/RootCategory/SharePoint/Nintex.Workflow.ManageHistoryLists.htm

 

hope that help,
Majid

Reply