Forum Discussion
Suspended Workflows
Dear Community,
I have a workflow that processes travel claims, The SharePoint Online List exceeded its limit from 5000 and most of the workflows were suspended. Then I archived the SharePoint List, and made some space. But still the workflows are suspended and I get this Error
System.ApplicationException: HTTP 500 {"error":{"code":"-2147024860, Microsoft.SharePoint.SPQueryThrottledException","message":{"lang":"en-US","value":"The attempted operation is prohibited because it exceeds the list view threshold.
and the Workflow wont Start.
Some workflow have started but they are not moving further to next stage and with I checked, Got this Error
Suspend this workflow
Activity in progress
Retrying last request. Next attempt scheduled after 7/24/2023 10:30 PM. Details of last request: HTTP InternalServerError to https://XXXX.sharepoint.com/_api/web/lists(guid'20f89c6d-8d33-421f-9843-8c1ef03a2c3c')/Items?%24filter=GUID+eq+guid%278f86090a-ef0f-4160-bed3-f337c25354e8%27&%24select=ID%2CID Correlation Id: c0c325d3-ca88-9231-a236-0095202216c6 Instance Id: 50a8606c-a8a5-4462-9c9d-e436a59a8219
The attempted operation is prohibited because it exceeds the list view threshold.
Retry now
Please can any one help to resolve this matter.
Regards
9 Replies
- Dear Fellows,
I would like to thank you all for help me out. The issue was that along with the SharePoint List, a Workflow List was also maintained. That list had reached the threshold limit of 5000. Actually this list was causing the issue. as soon as I archived the completed workflows to another list, the Suspended State of all the Workflows changed to Started State and still working. Now, what I am planning is to write a workflow in Power Automate to move both the Claims LIST and Workflow List tasks whose status is completed to another separate List and Workflow List respectively for archiving. The Power Automate does not recognize Workflow Lists, So I used it ID and writing the workflow for archiving both the lists. Thank you all once again for the wonderful help - Hi Tayyab Hussain,
Please go through https://learn.microsoft.com/en-us/sharepoint/troubleshoot/workflows/workflow-status-suspendedThanks for sharing the workaround. I think this will work. I have restarted a flow and lets check the results.
- Don't think those are related issues but we'll see. Anyway, you never verified if this is onprem or online SP?
- You have 2013 listed thou. If this is on prem, you can change the list view threshold in the admin center for the web application as well. Not sure if 2013 indexes will make a difference as that is a newer tech adding to Online in 2016+ or so. I used to just bump the list threashold setting.
- Depending on the fields involved in the flow, you can go to the list itself and go down and create more indexes on the list. Any search or direct field being used in the view can have an index added and it might rectify the issue. You might discover there is no indexes at all and sometimes just having one for created or one of your main columns will be enough.
Thank you for the reply, I already have 10 Indices
- https://afhco.sharepoint.com/_layouts/15/EditIndex.aspx?List=83eaeb69-7438-4246-bdd6-960fe9de3d6e&Index=8c06beca-0777-48f7-91c7-6da68bc07b69
- https://afhco.sharepoint.com/_layouts/15/EditIndex.aspx?List=83eaeb69-7438-4246-bdd6-960fe9de3d6e&Index=1df5e554-ec7e-46a6-901d-d85a3881cb18
- https://afhco.sharepoint.com/_layouts/15/EditIndex.aspx?List=83eaeb69-7438-4246-bdd6-960fe9de3d6e&Index=f9a44731-84eb-43a4-9973-cd2953ad8646
- https://afhco.sharepoint.com/_layouts/15/EditIndex.aspx?List=83eaeb69-7438-4246-bdd6-960fe9de3d6e&Index=1999c326-f6a1-4eab-be1f-059b02c177cf
- https://afhco.sharepoint.com/_layouts/15/EditIndex.aspx?List=83eaeb69-7438-4246-bdd6-960fe9de3d6e&Index=886cd2f6-650d-44b7-a51e-eb20d0fe711b
- https://afhco.sharepoint.com/_layouts/15/EditIndex.aspx?List=83eaeb69-7438-4246-bdd6-960fe9de3d6e&Index=3afcc5c7-c6ef-44f8-9479-3561d72f9e8e
- https://afhco.sharepoint.com/_layouts/15/EditIndex.aspx?List=83eaeb69-7438-4246-bdd6-960fe9de3d6e&Index=28cf69c5-fa48-462a-b5cd-27b6f9d2bd5f
- https://afhco.sharepoint.com/_layouts/15/EditIndex.aspx?List=83eaeb69-7438-4246-bdd6-960fe9de3d6e&Index=fa564e0f-0c70-4ab9-b863-0177e6ddd247
- https://afhco.sharepoint.com/_layouts/15/EditIndex.aspx?List=83eaeb69-7438-4246-bdd6-960fe9de3d6e&Index=b8fb1700-4bb8-4c75-85a0-218d7f2cf0d3
- https://afhco.sharepoint.com/_layouts/15/EditIndex.aspx?List=83eaeb69-7438-4246-bdd6-960fe9de3d6e&Index=9cc709a3-dfbe-4f06-8249-d63365ac8d2c
- https://afhco.sharepoint.com/_layouts/15/EditIndex.aspx?List=83eaeb69-7438-4246-bdd6-960fe9de3d6e&Index=a5a3f106-cbd5-41d0-aabd-149521616086
and added a new index Employee No. But still this wont work
Regards
