Content Fragment Model is not working for AEM 6.4

[prince233]

Hi Team

we recently migrated from 6.2 to 6.4 . Content Fragment Model is not working in the Production Environment. but It's working fine on lower Environments (Dev & UAT)

I'm seeing below Error. in this path /libs/granite/configurations/content/view.html/conf

[Umesh_Sondhi]

hi,

You can get some idea from this thread Not Showing Content Fragment Models in AEM 6.4

thanks

[Jaideep_Brar]

Try to change the limit reads to a higher number from [1] till you stop getting the warning

[1] http://<host>:<port>/system/console/jmx/org.apache.jackrabbit.oak%3Aname%3Dsettings%2Ctype%3DQueryEn...

[Jaideep_Brar · Accepted solution]

This is a known issue and fixed in AEM 6.5

For now, you can overlay "/libs/dam/cfm/models/console/components/models/datasources/childdatasource/childdatasource.jsp"

Change line 159 from

String sql = "SELECT * FROM [cq:Page] AS p WHERE p.[jcr:path] LIKE '"+pathExpression+"' ORDER BY [jcr:path]";

To

String sql = "SELECT * FROM [cq:Page] AS p WHERE ISDESCENDANTNODE(p,'/conf') AND p.[jcr:path] LIKE '"+pathExpression+"' ORDER BY [jcr:path]";

Also, increase the limit reads to a higher number from [1] till you stop getting the warning

[1] http://<host>:<port>/system/console/jmx/org.apache.jackrabbit.oak%3Aname%3Dsettings%2Ctype %3DQueryEngineSettings