Nintex forms is throwing error "The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator". However sharepoint forms are saving data to list. Is there any way to resolve this issue for nintex forms?
To clarify: The enforcement of this threshold is on the read not on the write. You should verify the threshold set in Central Administration and compare to the list size your form is working against. IF your list is over the maximum threshold set for the web application you can increase it at the farm level or, a better option imho, is to insure that your list columns are indexed and the view being displayed in your form is using those indexes.
Even with indexing, once a query result exceeds the threshold it will fail so it is necessary to determine early on how you want to persist old list items, either moving to an archive or deleting.
I got the same error when the task list exceeded the 5000 threshold, I have indexed the task list and still gets the same error.. any tips?
Hi Nada - Eventually it will not work even with indexing. You need to look at the filter in your view and be sure that the most restrictive clause comes first. The threshold will kick in on the first result set if it violates the threshold limit and return the error to the user. You can look at archiving list data, deleting it or increasing the threshold limit. You can also create a programmatic workaround to allow certain non-admin users with an exemption or you can put in place a period of time in which views can display without the thresholds.