In the Umbraco 7.5.3 back office, when attempting to alpha sort the 2,450 child nodes of a parent node, we're getting the following error in the log file:
ERROR umbraco.presentation.webservices.nodeSorter - Could not update content sort order
System.InvalidOperationException: Cannot perform a query with more than 2000 parameters
at Umbraco.Core.Persistence.Repositories.RepositoryBase`2.GetAll(TId[] ids)
at Umbraco.Core.Services.ContentService.GetByIds(IEnumerable`1 ids)
at umbraco.presentation.webservices.nodeSorter.SortContent(String[] ids, Int32 parentId)
This happens both on Azure (running SQL Azure) and on my local box (SQL 2014).
Is this a SQL issue, or is there something we can tweak in the Umbraco config to work around this?
Anyone else run into an error when attempting to sort a content tree containing more than 2000 nodes at a given level? Seems like this would be an issue for large product catalogs.
Error attempting to sort tree with more than 2000 nodes
In the Umbraco 7.5.3 back office, when attempting to alpha sort the 2,450 child nodes of a parent node, we're getting the following error in the log file:
This happens both on Azure (running SQL Azure) and on my local box (SQL 2014).
Is this a SQL issue, or is there something we can tweak in the Umbraco config to work around this?
Anyone else run into an error when attempting to sort a content tree containing more than 2000 nodes at a given level? Seems like this would be an issue for large product catalogs.
Anyone? Buehler? Anyone?
Comment author was deleted
Sounds like it's related to this one http://issues.umbraco.org/issue/U4-9112
Yep, seems similar. I have commented on that ticket to link back to this forum thread.
is working on a reply...