Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Chuck Kirklen 36 posts 184 karma points
    Oct 19, 2016 @ 22:04
    Chuck Kirklen
    0

    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:

    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?

  • Chuck Kirklen 36 posts 184 karma points
    Oct 25, 2016 @ 20:01
    Chuck Kirklen
    0

    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

    Oct 25, 2016 @ 20:10

    Sounds like it's related to this one http://issues.umbraco.org/issue/U4-9112

  • Nicholas Westby 2054 posts 7103 karma points c-trib
    Oct 25, 2016 @ 20:56
    Nicholas Westby
    0

    Yep, seems similar. I have commented on that ticket to link back to this forum thread.

Please Sign in or register to post replies

Write your reply to:

Draft