1 Reply Latest reply on Apr 17, 2018 4:29 AM by Guptasuresh2004

    DAM asset expiry notification JOB || Query optimisation

    Guptasuresh2004 Level 1

      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