Need help with hanging reports

I'd be curious if you put your 5 queries in a modern dashboard (each as a separate resource) do you get the same issue? If so it may indicate an issue with the backend of SWIS/SWQL queries in some odd limitations. If not its likely just something in the report engine, unfortunately long request times are hard to track down if its actual performance or not. If the modern dashboard loads fine you could try to up timeouts on your reports to see if that affects it. 

Jeremy, great question!  I just checked and there are no issues with the modern dashboards that I've built. I have MD with 12 different queries that opens nice and quick with no issues.

Yes this one is a bugger!!

Here's what I have for Report timeouts.

For SWNetPerfMon.db it's the default 90:

! Database Command timeout in seconds

CommandTimeout=90

and web.config is default exec time off 600 for everything except the schedule which is 300

<location path="Orion/ReportWait.aspx">
<system.web>
<httpRuntime maxRequestLength="16096" executionTimeout="600" />
</system.web>

<location path="Orion/Report.aspx">
<system.web>
<httpRuntime maxRequestLength="16096" executionTimeout="600" />
</system.web>

<location path="Orion/Reports/AsExcel.aspx">
<system.web>
<httpRuntime maxRequestLength="64384" executionTimeout="600" />
</system.web>

<location path="Orion/Reports/Preview.aspx">
<system.web>
<httpRuntime maxRequestLength="16096" executionTimeout="600" />
</system.web>

<location path="Orion/Reports/Scheduler.aspx">
<system.web>
<httpRuntime maxRequestLength="16096" executionTimeout="300" />
</system.web>

You could try to up them again, the article they have for this has you set those values to 3600, outside of that I'm not on 2023 to be able to see if I can repro it. I'd keep pushing in support to see if you can get to one of the good techs. 

support.solarwinds.com/.../Large-report-error-Unexpected-Website-Error-Request-timed-out

Coffee is still kicking in just had a workaround idea. If these queries load fine for a modern dashboard can you just set your report to run using the URL for that dashboard? 

I'm sorry I don't quite understand what your suggesting.  Are you suggesting rebuilding the reports as modern dashboards? If so, that would be decent work around option however most users like to have their reports ran on a scheduled bases and mailed.  Also it doesn't appears there's a PDF or Excel export function in MD yet.

No I'm suggesting you sent the Dashboard as a scheduled report.

support.solarwinds.com/.../Send-an-Orion-Web-page-as-a-scheduled-report

bourlis Would you be willing to export the report and dump it here. Maybe we can pull it into a completely different system and test it there too. I just rebuilt my dev environment this morning, running 2023.1, and could test it here to see if I get the same thing.

Ok this is just odd!  First off thank you that's a good work around option and might actually shed some light on the issue. 

I just ran my test report with 6 queries and to be expected it hung.  I closed it down after waiting 5 or so minutes.  

I then added the report to a scheduled report and then hit the run now option it was successful.  It emailed me the web page with all 6 queries.

So with this bit of information, what would you all suggest next?  I'm thinking of upping the report timeout sections in web.config folder.

I created a new report and added a custom query to it, then duplicated it until I had 5 of them. The report seems to load just fine for me, but the query is about as simple and calm as could be, so maybe it's just not using enough juice to encounter the issue.

SELECT TOP 1 n.Caption FROM Orion.Nodes AS n

yeah I would up the timeouts, I would also make sure to space it apart from any other reports you have scheduled, so if you have several that run at 8am have this run at 7am