Skip to main content
Nintex Community Menu Bar

Workflow run and always Workflow failed on start (retrying) when use Query Items action with more than 5000 items

  • May 27, 2018
  • 2 replies
  • 31 views

Forum|alt.badge.img+1

Hi,

Currently, my site workflow is struggling with Performance. Because it is using the Query Item action to query more than 5000 items in a list. After that I use the Foreach action to loop those items to do my business. But it always get failed on start (retrying) after I started workflow for 10 mins.

‌ 

anyone please let me know your solution ? I knew it is the Performance problem where I use to Query Items action. But my business have to query more than 5000 items. 

Thanks and regards,

//Tan Nguyen

2 replies

Forum|alt.badge.img+14
  • Scholar
  • May 28, 2018

you'll have to process all those items in smaller batches.

sharepoint itself (by default) limits max number of items items returned per view/query to 5000 items.


Forum|alt.badge.img+1
  • Author
  • June 3, 2018

Thanks Marian Hatala,

I will try to divide into small batches and query if it works.