reports from queries time out on dashboards
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-04-2022 06:28 AM
Hello,
We typically make a query to find our data, then make reports from the queries. However we have seen that the reports reference "QueryBuilderReports().getQueryLatestExecutionId" and that this reference "times out" after about 24 hours, which results in a blank pane on dashboards, until the developer goes and runs the query again which seems to refresh the instance. To work around this, we use "scheduled reports", which seems to force ServiceNow to maintain the same instance ID and fixes the problem, however now we see that the pane will show correctly on the dash, but that if a user clicks the pane to drill-down, they get the standard ACL failure as though they don't have permissions to the report. We also noticed that if the user then goes to the query and runs it AND clicks "load all results", then the drill down from the dashboard is fixed for a day, until SNOW seems to refresh the instance ID's. Sorry for the long post. Has anyone seen this?
