Hi Experts,
Our Log shows this error and we need to add Index to our repository for the same.
I am not sure though what the Index should be fo rofllowing query, Please help:
On Prod Author1 - Occurrence of Errors/Warnings: consider creating an index or changing the query.
Reason : Missing search index that causes large repository traversal causing performance issues due to high disk I/O.
Recommended Actions: Contact customizer to create required search index .
Example from logs :
11.05.2020 12:18:25.885 *WARN* [Thread-95] org.apache.jackrabbit.oak.plugins.index.Cursors$TraversingCursor Traversed 1000 nodes with filter Filter(query=select e.[jcr:path] as [jcr:path], e.[jcr:score] as [jcr:score], e.* from [nt:base] as a inner join [nt:base] as b on ischildnode(b, a) inner join [nt:base] as c on ischildnode(c, b) inner join [nt:base] as d on ischildnode(d, c) inner join [nt:base] as e on ischildnode(e, d) where name(a) = 'wcm' and isdescendantnode(a, '/home') and name(b) = 'notification' and name(c) = 'config' and name(d) = 'subscriptions' and e.[type] = 'page' option(traversal OK) /* xpath: /jcr:root/home//wcm/notification/config/subscriptions/* [@type='page'] option(traversal ok) */, path=/home//*, property=[:localname=[wcm]]); consider creating an index or changing the query
Solved! Go to Solution.
Views
Replies
Total Likes
Looks like a bug in ACS commons inbox feature. Workaround is
Stop the component in /system/console/components ->notification: com.day.cq.wcm.notification.impl.NotificationManagerImpl and to keep it stopped by using ACS-commons component disabler
https://adobe-consulting-services.github.io/acs-aem-commons/features/osgi-disablers/component-disabl...
Refer: https://github.com/Adobe-Consulting-Services/acs-aem-commons/issues/1635
Are you searching for a property called "wcm" ?
Looks like a bug in ACS commons inbox feature. Workaround is
Stop the component in /system/console/components ->notification: com.day.cq.wcm.notification.impl.NotificationManagerImpl and to keep it stopped by using ACS-commons component disabler
https://adobe-consulting-services.github.io/acs-aem-commons/features/osgi-disablers/component-disabl...
Refer: https://github.com/Adobe-Consulting-Services/acs-aem-commons/issues/1635
Views
Replies
Total Likes
This is still occurring and the accepted solution wasn't the root cause. Can anyone in AEM take a look at this issue? looks like the wcm core aem component is generating the query and can help fixing this issue.
I'm facing the same traversal problem. Do we have a solution for this issue ?
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies