Expand my Community achievements bar.

SOLVED

Help needed on Index Query

Avatar

Level 2

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

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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

View solution in original post

5 Replies

Avatar

Community Advisor

Are you searching for a property called "wcm" ? 

Avatar

Correct answer by
Community Advisor

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

Avatar

Level 2
Hi Sashi, Thank you for the reply, When i try to stop that component i get this error: The request failed: HTTP ERROR: 404 Problem accessing /system/console/components/2780. Reason: Not Found

Avatar

Level 1

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.

Avatar

Level 1

I'm facing the same traversal problem. Do we have a solution for this issue ?