SNow report not loading, showing error - "Widget cancelled - maximum execution time exceeded"

PRADEEPREDDY GU
Tera Expert

Hi developers,

 

can anyone help me on this 

ServiceNow report not loading. The error received is - "Widget cancelled - maximum execution time exceeded"

Our team (SG team) uses a ServiceNow report to keep track of our queue of requests. Team members are spread across Europe, India, and the United States. All team members are facing the same issue with the SNow report getting the "Widget cancelled - maximum execution time exceeded" when trying to refresh the report.

Please see the attached image.

PRADEEPREDDYGU_0-1728493528692.png

plz provide solution.

 

5 REPLIES 5

JC Moller
Giga Sage

This is probably caused by the report itself. What type of report is it. Are the columns you are searching indexed? Are you grouping on a non-indexed column? 

Open report_stats_list.do table and validate the performance of the widget's report itself. How long does it take to run in avg (recent avg execution duration column).

Based on this I would not recommend to alter any system wide quota rules. Widget reports should run in seconds, if it runs significantly longer, the you need to fix the report first.

Slow queries table's data and index suggestion engine could also come in handy to help you resolve the issue. Maybe this requires a new index to be added?