Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Issue with Report Server 2020 January Release

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.

Status: New
Comments
v-yuta-msft
Community Support

@Anonymous ,

 

Please create a support ticket here.

 

Regards,

Jimmy Tao