cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate II
Advocate II

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.

I think the new Jan Report Server is making Zombie Queries to the database!

Helpful resources

Announcements
Super Users of the Quarter - Q2 2020

Super Users of the Quarter - Q2 2020

Who are our Super User Superstars? Who made it to the top of the leaderboards? Get the answers!

June 2020 Community Highlights

June 2020 Community Highlights

Featured community members, changes to the Community, and more! Read up on recent Power BI community news.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors