Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Adobe Summit 2023 [19th to 23rd March, Las Vegas and Virtual] | Complete AEM Session & Lab list
SOLVED

Editting a content fragment model fails on 100000 node traversal

Avatar

Level 2

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?

1 Accepted Solution

Avatar

Correct answer by
Employee

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... 

 

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=%2Fconten... 

 

Hope that helps!

 

Regards,

Nitesh

View solution in original post

3 Replies

Avatar

Correct answer by
Employee

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... 

 

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=%2Fconten... 

 

Hope that helps!

 

Regards,

Nitesh

Avatar

Level 2

I'm currently at aem-service-pkg-6.5.12.0.zip and I'm working on AEM6.5.  I apologize for being scant on the details of my environment, but you guessed correctly.  I tried installing service pack 6.14 but the issue was still present, however installing cfm-graphql-index-def-1.0.3.zip resolved the problem.  Many thanks.

 

Avatar

Level 7

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