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

SOLVED

AEM 6.4 DAM asset timeline is erroring out

Avatar

Level 1

Hello,

 

While accessing the timeline for a DAM asset it is erroring out after a while and I see the below Index-traversed issue and if you see it is using the cqPayloadPath index and can you please let me know how to go about this. Thanks for your time.

11.02.2020 00:43:57.147 *WARN* [10.43.32.30 [1581381786872] GET /mnt/overlay/dam/gui/content/assetdetails/jcr:content/rails/timeline/items/timeline.html HTTP/1.1] org.apache.jackrabbit.oak.plugins.index.property.strategy.ContentMirrorStoreStrategy Index-Traversed 350000 nodes (1070640 index entries) using index cqPayloadPath with filter Filter(query=SELECT * FROM [cq:Payload] AS payload WHERE (payload.path = '/content/dam/tenant/photos/studio/by-year/2017/hh17/hw.psd' OR payload.path = '/content/dam/tenant/photos/studio/by-year/2017/hh17/hw.psd/jcr:content' OR payload.path LIKE '/content/dam/tenant/photos/studio/by-year/2017/hh17/hw.psd/jcr:content/%' OR payload.path LIKE '/etc/workflow/packages/%' OR payload.path LIKE '/var/workflow/packages/%'), path=*, property=[path=[is not null]])

 

Thanks,

Sudheer

 

1 Accepted Solution

Avatar

Correct answer by
Employee Advisor

This is logged as a Bug internally as other customers have faced the same issue. GRANITE-28723 is the internal bug ID. 

 

You can use the following workarounds till the issue is officially fixed:

 

- Run workflow purge more often to reduce the number of nodes.

 

- Increase the Query limit to let the query complete. Default query limit is 100000. So, a query that traverses more than 100000 nodes will be stopped by AEM

View solution in original post

0 Replies

Avatar

Correct answer by
Employee Advisor

This is logged as a Bug internally as other customers have faced the same issue. GRANITE-28723 is the internal bug ID. 

 

You can use the following workarounds till the issue is officially fixed:

 

- Run workflow purge more often to reduce the number of nodes.

 

- Increase the Query limit to let the query complete. Default query limit is 100000. So, a query that traverses more than 100000 nodes will be stopped by AEM

Avatar

Level 2

We are facing the same issue in AEM 6.5.9. Do you have any info if GRANITE-28723 was resolved?

 

Thanks