Auto running online datastore consistency check on a weekly basis and share missing blobs report to mail.

[MohanasundaramMo]

We have request to execute online datastore consistency check on a weekly basis in server using AEM feature. And also need to share the missing blobs report to users mail. Please share if any input.

[TarunKumar · Accepted solution]

Hi @MohanasundaramMo ,

You can try to implement a custom datastore consistency check class which will be executed by a scheduler and will run on specific cron expression provided to it.
You can have a look at below link which will give you some idea as what the logic would look like:

https://gist.github.com/andrewmkhoury/3a3b5e69900f4e873743


Thanks
Tarun

[MohanasundaramMo]

Hi TarunKumar,

Thanks for sharing input.

Do we have any method to invoke system/console/jmx service instead of crx/de ?

[MohanasundaramMo]

curl -u admin:admin -X POST http://localhost:4504/system/console/jmx/org.apache.jackrabbit.oak^%^3Aname^%^3DSegment+node+store+b...

This command help to get missing blobs.

[narendragandhi]

Hi @MohanasundaramMo 

As you mentioned online datastore consistency check, I think you are trying to invoke it from here - https://experienceleague.adobe.com/docs/experience-manager-65/content/implementing/deploying/configu...

You need to invoke programmatically the JMX Mbean listed in the above document. Here is one example of how you could do this using shell script - https://www.baeldung.com/jmx-mbean-shell-access

In the same script you can add code to send email to configured email address with the response you get from consistency check invocation.

I hope this helps. Please let us know for any questions.

Thanks

Narendra

[MohanasundaramMo]

Hi narendragandhi,

Thanks for our input.

Let me try your suggestion and get back to you.

[kautuk_sahni]

@MohanasundaramMo Did you find the suggestions from users helpful? Please let us know if more information is required. Otherwise, please mark the answer as correct for posterity. If you have found out solution yourself, please share it with the community.

[MohanasundaramMo]

curl -u admin:admin -X POST http://localhost:4504/system/console/jmx/org.apache.jackrabbit.oak^%^3Aname^%^3DSegment+node+store+b...

This command we can use to execute using script.