SSRS Fileshare Subscription Report With Chart Does Not Appear When Viewed in Web Browser

Question

SSRS Fileshare Subscription Report With Chart Does Not Appear When Viewed in Web Browser

mmcardle

SSCommitted

Points: 1543
More actions
July 3, 2017 at 9:24 am

#331665

My SSRS fileshare subscription works fine and creates or overwrites the .html file in the desired location.
The chart is a simple line chart and previews OK in SQL Server Data Tools. It also appears fine in SSRS Report Manager.
When I open the .html file in a web browser though (Chrome, IE or Edge), all I get is the following in the top left corner:

The SSRS log file says this:
webserver!ReportServer_0-2!158c!07/03/2017-16:04:17:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database. ---> 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.
at System.Data.SqlClient.SqlTransaction.ZombieCheck()
at System.Data.SqlClient.SqlTransaction.Commit()
at Microsoft.ReportingServices.Library.ConnectionManager.CommitTransaction()
I've done a lot of searching, but can't find the answer. I tried an SSRS install repair (as recommended elsewhere), rebooted, but no difference.
Most other sites I have searched have a similar problem, but where there is drill-down in the report. This doesn't have that.
Most solutions offered are for SQL Server 2000 or 2005 or 2008 involving service packs for those versions. My version is:
Microsoft SQL Server 2014 (SP2-GDR) (KB3194714) - 12.0.5203.0 (X64) Sep 23 2016 18:13:56 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)
So, I've kinda stalled at this moment. Some lovely insight into this would be warmly received.
Many thanks for any help out there.
Regards,
Mark

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

mmcardle SSCommitted Points: 1543 More actions · Answer 1

Sorry, I should have posted this from the SSRS log file too:

library!ReportServer_0-2!267c!07/03/2017-16:03:47:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.StreamNotFoundException: , Microsoft.ReportingServices.Diagnostics.Utilities.StreamNotFoundException: The stream cannot be found. The stream identifier that is provided to an operation cannot be located in the report server database.;
webserver!ReportServer_0-2!267c!07/03/2017-16:03:47:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.StreamNotFoundException: The stream cannot be found. The stream identifier that is provided to an operation cannot be located in the report server database.

Sue_H SSC Guru Points: 90860 More actions · Answer 2

Did you also try disabling session cookies to see if it made a difference?
Did you also check if the report referencing external images?

Sue

mmcardle SSCommitted Points: 1543 More actions · Answer 3

Hi Sue_H,

I've decided to go down a different route and use ASP.NET instead, but thank you for responding.

Regards,

Mark