Expand my Community achievements bar.

July 31st AEM Gems Webinar: Elevate your AEM development to master the integration of private GitHub repositories within AEM Cloud Manager.
SOLVED

Exception executing report Acs commons report

Avatar

Level 2

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 

IMG_20240506_164052__01.jpg

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

IMG_20240506_164454.jpg

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 

1 Accepted Solution

Avatar

Correct answer by
Level 9

@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.

View solution in original post

5 Replies

Avatar

Correct answer by
Level 9

@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.

Avatar

Level 2

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

Avatar

Community Advisor

@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?

Avatar

Level 2

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

Avatar

Community Advisor

@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.