Darren Rose Posted July 21, 2021 Share Posted July 21, 2021 Hello when running any reports in Service Manager today, if a report takes longer than 10 seconds to run then the report is blank. The file size is c.200bytes and only includes the column headers. If you filter the report to a much smaller result and it runs less than 10 seconds, then the reports exports as expected Any ideas? Darren Link to comment Share on other sites More sharing options...
Guest Paul Alexander Posted July 22, 2021 Share Posted July 22, 2021 I think this is due to the 10 second timeout we have on our instance which was reported in this post: Link to comment Share on other sites More sharing options...
Guest Paul Alexander Posted July 22, 2021 Share Posted July 22, 2021 BTW My response wasn't meant as an answer...I was giving people more info which I thought might help with a resolution. The problem still stands - reports aren't bringing back any information if the query runs for more than 10 seconds.... Link to comment Share on other sites More sharing options...
Darren Rose Posted July 22, 2021 Author Share Posted July 22, 2021 Any ideas @AlexTumber @Daniel Dekel? Link to comment Share on other sites More sharing options...
Deen Posted July 26, 2021 Share Posted July 26, 2021 @Darren Rose I take it we are talking about widgets here rather than actual reports? We have looked at some of the heavier ones and the largest contains the following in the query: h_itsm_requests.h_datelogged >= '2019-04-30 00:00:00' Is there a need for the query to bring back requests from early 2019? If this can be reduced to a weekly or monthly value that should significantly reduce the query time. Also looking at the query two of the fields h_fk_servicename and h_catalog don't have indexes, you could swap them with h_fk_serviceid and h_catalog_id as that should also help to speed up the query and get it under the current threshold. Link to comment Share on other sites More sharing options...
Darren Rose Posted July 27, 2021 Author Share Posted July 27, 2021 Hi @Deen No this is in the reports under admin>Service Manager> reports Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now