Question

AndySugs on Mon, 13 Feb 2017 18:24:01


Hi,

I'm trying to upgrade our reporting services so that our live server is on SQL Server Reporting Services 2016. We were on 2008 R2 so we built a new server and installed 2016 then restored backup from 2008r2 version and that seemed to work fine.

However, we are now having several issues which I've listed below. If anyone could give me any advice on any of these it'd be much appreciated: 

  1. The ReportServerService log files in folder C:\Program Files\Microsoft SQL Server\MSRS13.MSSQLSERVER\Reporting Services\LogFiles are filling up the c drive. Files size of 32,770 KB seem to be firing out at one a minute. I checked on msdn at following link https://msdn.microsoft.com/en-us/library/ms156500.aspx as thought maybe set to verbose but in ReportingServicesrService.exe.config file is showing at default setting of 3 so not sure why so many ReportServerService log files are being saved.
  2. When tried to open reports on IE11 got message 'The website cannot display the page. Most likely causes: The website is under maintenance or the website has a programming error' Why can Microsoft's own reports not open on Microsoft's own browser?!!
  3. I've tried creating zip file to create a brand look but the University of Bolton logo won't appear. Is there any limit on the size of the logo file

Cheers, AndySugs


Sponsored



Replies

Eric Gunnerson on Mon, 13 Feb 2017 22:38:57


Andy,

  1. Have you looked in them to see to see if there are any clues? I'd expect there to be a lot of errors there if they are filling up very quickly.
  2. Might be related to #1
  3. For the logo, we supposedly resize the logo you submit to an appropriate size. Were you following the directions here?

AndySugs on Tue, 14 Feb 2017 15:19:00


The main error I can see is:

library!WindowsService_1!8a0!02/10/2017-00:48:00:: e 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.;

which obviously is due to the disk being full. Initially the drive was 40Gb which filled up immediately so then we added another 10Gb and that filled up almost immediately as well. Networks have just added another 10Gb to the drive and it doesn't seem to be filling up this time so perhaps 40Gb wasn't enough. However, from the documentation I've read relating to sizing the OS drive 40Gb seemed adequate.

The reports are now running but values seem to be missing. When I run the report on the 2016 server I get

Why are values showing in the top table but not the bottom?! Could it have anything to do with the branding I've been trying to do?

On 2008 r2 I get

I still can't get the logo to show. I was using the exact same article as you pointed me to in your link although after struggling with which bit of code related to which section on the screen I found the following quite useful https://www.mssqltips.com/sqlservertip/4567/sql-server-2016-reporting-services-custom-branding-example/

I'm going to give it a whirl now with the branding again but at least we've had major improvement on the first 2 issues in my list.


Cheers, AndySugs





AndySugs on Wed, 15 Feb 2017 10:57:52


When I came in this morning the C drive was full again. From the drive being 40GB initially we have now twice added 10Gb and twice it has filled that 10Gb within 24 hrs. Any idea why this could be?

Eric Gunnerson on Wed, 15 Feb 2017 19:23:04


That error is unfortunately a generic one, and isn't as actionable as we would like. 

One thing to try:

Connect to the catalog database with SSMS, and execute the following query:

SELECT TOP (1000) 
      [Report_OID]
      ,Catalog.Path
      ,[LastStatus]
      ,[LastRunTime]
      ,[SubscriptionID]
      ,[subscriptions].[Description]
  FROM [ReportServer].[dbo].[Subscriptions] inner join [Catalog] on ItemID = report_oid
  where convert(varchar(10), lastruntime, 102) = convert(varchar(10), getdate(), 102)
  order by LastRunTime

That will look at all the subscriptions that have run in the last day. My guess/hope is that you have a report that is running often and it is repeatedly hitting the same error, so look at laststatus and path and see if you see a consistent failure for one report. If you find it, go to that report and try executing it. 

Hope that helps

Eric

AndySugs on Fri, 17 Feb 2017 12:09:37


OK thanks Eric.

The issue seems to have resolved itself. I deleted a lot of the text files which only had that same low disk condition error message in and it released about 26GB. I also updated server to service pack 1 and set up since then it seems to have sorted itself out as the amount of memory remaining has been stable for the last 2 days at 25GB. Obviously this is good but still unclear why so many log files were being spat out initially but perhaps now I'll never get to find out.

In relation to the text files that are in C:\Program Files\Microsoft SQL Server\MSRS13.MSSQLSERVER\Reporting Services\LogFiles, am I right in thinking that the log files will be cleared in line with what is set in the ReportingServicesService.exe.config file? The LogFiles folder doesn't have to be included in a maintenance plan cleanup task?

I've also cracked the issue with the logo. I'd basically misspelt a word in the name section of the colors JSON file. Once I corrected it then I managed to get the University of Bolton brand up and running.

Eric Gunnerson on Fri, 17 Feb 2017 17:26:04


Happy that you seem to have things working.

The logs files should be deleted automatically when they exceed the threshold set in the config file. 

Cheers

Eric

Pirlo Zhang on Mon, 20 Feb 2017 13:57:53


Hi Andysugs,

If your issue is solved please mark the appropriate answer as Mark as answer. This will help other members to find a solution if they face the same issue.

Thanks for your understanding and support.

If you still have any questions, please feel free to ask.

Best Regards,

Pirlo Zhang