Home » SQL ServerRSS

Email Subscription Failure SSRS 2008

Hello,

Just migrated SSRS from 2005 to SSRS 2008 SP1. I have several report snapshots based on one schedule, and they subscriptions are triggered to email after the report content is refreshed (snapshot updated).  Some of the reports are getting emailed successfully, but not all.  The failures are inconsistent.  The same report does not fail every time.  Here is a sample from the log on one of the failures:

 

   at Microsoft.ReportingServices.Library.Storage.WrapAndThrowKnownExceptionTypes(Exception e)
   at Microsoft.ReportingServices.Library.ConnectionManager.CommitTransaction()
library!WindowsService_1!c50!08/18/2010-10:34:17:: i INFO: RenderForNewSession('/Reports/O_Daily_TL_Table_Counts')
library!WindowsService_1!c50!08/18/2010-10:34:17:: i INFO: Initializing EnableExecutionLogging to 'True'  as specified in Server system properties.
library!WindowsService_1!47c!08/18/2010-10:34:17:: i INFO: Replacing references of snapshot 'd714481a-f1e8-43bc-bc74-f56b067fc476' with snapshot '3f7943b7-2066-4f09-9792-b86be655b4ab'
library!WindowsService_1!c50!08/18/2010-10:34:17:: 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., ;
library!WindowsService_1!c50!08/18/2010-10:34:17:: 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., ;
library!WindowsService_1!c50!08/18/2010-10:34:17:: e 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.
   at System.Data.SqlClient.SqlTransaction.ZombieCheck()
   at System.Data.SqlClient.SqlTransaction.Commit()
   at Microsoft.ReportingServices.Library.ConnectionManager.CommitTransaction()
   --- End of inner exception stack trace ---
   at Microsoft.ReportingServices.Library.Storage.WrapAndThrowKnownExceptionTypes(Exception e)
   at Microsoft.ReportingServices.Library.ConnectionManager.CommitTransaction()

 

 

   at Microsoft.ReportingServices.Library.Storage.WrapAndThrowKnownExceptionTypes(Exception e)
   at Microsoft.ReportingServices.Library.ConnectionManager.CommitTransaction()
library!WindowsService_1!c50!08/18/2010-10:34:17:: i INFO: RenderForNewSession('/Reports/O_Daily_TL_Table_Counts')
library!WindowsService_1!c50!08/18/2010-10:34:17:: i INFO: Initializing EnableExecutionLogging to 'True'  as specified in Server system properties.
library!WindowsService_1!47c!08/18/2010-10:34:17:: i INFO: Replacing references of snapshot 'd714481a-f1e8-43bc-bc74-f56b067fc476' with snapshot '3f7943b7-2066-4f09-9792-b86be655b4ab'
library!WindowsService_1!c50!08/18/2010-10:34:17:: 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., ;
library!WindowsService_1!c50!08/18/2010-10:34:17:: 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., ;
library!WindowsService_1!c50!08/18/2010-10:34:17:: e 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.
   at System.Data.SqlClient.SqlTransaction.ZombieCheck()
   at System.Data.SqlClient.SqlTransaction.Commit()
   at Microsoft.ReportingServices.Library.ConnectionManager.CommitTransaction()
   --- End of inner exception stack trace ---
   at Microsoft.ReportingServices.Library.Storage.WrapAndThrowKnownExceptionTypes(Exception e)
   at Microsoft.ReportingServices.Library.ConnectionManager.CommitTransaction()

 

1 Answer Found

 

Answer 1

Hi,

Based on the error message, try the following suggestions:

1. Apply the latest service pack to SQL Server Reporting Services.

2. Make sure the shared disk has enough size.

3. If possible, try to change to different SMTP server.

Hope this helpfully,

thanks,
Jerry

 
 
 

<< Previous      Next >>


Microsoft   |   Windows   |   Visual Studio   |   Follow us on Twitter