AEM 6.4 DAM asset timeline is erroring out | Community
Skip to main content
February 11, 2020
Solved

AEM 6.4 DAM asset timeline is erroring out

  • February 11, 2020
  • 1 reply
  • 2169 views

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

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by user05162

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

1 reply

user05162Adobe EmployeeAccepted solution
Adobe Employee
February 12, 2020

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

Level 2
December 23, 2021

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

 

Thanks