Move page functionality is not working
Explore how to address the malfunctioning of the move page feature that hinders actions like deletion or publication due to content fragment reference retrieval issues.
Description description
Environment
Experience Manager 6.5.x Managed Services (AMS)
Issue/Symptoms
When trying to move, delete, or publish either Content Fragments, Sites, or Pages, an issue occurs when Content Fragment references are fetched, preventing the action.
08.12.2023 14:10:42.934 *WARN* [ 130.248.72.6 [ 1702044580039] GET /bin/wcm/heavymove HTTP/1.1] org.apache.jackrabbit.oak.plugins.index.Cursors$TraversingCursor Traversed 100000 nodes with filter Filter(query=select [ jcr:path] , [ jcr:score] , * from [ dam:Asset] as a where [ jcr:content/contentFragment] = 'true' and contains(*, '/content/example-website/language-masters/en/adobe-support-move-test') and isdescendantnode(a, '/content/dam') order by [ jcr:created] desc option(index tag [ visualSimilaritySearch] ) /* xpath: /jcr:root/content/dam//element(*, dam:Asset)[ (jcr:content/@contentFragment = 'true' and jcr:contains(., '/content/example-website/language-masters/en/adobe-support-move-test'))] order by @jcr:created descending option (index tag visualSimilaritySearch) */ fullText="/content/example-website/language-masters/en/adobe-support-move-test", path=/content/dam//*, property=[ :indexTag=[ visualSimilaritySearch] , jcr:content/contentFragment=[ true] ] ); consider creating an index or changing the query
08.12.2023 14:10:43.023 *WARN* [ 130.248.72.6 [ 1702044580039] GET /bin/wcm/heavymove HTTP/1.1] org.apache.jackrabbit.oak.query.FilterIterators The query read or traversed more than 100000 nodes.
org.apache.jackrabbit.oak.query.RuntimeNodeTraversalException: The query read or traversed more than 100000 nodes. To avoid affecting other tasks, processing was stopped.
at org.apache.jackrabbit.oak.query.FilterIterators.checkReadLimit(FilterIterators.java:70) [ org.apache.jackrabbit.oak-core:1.22.16]
at org.apache.jackrabbit.oak.plugins.index.Cursors$TraversingCursor.fetchNext(Cursors.java:341) [ org.apache.jackrabbit.oak-core:1.22.16]
at org.apache.jackrabbit.oak.plugins.index.Cursors$TraversingCursor.next(Cursors.java:320) [ org.apache.jackrabbit.oak-core:1.22.16]
at org.apache.jackrabbit.oak.query.ast.SelectorImpl.nextInternal(SelectorImpl.java:520) [ org.apache.jackrabbit.oak-core:1.22.16]
at org.apache.jackrabbit.oak.query.ast.SelectorImpl.next(SelectorImpl.java:508) [ org.apache.jackrabbit.oak-core:1.22.16]
at org.apache.jackrabbit.oak.query.QueryImpl$RowIterator.fetchNext(QueryImpl.java:876) [ org.apache.jackrabbit.oak-core:1.22.16]
at org.apache.jackrabbit.oak.query.QueryImpl$RowIterator.hasNext(QueryImpl.java:903) [ org.apache.jackrabbit.oak-core:1.22.16]
at org.apache.jackrabbit.oak.query.FilterIterators$SortIterator.init(FilterIterators.java:207) [ org.apache.jackrabbit.oak-core:1.22.16]
at org.apache.jackrabbit.oak.query.FilterIterators$SortIterator.hasNext(FilterIterators.java:241) [ org.apache.jackrabbit.oak-core:1.22.16]
at org.apache.jackrabbit.oak.query.QueryImpl.getRows(QueryImpl.java:574) [ org.apache.jackrabbit.oak-core:1.22.16]
at org.apache.jackrabbit.oak.query.ResultImpl$1.iterator(ResultImpl.java:72) [ org.apache.jackrabbit.oak-core:1.22.16]
at org.apache.jackrabbit.oak.jcr.query.QueryResultImpl$1.
Resolution resolution
To replicate the issue, apply the fix first on a lower environment. Please note that you may need to sync the production content to the lower environments to reproduce the issue. If you are an AMS customer, ask your CSE to copy the content from the production to a lower environment.
You may have to perform a reindex once you apply the fix on a lower environment.
recommendation-more-help
experience-cloud-kcs-help-kbarticles