Level 2

Solved

Exception executing report Acs commons report

Forum|Forum|1 year ago
May 6, 2024
2 replies
1221 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by Kamal_Kishor

@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-toomanycallsexception-when-navigation-through-sites-with/m-p/427952
https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/aem-6-2-too-many-calls-sling-exception/m-p/224517

thanks.

Kamal_Kishor

Accepted solution

Community Advisor

@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-toomanycallsexception-when-navigation-through-sites-with/m-p/427952
https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/aem-6-2-too-many-calls-sling-exception/m-p/224517

thanks.

N

Nimma05Author

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

Harwinder-singh

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?

N

Nimma05Author

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

Harwinder-singh

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.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded