[MGNLRSSAGG-1] Errors from the Query(xpath) when loading the Page containing RSS Agr. Paragraphs Created: 24/Sep/08  Updated: 28/Oct/08  Resolved: 28/Oct/08

Status: Closed
Project: Magnolia RSS Aggregator Module
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Bug Priority: Minor
Reporter: Christian Ringele Assignee: Jan Haderka
Resolution: Cannot Reproduce Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Mac OSX, Java 1.5, Tomcat 6.16


Template:
Acceptance criteria:
Empty
Task DoD:
[ ]* Doc/release notes changes? Comment present?
[ ]* Downstream builds green?
[ ]* Solution information and context easily available?
[ ]* Tests
[ ]* FixVersion filled and not yet released
[ ]  Architecture Decision Record (ADR)
Bug DoR:
[ ]* Steps to reproduce, expected, and actual results filled
[ ]* Affected version filled
Date of First Response:

 Description   

When loading/reloading a page containing RSS Agr. Paragraphs i receive errors from the Query sent to JCR.
I extracted the SQL which is sent. The SQL looks correct and gives correct results when used manually in the JCR Query tool.

The error is not bad, because the results are shown correctly within the paragraphs and work fine on the page.

Here the errors ontaining the used SQL as a sting, showing the used class too in the sting:

SQL String CombinedFeedAction: /jcr:root/rssaggregator/MagnoliaBlogs/data[1]// order by @pubDate ascending
ERROR info.magnolia.cms.core.search.QueryResultImpl QueryResultImpl.java(build:106) 24.09.2008 11:45:25 javax.jcr.ItemNotFoundException caught while iterating on query results: failed to build path of 39188755-fee7-4215-9d21-2cb0e09a4582: 31ed0c96-8cf9-486e-99a6-283e81f63b52 has no child entry for 39188755-fee7-4215-9d21-2cb0e09a4582
ERROR info.magnolia.cms.core.search.QueryResultImpl QueryResultImpl.java(build:106) 24.09.2008 11:45:25 javax.jcr.ItemNotFoundException caught while iterating on query results: failed to build path of 473a6b67-6de8-4317-8d6a-67c5720249d6: 31ed0c96-8cf9-486e-99a6-283e81f63b52 has no child entry for 473a6b67-6de8-4317-8d6a-67c5720249d6
ERROR info.magnolia.cms.core.search.QueryResultImpl QueryResultImpl.java(build:106) 24.09.2008 11:45:25 javax.jcr.ItemNotFoundException caught while iterating on query results: failed to build path of 39188755-fee7-4215-9d21-2cb0e09a4582: 31ed0c96-8cf9-486e-99a6-283e81f63b52 has no child entry for 39188755-fee7-4215-9d21-2cb0e09a4582
ERROR info.magnolia.cms.core.search.QueryResultImpl QueryResultImpl.java(build:106) 24.09.2008 11:45:25 javax.jcr.ItemNotFoundException caught while iterating on query results: failed to build path of 473a6b67-6de8-4317-8d6a-67c5720249d6: 31ed0c96-8cf9-486e-99a6-283e81f63b52 has no child entry for 473a6b67-6de8-4317-8d6a-67c5720249d6
ERROR info.magnolia.cms.core.search.QueryResultImpl QueryResultImpl.java(build:106) 24.09.2008 11:45:25 javax.jcr.ItemNotFoundException caught while iterating on query results: failed to build path of 39188755-fee7-4215-9d21-2cb0e09a4582: 31ed0c96-8cf9-486e-99a6-283e81f63b52 has no child entry for 39188755-fee7-4215-9d21-2cb0e09a4582
SQL String CombinedFeedAction: /jcr:root/rssaggregator/MagnoliaBlogs/data[1]// order by @pubDate ascending
ERROR info.magnolia.cms.core.search.QueryResultImpl QueryResultImpl.java(build:106) 24.09.2008 11:45:25 javax.jcr.ItemNotFoundException caught while iterating on query results: failed to build path of 39188755-fee7-4215-9d21-2cb0e09a4582: 31ed0c96-8cf9-486e-99a6-283e81f63b52 has no child entry for 39188755-fee7-4215-9d21-2cb0e09a4582
ERROR info.magnolia.cms.core.search.QueryResultImpl QueryResultImpl.java(build:106) 24.09.2008 11:45:25 javax.jcr.ItemNotFoundException caught while iterating on query results: failed to build path of 473a6b67-6de8-4317-8d6a-67c5720249d6: 31ed0c96-8cf9-486e-99a6-283e81f63b52 has no child entry for 473a6b67-6de8-4317-8d6a-67c5720249d6
ERROR info.magnolia.cms.core.search.QueryResultImpl QueryResultImpl.java(build:106) 24.09.2008 11:45:25 javax.jcr.ItemNotFoundException caught while iterating on query results: failed to build path of 39188755-fee7-4215-9d21-2cb0e09a4582: 31ed0c96-8cf9-486e-99a6-283e81f63b52 has no child entry for 39188755-fee7-4215-9d21-2cb0e09a4582
ERROR info.magnolia.cms.core.search.QueryResultImpl QueryResultImpl.java(build:106) 24.09.2008 11:45:25 javax.jcr.ItemNotFoundException caught while iterating on query results: failed to build path of 473a6b67-6de8-4317-8d6a-67c5720249d6: 31ed0c96-8cf9-486e-99a6-283e81f63b52 has no child entry for 473a6b67-6de8-4317-8d6a-67c5720249d6
ERROR info.magnolia.cms.core.search.QueryResultImpl QueryResultImpl.java(build:106) 24.09.2008 11:45:25 javax.jcr.ItemNotFoundException caught while iterating on query results: failed to build path of 39188755-fee7-4215-9d21-2cb0e09a4582: 31ed0c96-8cf9-486e-99a6-283e81f63b52 has no child entry for 39188755-fee7-4215-9d21-2cb0e09a4582
SQL String FeedListAction: /jcr:root/rssaggregator/MagnoliaBlogs/data/element(*, mgnl:content) order by @jcr:name
ERROR info.magnolia.cms.core.search.QueryResultImpl QueryResultImpl.java(build:106) 24.09.2008 11:45:25 javax.jcr.ItemNotFoundException caught while iterating on query results: failed to build path of 473a6b67-6de8-4317-8d6a-67c5720249d6: 31ed0c96-8cf9-486e-99a6-283e81f63b52 has no child entry for 473a6b67-6de8-4317-8d6a-67c5720249d6
ERROR info.magnolia.cms.core.search.QueryResultImpl QueryResultImpl.java(build:106) 24.09.2008 11:45:25 javax.jcr.ItemNotFoundException caught while iterating on query results: failed to build path of 39188755-fee7-4215-9d21-2cb0e09a4582: 31ed0c96-8cf9-486e-99a6-283e81f63b52 has no child entry for 39188755-fee7-4215-9d21-2cb0e09a4582
ERROR info.magnolia.cms.core.search.QueryResultImpl QueryResultImpl.java(build:106) 24.09.2008 11:45:25 javax.jcr.ItemNotFoundException caught while iterating on query results: failed to build path of 473a6b67-6de8-4317-8d6a-67c5720249d6: 31ed0c96-8cf9-486e-99a6-283e81f63b52 has no child entry for 473a6b67-6de8-4317-8d6a-67c5720249d6
ERROR info.magnolia.cms.core.search.QueryResultImpl QueryResultImpl.java(build:106) 24.09.2008 11:45:25 javax.jcr.ItemNotFoundException caught while iterating on query results: failed to build path of 473a6b67-6de8-4317-8d6a-67c5720249d6: 31ed0c96-8cf9-486e-99a6-283e81f63b52 has no child entry for 473a6b67-6de8-4317-8d6a-67c5720249d6
ERROR info.magnolia.cms.core.search.QueryResultImpl QueryResultImpl.java(build:106) 24.09.2008 11:45:25 javax.jcr.ItemNotFoundException caught while iterating on query results: failed to build path of 39188755-fee7-4215-9d21-2cb0e09a4582: 31ed0c96-8cf9-486e-99a6-283e81f63b52 has no child entry for 39188755-fee7-4215-9d21-2cb0e09a4582
ERROR info.magnolia.cms.core.search.QueryResultImpl QueryResultImpl.java(build:106) 24.09.2008 11:45:25 javax.jcr.ItemNotFoundException caught while iterating on query results: failed to build path of 39188755-fee7-4215-9d21-2cb0e09a4582: 31ed0c96-8cf9-486e-99a6-283e81f63b52 has no child entry for 39188755-fee7-4215-9d21-2cb0e09a4582
ERROR info.magnolia.cms.core.search.QueryResultImpl QueryResultImpl.java(build:106) 24.09.2008 11:45:25 javax.jcr.ItemNotFoundException caught while iterating on query results: failed to build path of 39188755-fee7-4215-9d21-2cb0e09a4582: 31ed0c96-8cf9-486e-99a6-283e81f63b52 has no child entry for 39188755-fee7-4215-9d21-2cb0e09a4582
SQL String CombinedFeedAction: /jcr:root/rssaggregator/MagnoliaBlogs/data[1]// order by @pubDate ascending
ERROR info.magnolia.cms.core.search.QueryResultImpl QueryResultImpl.java(build:106) 24.09.2008 11:45:25 javax.jcr.ItemNotFoundException caught while iterating on query results: failed to build path of 39188755-fee7-4215-9d21-2cb0e09a4582: 31ed0c96-8cf9-486e-99a6-283e81f63b52 has no child entry for 39188755-fee7-4215-9d21-2cb0e09a4582
ERROR info.magnolia.cms.core.search.QueryResultImpl QueryResultImpl.java(build:106) 24.09.2008 11:45:25 javax.jcr.ItemNotFoundException caught while iterating on query results: failed to build path of 473a6b67-6de8-4317-8d6a-67c5720249d6: 31ed0c96-8cf9-486e-99a6-283e81f63b52 has no child entry for 473a6b67-6de8-4317-8d6a-67c5720249d6
ERROR info.magnolia.cms.core.search.QueryResultImpl QueryResultImpl.java(build:106) 24.09.2008 11:45:25 javax.jcr.ItemNotFoundException caught while iterating on query results: failed to build path of 39188755-fee7-4215-9d21-2cb0e09a4582: 31ed0c96-8cf9-486e-99a6-283e81f63b52 has no child entry for 39188755-fee7-4215-9d21-2cb0e09a4582
ERROR info.magnolia.cms.core.search.QueryResultImpl QueryResultImpl.java(build:106) 24.09.2008 11:45:25 javax.jcr.ItemNotFoundException caught while iterating on query results: failed to build path of 473a6b67-6de8-4317-8d6a-67c5720249d6: 31ed0c96-8cf9-486e-99a6-283e81f63b52 has no child entry for 473a6b67-6de8-4317-8d6a-67c5720249d6
ERROR info.magnolia.cms.core.search.QueryResultImpl QueryResultImpl.java(build:106) 24.09.2008 11:45:25 javax.jcr.ItemNotFoundException caught while iterating on query results: failed to build path of 39188755-fee7-4215-9d21-2cb0e09a4582: 31ed0c96-8cf9-486e-99a6-283e81f63b52 has no child entry for 39188755-fee7-4215-9d21-2cb0e09a4582
SQL String CombinedFeedAction: /jcr:root/rssaggregator/MagnoliaBlogs/data[1]// order by @pubDate ascending
ERROR info.magnolia.cms.core.search.QueryResultImpl QueryResultImpl.java(build:106) 24.09.2008 11:45:25 javax.jcr.ItemNotFoundException caught while iterating on query results: failed to build path of 39188755-fee7-4215-9d21-2cb0e09a4582: 31ed0c96-8cf9-486e-99a6-283e81f63b52 has no child entry for 39188755-fee7-4215-9d21-2cb0e09a4582
ERROR info.magnolia.cms.core.search.QueryResultImpl QueryResultImpl.java(build:106) 24.09.2008 11:45:25 javax.jcr.ItemNotFoundException caught while iterating on query results: failed to build path of 473a6b67-6de8-4317-8d6a-67c5720249d6: 31ed0c96-8cf9-486e-99a6-283e81f63b52 has no child entry for 473a6b67-6de8-4317-8d6a-67c5720249d6
ERROR info.magnolia.cms.core.search.QueryResultImpl QueryResultImpl.java(build:106) 24.09.2008 11:45:25 javax.jcr.ItemNotFoundException caught while iterating on query results: failed to build path of 39188755-fee7-4215-9d21-2cb0e09a4582: 31ed0c96-8cf9-486e-99a6-283e81f63b52 has no child entry for 39188755-fee7-4215-9d21-2cb0e09a4582
ERROR info.magnolia.cms.core.search.QueryResultImpl QueryResultImpl.java(build:106) 24.09.2008 11:45:25 javax.jcr.ItemNotFoundException caught while iterating on query results: failed to build path of 473a6b67-6de8-4317-8d6a-67c5720249d6: 31ed0c96-8cf9-486e-99a6-283e81f63b52 has no child entry for 473a6b67-6de8-4317-8d6a-67c5720249d6
ERROR info.magnolia.cms.core.search.QueryResultImpl QueryResultImpl.java(build:106) 24.09.2008 11:45:25 javax.jcr.ItemNotFoundException caught while iterating on query results: failed to build path of 39188755-fee7-4215-9d21-2cb0e09a4582: 31ed0c96-8cf9-486e-99a6-283e81f63b52 has no child entry for 39188755-fee7-4215-9d21-2cb0e09a4582
SQL String FeedListAction: /jcr:root/rssaggregator/MagnoliaBlogs/data/element(*, mgnl:content) order by @jcr:name
ERROR info.magnolia.cms.core.search.QueryResultImpl QueryResultImpl.java(build:106) 24.09.2008 11:45:25 javax.jcr.ItemNotFoundException caught while iterating on query results: failed to build path of 473a6b67-6de8-4317-8d6a-67c5720249d6: 31ed0c96-8cf9-486e-99a6-283e81f63b52 has no child entry for 473a6b67-6de8-4317-8d6a-67c5720249d6
ERROR info.magnolia.cms.core.search.QueryResultImpl QueryResultImpl.java(build:106) 24.09.2008 11:45:25 javax.jcr.ItemNotFoundException caught while iterating on query results: failed to build path of 39188755-fee7-4215-9d21-2cb0e09a4582: 31ed0c96-8cf9-486e-99a6-283e81f63b52 has no child entry for 39188755-fee7-4215-9d21-2cb0e09a4582
ERROR info.magnolia.cms.core.search.QueryResultImpl QueryResultImpl.java(build:106) 24.09.2008 11:45:25 javax.jcr.ItemNotFoundException caught while iterating on query results: failed to build path of 473a6b67-6de8-4317-8d6a-67c5720249d6: 31ed0c96-8cf9-486e-99a6-283e81f63b52 has no child entry for 473a6b67-6de8-4317-8d6a-67c5720249d6
ERROR info.magnolia.cms.core.search.QueryResultImpl QueryResultImpl.java(build:106) 24.09.2008 11:45:25 javax.jcr.ItemNotFoundException caught while iterating on query results: failed to build path of 473a6b67-6de8-4317-8d6a-67c5720249d6: 31ed0c96-8cf9-486e-99a6-283e81f63b52 has no child entry for 473a6b67-6de8-4317-8d6a-67c5720249d6
ERROR info.magnolia.cms.core.search.QueryResultImpl QueryResultImpl.java(build:106) 24.09.2008 11:45:25 javax.jcr.ItemNotFoundException caught while iterating on query results: failed to build path of 39188755-fee7-4215-9d21-2cb0e09a4582: 31ed0c96-8cf9-486e-99a6-283e81f63b52 has no child entry for 39188755-fee7-4215-9d21-2cb0e09a4582
ERROR info.magnolia.cms.core.search.QueryResultImpl QueryResultImpl.java(build:106) 24.09.2008 11:45:25 javax.jcr.ItemNotFoundException caught while iterating on query results: failed to build path of 39188755-fee7-4215-9d21-2cb0e09a4582: 31ed0c96-8cf9-486e-99a6-283e81f63b52 has no child entry for 39188755-fee7-4215-9d21-2cb0e09a4582
ERROR info.magnolia.cms.core.search.QueryResultImpl QueryResultImpl.java(build:106) 24.09.2008 11:45:25 javax.jcr.ItemNotFoundException caught while iterating on query results: failed to build path of 39188755-fee7-4215-9d21-2cb0e09a4582: 31ed0c96-8cf9-486e-99a6-283e81f63b52 has no child entry for 39188755-fee7-4215-9d21-2cb0e09a4582
SQL String FeedListAction: /jcr:root/rssaggregator/news/data/element(*, mgnl:content) order by @jcr:name
ERROR info.magnolia.cms.core.search.QueryResultImpl QueryResultImpl.java(build:106) 24.09.2008 11:45:25 javax.jcr.ItemNotFoundException caught while iterating on query results: failed to build path of d19f9713-10b2-4d08-8d5a-d3fa7feb6c07: baa2eb45-95c1-4903-a9b3-c517975a55a6 has no child entry for d19f9713-10b2-4d08-8d5a-d3fa7feb6c07
ERROR info.magnolia.cms.core.search.QueryResultImpl QueryResultImpl.java(build:106) 24.09.2008 11:45:26 javax.jcr.ItemNotFoundException caught while iterating on query results: failed to build path of d19f9713-10b2-4d08-8d5a-d3fa7feb6c07: baa2eb45-95c1-4903-a9b3-c517975a55a6 has no child entry for d19f9713-10b2-4d08-8d5a-d3fa7feb6c07



 Comments   
Comment by Jan Haderka [ 28/Oct/08 ]

The query produced by CombinedFeedAction looks like:

"/jcr:root"+this.paragraphNode.getNodeData("link").getString()+"/data[1]/*/* order by " + orderByNodeValue + " " + sortDirectionNodeValue

Notice the two stars in the query after data[1] part. This is missing in the query you provided in the issue. Not sure if this is a typo or real error. However I'm unable to reproduce the issue with existing code.
The underlying ItemNotFound might also been caused by corrupted repo. Please try to reproduce on clean repository, and if reproducible, reopen the issue and describe exactly how to reproduce the issue.

Generated at Mon Feb 12 07:04:31 CET 2024 using Jira 9.4.2#940002-sha1:46d1a51de284217efdcb32434eab47a99af2938b.