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

DAM asset expiry notification JOB || Query optimisation

Guptasuresh2004
Level 2
Level 2

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

1 Accepted Solution
Guptasuresh2004
Correct answer by
Level 2
Level 2

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']

1467493_pastedImage_0.png

View solution in original post

1 Reply
Guptasuresh2004
Correct answer by
Level 2
Level 2

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']

1467493_pastedImage_0.png

View solution in original post