Sign in Register
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?

    Copy Link
  • 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?

    Copy Link

  • Comment author was deleted

    Oct 25, 2016 @ 20:10

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

    Copy Link
  • Nicholas Westby 2054 posts 7104 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.

    Copy Link

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies