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

AEM 6.5.10 : Asset Expiry Notification Job : Only 10 images are in email

Avatar

Level 2

Hi Everyone - In AEM 6.5.10, we have configured Asset Expiry Notification job. In the email which we are receiving, there are only 10 image paths even though, for testing, we have configured 15 images to expire. We have tested this scenario multiple times and each time images included in the email vary ( although total images do not exceed 10). I want to understand if there is any specific configuration which we missing to include more than 10 images?

 

2 Replies

Avatar

Level 10

Hi @mayanks21529814 ,
I did test and see it is working as expected. I verified in AEM 6.5.0. Try to create a new folder, upload 15 new images, and then expire them all and test.

Do not try using the old assets which are already present in your dam. The documentation says, the author who is uploading the image will get the email notification. Attached screenshot for reference.

https://experienceleague.adobe.com/docs/experience-manager-cloud-service/content/assets/manage/drm.h...

Screen Shot 2022-01-31 at 2.35.26 PM.pngScreen Shot 2022-01-31 at 2.40.55 PM.png

Avatar

Level 2

Hi Anish - Thank You for checking. Asset Expiry workflow sends 2 notifications, 1 is for assets which are going to get expired and second when assets expire. Email which you got was for assets which have expired. May be i was not very clear in my question, i am noticing issue for #1 which is notification for assets which are going to expire

Avatar

Level 3

Hey @mayanks21529814 

can you make the changes in Asset expiry Notification job as below 

mynitumail_0-1643666990462.png

It seems that "Asset expiry limit" value is not configured correctly which is causing the issue. 

 

 

Avatar

Level 2

i have made it as large as "10000000" and as low as "20" but still i don't seem to get more than 10 asset paths in email.

Avatar

Level 3

 

@mayanks21529814  setup the debug level logs at below path[0] and see what value you are getting for limit variable, it looks "asset expiry limit" variable value is not setting up as expected in your instance. 

 

[0]

cq.dam.expiry.notification.scheduler
com.day.cq.dam.core.impl.ExpiryNotificationJobImpl

com.day.cq.search.impl.builder.QueryImpl

 

mynitumail_0-1643687713586.png

 

 

 

daterange.property=jcr%3acontent%2fmetadata%2fprism%3aexpirationDate&daterange.upperBound=1643667288692&orderby=%40jcr%3acontent%2fmetadata%2fprism%3aexpirationDate&orderby.sort=DESC&p.guessTotal=true&p.limit=10000&path=%2fcontent%2fdam&property=jcr%3acontent%2fcq%3alastReplicationAction&property.value=Activate&type=dam%3aAsset
31.01.2022 17:14:48.692 *DEBUG* [sling-default-4-com.day.cq.dam.core.impl.ExpiryNotificationJobImpl] com.day.cq.search.impl.builder.QueryImpl executing query (predicate tree):
ROOT=group: limit=15, guessTotal=true[
    {daterange=daterange: property=jcr:content/metadata/prism:expirationDate, upperBound=1643667288692}
    {orderby=orderby: orderby=@jcr:content/metadata/prism:expirationDate, sort=DESC}
    {path=path: path=/content/dam}
    {property=property: property=jcr:content/cq:lastReplicationAction, value=Activate}
    {type=type: type=dam:Asset}
]

 

if you are not getting configured value correctly in the query, you should disable/enable the component in configuration and check if it works. 

Avatar

Level 2

Hi - Thank you for your suggesstion. I added debug log for classes you mentioned. I can see correct value coming in logs but that value has no significance (it seems) to number of records coming in email. Even if i set value as 5 and there are total 12 assets expiring i get an email with 10 assets. Here is the log details:

01.02.2022 10:35:06.965 *DEBUG* [sling-default-2-com.day.cq.dam.core.impl.ExpiryNotificationJobImpl] com.day.cq.search.impl.builder.QueryImpl executing query (URL):
daterange.property=jcr%3acontent%2fmetadata%2fprism%3aexpirationDate&daterange.upperBound=1643740506965&orderby=%40jcr%3acontent%2fmetadata%2fprism%3aexpirationDate&orderby.sort=DESC&p.guessTotal=true&p.limit=5&path=%2fcontent%2fdam&property=jcr%3acontent%2fcq%3alastReplicationAction&property.value=Activate&type=dam%3aAsset
01.02.2022 10:35:06.965 *DEBUG* [sling-default-2-com.day.cq.dam.core.impl.ExpiryNotificationJobImpl] com.day.cq.search.impl.builder.QueryImpl executing query (predicate tree):
ROOT=group: limit=5, guessTotal=true[
    {daterange=daterange: property=jcr:content/metadata/prism:expirationDate, upperBound=1643740506965}
    {orderby=orderby: orderby=@jcr:content/metadata/prism:expirationDate, sort=DESC}
    {path=path: path=/content/dam}
    {property=property: property=jcr:content/cq:lastReplicationAction, value=Activate}
    {type=type: type=dam:Asset}
]
01.02.2022 10:35:06.966 *DEBUG* [sling-default-2-com.day.cq.dam.core.impl.ExpiryNotificationJobImpl] com.day.cq.search.impl.builder.QueryImpl xpath query: /jcr:root/content/dam//element(*, dam:Asset)[((jcr:content/metadata/@prism:expirationDate < xs:dateTime('2022-02-01T18:35:06.965Z')) and jcr:content/@cq:lastReplicationAction = 'Activate')] order by jcr:content/metadata/@prism:expirationDate descending
01.02.2022 10:35:06.968 *DEBUG* [sling-default-2-com.day.cq.dam.core.impl.ExpiryNotificationJobImpl] com.day.cq.search.impl.builder.QueryImpl xpath query creation took 2 ms
01.02.2022 10:35:06.968 *DEBUG* [sling-default-2-com.day.cq.dam.core.impl.ExpiryNotificationJobImpl] com.day.cq.search.impl.builder.QueryImpl >> xpath query result not counted because of 'p.guessTotal'
01.02.2022 10:35:06.969 *DEBUG* [sling-default-2-com.day.cq.dam.core.impl.ExpiryNotificationJobImpl] com.day.cq.search.impl.builder.QueryImpl entire query execution took 4 ms
01.02.2022 10:35:06.969 *DEBUG* [sling-default-2-com.day.cq.dam.core.impl.ExpiryNotificationJobImpl] com.day.cq.search.impl.builder.QueryImpl executing query (URL):
1_daterange.lowerBound=1643788800000&1_daterange.property=jcr%3acontent%2fmetadata%2fprism%3aexpirationDate&1_daterange.upperBound=1643826906965&path=%2fcontent%2fdam&type=dam%3aAsset
01.02.2022 10:35:06.969 *DEBUG* [sling-default-2-com.day.cq.dam.core.impl.ExpiryNotificationJobImpl] com.day.cq.search.impl.builder.QueryImpl executing query (predicate tree):
ROOT=group: [
    {path=path: path=/content/dam}
    {type=type: type=dam:Asset}
    {1_daterange=daterange: property=jcr:content/metadata/prism:expirationDate, lowerBound=1643788800000, upperBound=1643826906965}
]
01.02.2022 10:35:06.970 *DEBUG* [sling-default-2-com.day.cq.dam.core.impl.ExpiryNotificationJobImpl] com.day.cq.search.impl.builder.QueryImpl xpath query: /jcr:root/content/dam//element(*, dam:Asset)[((jcr:content/metadata/@prism:expirationDate > xs:dateTime('2022-02-02T08:00:00.000Z') and jcr:content/metadata/@prism:expirationDate < xs:dateTime('2022-02-02T18:35:06.965Z')))]
01.02.2022 10:35:06.970 *DEBUG* [sling-default-2-com.day.cq.dam.core.impl.ExpiryNotificationJobImpl] com.day.cq.search.impl.builder.QueryImpl xpath query creation took 0 ms
01.02.2022 10:35:06.975 *DEBUG* [sling-default-2-com.day.cq.dam.core.impl.ExpiryNotificationJobImpl] com.day.cq.search.impl.builder.QueryImpl >> xpath query returned 12 results (getSize)
01.02.2022 10:35:06.978 *DEBUG* [sling-default-2-com.day.cq.dam.core.impl.ExpiryNotificationJobImpl] com.day.cq.search.impl.builder.QueryImpl entire query execution took 9 ms
01.02.2022 10:35:06.978 *DEBUG* [sling-default-2-com.day.cq.dam.core.impl.ExpiryNotificationJobImpl] com.day.cq.search.impl.builder.QueryImpl executing query (URL):

Avatar

Level 3

@mayanks21529814  Did you get a chance to disable/enable the ExpiryNotificationJobImpl component?

Install AEM vanilla instance in your local and see if you can reproduce the issue and share the steps please to reproduce the issue.  and if you are able to reproduce the issue in aem vanilla instance you shoud raise a day care ticket to Adobe.