SNow report not loading, showing error - "Widget cancelled - maximum execution time exceeded"
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-09-2024 10:05 AM
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.
plz provide solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-10-2024 12:14 AM - edited 10-10-2024 12:16 AM
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?