DAM asset expiry notification JOB || Query optimisation

[Guptasuresh2004]

Hi Experts,

In my AEM DAM when "asset expiry notification" Job run. it throws below exception every time.

================================================================

The query read or traversed more than 100000 nodes. To avoid affecting other tasks, processing was stopped

===================================================================

I checked:

1) OAK indexes are already in place for the Query

2) I also checked that number of dam: asset nodes are not more than 25000

Thanks,

Suresh

[Guptasuresh2004 · Accepted solution]

I figured below internal QUERY is the Culprit.

/jcr:root/content/dam/company//*[jcr:content/related/links/sling:members/*/@dam:resolvedPath='/content/dam/company/brand/global/product_shot/jeans/jeans_skinny_grey.jpg']