Copied to clipboard

Flag this post as spam?

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

  • Matt Stueve 30 posts 49 karma points
    Nov 01, 2010 @ 19:00
    Matt Stueve

    Error expanding one folder in multi node tree picker


    We have an implementation of the multi tree node picker that's worked fine for weeks, but one specific instance of the picker just recently stopped working.  There's one folder which, when expanded in the picker field, doesn't show any child data and throws a .Net exception behind the scenes.  Expanding this same folder in the content tree shows its child data and works fine.  I'm assuming there's some strange content issue that recently caused this one folder to break when shown in the multi tree node picker but everything looks ok and I'm not sure why this would cause it to break. 

    Checking the event viewer I see the following exception when the ajax call is made to expand that folder (

    Server Error in '/' Application.

    The query didn't return a value.

    Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

    Exception Details: System.ArgumentException: The query didn't return a value.

    Source Error: 

    An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

    Stack Trace: 

    [ArgumentException: The query didn't return a value.]
    umbraco.DataLayer.SqlHelper`1.ExecuteXmlReader(String commandText, P[] parameters) +168
    umbraco.DataLayer.SqlHelper`1.ExecuteXmlReader(String commandText, IParameter[] parameters) +140

    [SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteXmlReader]
    umbraco.DataLayer.SqlHelper`1.ExecuteXmlReader(String commandText, IParameter[] parameters) +222
    umbraco.cms.businesslogic.web.Document.importXml() +171
    umbraco.cms.businesslogic.web.Document.ToXml(XmlDocument xd, Boolean Deep) +143
    uComponents.Core.DataTypes.MultiNodeTreePicker.FilteredContentTree.OnRenderNode(XmlTreeNode& xNode, Document doc) +121
    umbraco.cms.presentation.Trees.BaseContentTree.Render(XmlTree& Tree) +288
    umbraco.presentation.webservices.TreeDataService.LoadTree(TreeRequestParams treeParams) +156
    umbraco.presentation.webservices.TreeDataService.GetXmlTree() +198
    umbraco.presentation.webservices.TreeDataService.ProcessRequest(HttpContext context) +85
    System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +181
    System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +75

    Version Information: Microsoft .NET Framework Version:2.0.50727.4206; ASP.NET Version:2.0.50727.4205

  • Sebastiaan Janssen 4993 posts 15138 karma points MVP admin hq
    Nov 01, 2010 @ 20:53
    Sebastiaan Janssen

    If at all possible, could you download the umbraco source code from Codeplex, attach visual studio to the w3wp process and see if you get asked for the umbraco source, just point it to the correct file from the codeplex download and then you might be able to see what's wrong. Just add a breakpoint before the exception and see what is going on in the actual source.

  • Matt Stueve 30 posts 49 karma points
    Nov 01, 2010 @ 21:11
    Matt Stueve

    Looks like the issue was related to an item having a 'remove at' unpublish date.  That date had passed, the item had been unpublished, and from that point on the multi node tree picker stopped working. 

  • Matt Stueve 30 posts 49 karma points
    Nov 30, 2010 @ 16:21
    Matt Stueve

    Our client entered another remove at date for an item in the multi tree node picker which, after that date had passed, resulted in the picker no longer displaying anything.  Is there a plan to fix this so I can communicate that to the client? 

  • Matt Stueve 30 posts 49 karma points
    Aug 16, 2011 @ 22:14
    Matt Stueve

    This just came up again--does anyone have any updates on why this happens when content within the multi node tree picker has a remove at date set? Or better yet, a fix?

  • Lee Kelleher 3993 posts 15620 karma points MVP 12x admin c-trib
    Aug 17, 2011 @ 10:10
    Lee Kelleher

    Hi Matt,

    I have tried to reproduce this error, but no joy.

    In my test, I set the "Remove At" date for a content node, (to expire in 10 mins time), added that node to a MNTP and saved & published it.  I went away for 10 mins (made a cup of tea), then came back.  The content node was now unpublished (as expected), then when I viewed the MNTP, there was no error/exception.

    I had Visual Studio attached to the worker process, with a breakpoint on the "uComponents.Core.DataTypes.MultiNodeTreePicker.FilteredContentTree.OnRenderNode" call ... but no exceptions.

    Which version of Umbraco and uComponents are you using?  (I tested with Umbraco 4.7.0 and uComponents v2.2-beta)

    Thanks, Lee.

  • Matt Stueve 30 posts 49 karma points
    Aug 17, 2011 @ 17:23
    Matt Stueve

    Hi, Lee,

    Thanks for taking a look at this for me! We are running slightly older versions on this particular site--Umbraco 4.5.2 and uComponents 2.0.1.

    Do you know if uComponents 2.2 is compatible with Umbraco 4.5.2, and if so, would there be any breaking changes in the upgrade? I'd need to do some more legwork to determine the impacts of upgrading Umbraco to 4.7 as this site is running on .Net 3.5, etc.

    Thanks again!


  • Lee Kelleher 3993 posts 15620 karma points MVP 12x admin c-trib
    Aug 17, 2011 @ 17:26
    Lee Kelleher

    Hi Matt,

    We still support Umbraco 4.5.2 with uComponents 2.2 (currently beta) ... and we still compile against .NET 3.5 ... so you'll be fine with upgrading.

    If I get time, I'll try to test this with Umbraco 4.5.2, see if I can reproduce the issue.

    Cheers, Lee.

  • Tom Fulton 2030 posts 4996 karma points c-trib
    Aug 17, 2011 @ 17:28
    Tom Fulton


    FYI - there was a bug with the "Remove At" functionality in 4.5.2, where the document didn't get "fully" unpublished - it was removed from the cache but its Published flag was still set to true.  This was causing some exceptions with the Sorting functionality - and could possibly be related to this issue (?).  Perhaps MNTP is seeing the node as published but it doesn't exist in the cache/xml.

    The bug was fixed in 4.6.1.

    Hope this might help :)

  • Murray Roke 477 posts 885 karma points c-trib
    Oct 31, 2011 @ 03:38
    Murray Roke

    I am getting this error (Same stack trace) with uComponentsv 2.2Beta3 and umbraco v4.6.1 (old schema) but only on one node in my tree (that I've noticed)

    I don't think it's related to 'remove at' or anything like that.


  • Jorge 15 posts 36 karma points
    Feb 15, 2012 @ 16:51


    I was having the exact same problem. In my case it was due to the presence of corrupts nodes at the branch of the content tree. I located the nodes and then republished them, that fixed the problem and the MNTP was able to open the branch. I used the following SQL to find the corrupt nodes, they have NULL at the xml column: 

    select * from umbraconode u
    full outer join cmscontentxml c on = c.nodeid
    where u.parentid = nnn

    Hope this helps


  • Chris Randle 67 posts 181 karma points c-trib
    Jun 18, 2013 @ 10:23
    Chris Randle

    I still had this issue even after upgrading to the latest version of Umbraco 4.11.9 from 4.7.0. This seems to confirm my fears - that Umbraco just doesn't work well with the larger number of nodes.  Small-to-Medium-Enterprises (SME's) websites are usually fine. This has happened on two other websites of ours, and in the end we've had to replace the data nodes with custom usercontrols and their own secondary databases, instead of using the Umbraco framework.

Please Sign in or register to post replies

Write your reply to: