Getting "TooManyCallsException" in ACS commons report

[sagartiwari]

I have requirement to get the list of users who are not logged in last 90 days. I have created ACS commons report and getting the list of users using query. When I am selecting "All Result" option from report page, I am getting "TooManyCallsException" exception. Please find below image for exception

[digarg]

You may need to optimize and refine your query , and create oak:index if required (check logs). You can limit the search in paths , define some conditions etc. What is the query that you are using ?

[Jörg_Hoh · Accepted solution]

Please check https://cqdump.joerghoh.de/2022/01/05/how-to-deal-with-the-toomanycallsexception/

(also please fill a ticket on ACS AEM Commons, if not already present. The design of that feature should be changed, so it does not run into this problem.)