Ever since I've upgraded to Report Server 2020 Jan Release. I've been having a problem with just with one my Paginated Report.
This Paginated report refreshes every so often on a page refresh that been set.
During the first Load, the page loads the report.
During the auto refresh I get this message. (This is happening across multiple browsers and PC though out the company)
Report Server Error
- An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database. (rsReportServerDatabaseError) Get Online Help
- For more information about this error navigate to the report server on the local server machine, or enable remote errors
Here is the error I found in the log.
It does not make sense to me that it loads just fine, then the auto page refresh kicks in, and I get the error.
Any help would be much appreciated!
INFO: Entering StreamRequestHandler.ExecuteCommand - Command =
INFO: Call to GetItemTypeAction(/Operations/Production/Building). User: US\US*******.
INFO: RenderForNewSession('/Operations/Production/Building')
ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException:,
Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException:
The report execution xyisd155ipv5ul45mrmbvq45 has expired or cannot be found.;
WARN: Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException:
The report execution xyisd155ipv5ul45mrmbvq45 has expired or cannot be found.
ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: ,
An error occurred within the report server database.
This may be due to a connection failure, timeout or low disk condition within the database.;
ERROR: Transaction commit failed.
Exception thrown: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException:
An error occurred within the report server database.
This may be due to a connection failure, timeout or low disk condition within the database.
---> System.InvalidOperationException:
This SqlTransaction has completed; it is no longer usable.
** Already check the normal stuff..
All Permissions&Roles are properly set on SQL Server where Report Server DB and Temp exists.
master, msdb
SSD has plently of space.
SQL query is less than 1 second to return.
dbcc checkdb came back nothing is wrong.
I think the new Jan Report Server is making Zombie Queries to the database!
