Editting a content fragment model fails on 100000 node traversal | Community
Skip to main content
Level 2
March 6, 2023
Solved

Editting a content fragment model fails on 100000 node traversal

  • March 6, 2023
  • 1 reply
  • 2178 views

More specifically, when attempting to edit a content fragment model the process fails:

The query read or traversed more than 100000 nodes. To avoid affecting other tasks, processing was stopped.

 

After some investigation is looks like this query may be the culprit:

select [jcr:path], [jcr:score], * from [dam:Asset] as a where [jcr:content/contentFragment] = 'true' and 
[jcr:content/data/cq:model] = '/conf/we-retail/settings/dam/cfm/models/test' and
isdescendantnode(a, '/content/dam') option(index tag [fragments])
/* xpath: /jcr:root/content/dam//element(*, dam:Asset)[(jcr:content/@contentFragment = 'true' and
jcr:content/data/@cq:model = '/conf/we-retail/settings/dam/cfm/models/test')] option (index tag fragments) */

 On my server /content/dam is quite large.  Assuming this reference is indeed the problem, is it possible to change it?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by nitesh_kumar-1

Hi @bobnoelle ,

 

Are you facing this issue with AEM6.5 or AEM Cloud? Also, mention the service pack installed.

 

This looks like a known issue and the fix was provided with SP12, check here:-

https://experienceleague.adobe.com/docs/experience-manager-65/release-notes/service-pack/6.5.12.html?lang=en#known-issues 

 

Try to install the package related to the index as mentioned in the section

https://experience.adobe.com/#/downloads/content/software-distribution/en/aem.html?package=%2Fcontent%2Fsoftware-distribution%2Fen%2Fdetails.html%2Fcontent%2Fdam%2Faem%2Fpublic%2Fadobe%2Fpackages%2Fcq650%2Ffeaturepack%2Fcfm-graphql-index-def-1.0.3.zip 

 

Hope that helps!

 

Regards,

Nitesh

1 reply

nitesh_kumar-1
Adobe Employee
nitesh_kumar-1Adobe EmployeeAccepted solution
Adobe Employee
March 6, 2023

Hi @bobnoelle ,

 

Are you facing this issue with AEM6.5 or AEM Cloud? Also, mention the service pack installed.

 

This looks like a known issue and the fix was provided with SP12, check here:-

https://experienceleague.adobe.com/docs/experience-manager-65/release-notes/service-pack/6.5.12.html?lang=en#known-issues 

 

Try to install the package related to the index as mentioned in the section

https://experience.adobe.com/#/downloads/content/software-distribution/en/aem.html?package=%2Fcontent%2Fsoftware-distribution%2Fen%2Fdetails.html%2Fcontent%2Fdam%2Faem%2Fpublic%2Fadobe%2Fpackages%2Fcq650%2Ffeaturepack%2Fcfm-graphql-index-def-1.0.3.zip 

 

Hope that helps!

 

Regards,

Nitesh

Magicr
Level 6
March 7, 2023

When will the issue fixed? The latest Servicepack is 16 and it seems the issue does still exists.

Level 2
June 23, 2023

Hi @magicr , Does installing the fix mentioned above still works for SP16 or SP14 ?