Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.