Exception executing report Acs commons report

[Nimma05]

Hi,

I am trying to fetch pages list using SQL2 query with some conditions while executing report I am facing this error. Exception executing report: org.apache.sling.api.request.Toomanycallsexception

And it shows the results 

 I have checked the Apache sling main servelt config also it is already 5500.

Can someone help me how to overcome this issue

Or is it fine to continue as it is generating result s will there be any difference in page list without error 

[Kamal_Kishor · Accepted solution]

@Nimma05 : This happens when there are too many calls being triggered due to some action. You can review and see what could be causing too many calls as it is not ideal to have many calls.
To by-pass this error, you can do this temporarily.

1. Login to AEM instance with admin user.
2. Go to http://localhost:402/system/console/configMgr
3. Update Apache Sling main Servlet configuration : Number of request per calls to a higher value and then try generating your reports.

Please refer this: https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/aem-6-5-toomanycallsexcept...
https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/aem-6-2-too-many-calls-sli...

thanks.

[Nimma05]

HI @Kamal_Kishor ,

I dont see anything in error.log when I search for "TooManyCallsException" to know what is causing the issue.How to know the specific reason? And Number of request per calls is currently 5500 so, I have changed to 12000 but still I am getting this error.

This is the query I am executing: 

SELECT * FROM [cq:PageContent] AS s WHERE ISDESCENDANTNODE(s, '{{path}}') AND (s.[cq:lastModified] < CAST("2018-01-01T00:00:00.000Z" AS DATE) OR s.[cq:lastReplicationAction] = "Deactivate" )

And the results I am getting is aroung 5k

[Harwinder-singh]

@Nimma05 , You should still be able DOWNLOAD the report. Execute report action has a few extra steps that create a performance overhead most of the time.

Can you try that and let us know?

[Nimma05]

Hi, yes I am able to download the report. But concern is about the error. Is that fine is it still shows the error.

And I have increased the number of request for cal to 30000 but not sure if it's a feasible number to do. When changed to 30k it is not showing error.

With and without the error result number same. Just trying to knwo why the error is showing if its below 30k which is huge number

[Harwinder-singh]

@Nimma05 Yes, as long as you are able to download the report it should be ok.

The execute report action is not optimized for a large result set and hence leads to the mentioned error more often than not.