Want more features on Pastebin? Sign Up, it's FREE!
Guest

Diagnosing Intermittent SSRS 2008 Report Error

By: a guest on Mar 28th, 2012  |  syntax: None  |  size: 6.37 KB  |  views: 131  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. appdomainmanager!DefaultDomain!14cc!05/30/2011-15:57:19:: i INFO: Appdomain:3  ReportManager_MSSQLSERVER_0-1-129512086394759387 started.
  2.  
  3. appdomainmanager!ReportManager_0-1!14cc!05/30/2011-15:57:19:: i INFO: RS authentication mode is 4; effective ASP.NET authentication mode is Windows. vdir=/Reports.
  4.  
  5. appdomainmanager!DefaultDomain!14cc!05/30/2011-15:57:19:: i INFO: Appdomain:3 ReportManager_MSSQLSERVER_0-1-129512086394759387 initialized (#1).
  6.  
  7. library!WindowsService_0!18c8!05/30/2011-15:57:20:: 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.;
  8.  
  9. library!WindowsService_0!18c8!05/30/2011-15:57:20:: e ERROR: Sql error while calling GetDBVersion: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.Data.SqlClient.SqlException: A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)
  10.  
  11. dbpolling!WindowsService_0!18c8!05/30/2011-15:57:20:: e ERROR: PollingMaintenance: Restarting maintenance thread for the following exception: 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.Data.SqlClient.SqlException: A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.).
  12.  
  13. appdomainmanager!DefaultDomain!1600!05/30/2011-15:57:21:: i INFO: Appdomain:4 ReportServer_MSSQLSERVER_0-2-129512086415541036 started.
  14.  
  15. appdomainmanager!ReportServer_0-2!1600!05/30/2011-15:57:21:: i INFO: RS authentication mode is 4; effective ASP.NET authentication mode is Windows. vdir=/ReportServer.
  16.  
  17. appdomainmanager!DefaultDomain!1600!05/30/2011-15:57:22:: i INFO: Appdomain:4 ReportServer_MSSQLSERVER_0-2-129512086415541036 initialized (#1).
  18.  
  19. library!WindowsService_0!18c8!05/30/2011-15:57:23:: e ERROR: Throwing Microsoft.ReportingServices.Library.ReportServerDatabaseUnavailableException: , Microsoft.ReportingServices.Library.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. ---> System.Data.SqlClient.SqlException: Cannot open database "ReportServer" requested by the login. The login failed.
  20. Login failed for user 'NSWDOHsys_NS_SQLServer2k8'.
  21.    at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
  22.    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
  23.    at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
  24.    at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
  25.    at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
  26.    at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
  27.    at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
  28.    at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
  29.    at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
  30.    at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
  31.    at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
  32.    at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
  33.    at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
  34.    at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
  35.    at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
  36.    at System.Data.SqlClient.SqlConnection.Open()
  37.    at Microsoft.ReportingServices.Library.ConnectionManager.OpenConnection()
  38.    --- End of inner exception stack trace ---;
  39.  
  40. dbpolling!WindowsService_0!18c8!05/30/2011-15:57:23:: e ERROR: PollingMaintenance: Restarting maintenance thread for the following exception: Microsoft.ReportingServices.Library.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. ---> System.Data.SqlClient.SqlException: Cannot open database "ReportServer" requested by the login. The login failed.
  41. Login failed for user 'NSWDOHsys_NS_SQLServer2k8'..
  42.  
  43. webserver!ReportServer_0-2!1600!05/30/2011-15:57:26:: i INFO: Reporting Web Server started
  44.  
  45. resourceutilities!ReportServer_0-2!1600!05/30/2011-15:57:26:: i INFO: Reporting Services starting SKU: Developer
  46.  
  47. library!ReportServer_0-2!1600!05/30/2011-15:57:27:: i INFO: Catalog SQL Server Edition = Developer
  48.  
  49. crypto!ReportServer_0-2!1600!05/30/2011-15:57:27:: i INFO: Initializing crypto as user: NSWDOHsys_NS_SQLServer2k8
  50.  
  51. crypto!ReportServer_0-2!1600!05/30/2011-15:57:27:: i INFO: Exporting public key
  52.  
  53. crypto!ReportServer_0-2!1600!05/30/2011-15:57:27:: i INFO: Performing sku validation
  54.  
  55. crypto!ReportServer_0-2!1600!05/30/2011-15:57:27:: i INFO: Importing existing encryption key
  56.  
  57. library!WindowsService_0!18c8!05/30/2011-15:57:29:: i INFO: PollingMaintenance: Polling cycle completed.
clone this paste RAW Paste Data