Editting a content fragment model fails on 100000 node traversal

[BobNoelle]

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?

[nitesh_kumar · Accepted solution]

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

[BobNoelle]

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.

[Magicr]

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

[Kavin742]

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

[Magicr]

I don't know. Though there exists a good chance because later service packs contains the fixes from previous ones.

[Kavin742]

Hi, our current version is 6.5.14 and we used the latest package cfm-graphql-index-def-1.1.1.zip.It is working SP14 that we tested. Not yet tested this in SP16.