0 Replies Latest reply on Jun 18, 2013 7:32 AM by u005078

    SQL2: INNER JOIN returns message: WARN NodeIteratorImpl - Exception retrieving Node with Id: null

    u005078 Level 1

      We need to find the "jcr:lastModified"-property of "nt:file"-nodes. The property is maintained at the child-node "jcr:content" which (normally) has a type of "nt:resource". Right now I already fail to retrieve all  those "nt:file"-nodes which have a "nt:resource"-type node as child. The query:

       

        "SELECT * FROM [nt:file] AS parent " +

         "INNER JOIN [nt:resource] AS child ON ISCHILDNODE(child,parent) " +

         "WHERE ISDESCENDANTNODE(parent,[/content/testit])";

       

      doesn't return any node but displays for each of the (four) eligible nodes of this subtree the message:

         WARN NodeIteratorImpl - Exception retrieving Node with Id: null

       

      Neither the Server nor this code are throwing an exception.

       

      brgds,

      Ulrich