SSRS- rsInternalError

Question

Today our reporting server started throwing  and rsInternal Errors when trying to view a deployed report

Any Ideas as the cause?

-------------------------------------------------------------------------------------------------------------------------------------------

library!ReportServer_0-2!10a8!04/25/2012-01:03:54:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., no data found for snapshot;
 Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
library!ReportServer_0-2!10a8!04/25/2012-01:03:56:: i INFO: Exception InternalCatalogException dumped to: E:\SQLSERVER2008\MSRS10.COMPASSNORM\Reporting Services\Logfiles flags= ReferencedMemory, AllThreads, SendToWatson
ui!ReportManager_0-1!1f24!04/25/2012-01:03:56:: e ERROR: System.Web.Services.Protocols.SoapException: An internal error occurred on the report server. See the error log for more details. ---> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
   at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.GetProperties(String Item, Property[] Properties, Property[]& Values)
   at Microsoft.ReportingServices.WebServer.ReportingService2005.GetProperties(String Item, Property[] Properties, Property[]& Values)
ui!ReportManager_0-1!1f24!04/25/2012-01:03:56:: e ERROR: HTTP status code --> 200
-------Details--------
System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: An internal error occurred on the report server. See the error log for more details. ---> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
   at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.GetProperties(String Item, Property[] Properties, Property[]& Values)
   at Microsoft.ReportingServices.WebServer.ReportingService2005.GetProperties(String Item, Property[] Properties, Property[]& Values)

   at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)

   at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)

   at Microsoft.SqlServer.ReportingServices2005.ReportingService2005.GetProperties(String Item, Property[] Properties)

   at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetProperties(String Item, Property[] Properties)

   at Microsoft.ReportingServices.UI.ReportingWebControl.GetItemProperties(String itemPath, String[] properties)

   at Microsoft.ReportingServices.UI.ReportWrapperPage.Page_Init(Object sender, EventArgs e)

   at System.EventHandler.Invoke(Object sender, EventArgs e)

   at System.Web.UI.Control.OnInit(EventArgs e)

   at System.Web.UI.Page.OnInit(EventArgs e)

   at System.Web.UI.Control.InitRecursive(Control namingContainer)

   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
library!ReportServer_0-2!1718!04/25/2012-01:03:56:: Call to GetSystemPropertiesAction().
ui!ReportManager_0-1!1f24!04/25/2012-01:03:56:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted.
   at System.Threading.Thread.AbortInternal()
   at System.Threading.Thread.Abort(Object stateInfo)
   at System.Web.HttpResponse.End()
   at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at    at System.Threading.Thread.AbortInternal()
   at System.Threading.Thread.Abort(Object stateInfo)
   at System.Web.HttpResponse.End()
   at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)
library!ReportServer_0-2!3bc!04/25/2012-01:04:05:: Call to GetPermissionsAction(/Data Extract Reports).
library!ReportServer_0-2!1f24!04/25/2012-01:04:05:: Call to GetPropertiesAction(/Data Extract Reports, PathBased).
library!ReportServer_0-2!142c!04/25/2012-01:04:05:: Call to GetSystemPermissionsAction().
library!ReportServer_0-2!1f24!04/25/2012-01:04:05:: Call to GetPropertiesAction(/Data Extract Reports, PathBased).
library!ReportServer_0-2!1ce0!04/25/2012-01:04:05:: Call to ListChildrenAction(/, False).
library!ReportServer_0-2!1f24!04/25/2012-01:04:05:: Call to GetSystemPropertiesAction().
library!ReportServer_0-2!eb4!04/25/2012-01:04:12:: Call to GetPermissionsAction(/Data Extract Reports).
library!ReportServer_0-2!1ce0!04/25/2012-01:04:12:: Call to GetPropertiesAction(/Data Extract Reports, PathBased).
library!ReportServer_0-2!1d00!04/25/2012-01:04:12:: Call to GetSystemPermissionsAction().
library!ReportServer_0-2!1718!04/25/2012-01:04:12:: Call to ListChildrenAction(/Data Extract Reports, False).
library!ReportServer_0-2!1d00!04/25/2012-01:04:12:: Call to GetSystemPropertiesAction().
library!ReportServer_0-2!1050!04/25/2012-01:04:12:: Call to GetSystemPropertiesAction().
library!ReportServer_0-2!eb4!04/25/2012-01:04:12:: Call to GetSystemPropertiesAction().
library!ReportServer_0-2!1d00!04/25/2012-01:04:15:: Call to GetSystemPermissionsAction().
library!ReportServer_0-2!1050!04/25/2012-01:04:15:: Call to ListSubscriptionsAction(null,*** ).
library!ReportServer_0-2!150c!04/25/2012-01:04:15:: Call to GetSystemPropertiesAction().
library!ReportServer_0-2!1d00!04/25/2012-01:04:16:: Call to GetSystemPermissionsAction().
library!ReportServer_0-2!1718!04/25/2012-01:04:16:: Call to GetSystemPropertiesAction().
library!ReportServer_0-2!150c!04/25/2012-01:04:17:: Call to GetSystemPropertiesAction().
library!ReportServer_0-2!1d00!04/25/2012-01:04:19:: Call to GetSystemPermissionsAction().
library!ReportServer_0-2!142c!04/25/2012-01:04:19:: Call to ListSchedulesAction().
library!ReportServer_0-2!150c!04/25/2012-01:04:20:: Call to GetSystemPropertiesAction().
library!ReportServer_0-2!1d00!04/25/2012-01:04:21:: Call to GetSystemPermissionsAction().
library!ReportServer_0-2!142c!04/25/2012-01:04:21:: Call to GetSystemPoliciesAction().
library!ReportServer_0-2!150c!04/25/2012-01:04:22:: Call to GetSystemPropertiesAction().
library!ReportServer_0-2!150c!04/25/2012-01:04:27:: Call to GetSystemPermissionsAction().
library!ReportServer_0-2!1718!04/25/2012-01:04:27:: Call to GetSystemPropertiesAction().
library!ReportServer_0-2!1bd4!04/25/2012-01:04:27:: Call to GetSystemPropertiesAction().
library!WindowsService_0!1960!04/25/2012-01:10:34:: i INFO: Call to CleanBatch()
library!WindowsService_0!1960!04/25/2012-01:10:34:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings.
library!WindowsService_0!1960!04/25/2012-01:10:34:: i INFO: Call to CleanBatch() ends
library!WindowsService_0!16e8!04/25/2012-01:20:34:: i INFO: Call to CleanBatch()
library!WindowsService_0!16e8!04/25/2012-01:20:34:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings.
library!WindowsService_0!16e8!04/25/2012-01:20:34:: i INFO: Call to CleanBatch() ends
library!WindowsService_0!9bc!04/25/2012-01:30:34:: i INFO: Call to CleanBatch()
library!WindowsService_0!9bc!04/25/2012-01:30:34:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings.
library!WindowsService_0!9bc!04/25/2012-01:30:34:: i INFO: Call to CleanBatch() ends
library!WindowsService_0!418!04/25/2012-01:40:34:: i INFO: Call to CleanBatch()
library!WindowsService_0!418!04/25/2012-01:40:34:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings.
library!WindowsService_0!418!04/25/2012-01:40:34:: i INFO: Call to CleanBatch() ends
library!DefaultDomain!1f24!04/25/2012-01:40:52:: i INFO: Catalog SQL Server Edition = Standard
resourceutilities!DefaultDomain!1f24!04/25/2012-01:40:52:: i INFO: Reporting Services starting SKU: Standard
resourceutilities!DefaultDomain!1f24!04/25/2012-01:40:52:: i INFO: Evaluation copy: 0 days left
library!WindowsService_0!9bc!04/25/2012-01:50:34:: i INFO: Call to CleanBatch()
library!WindowsService_0!9bc!04/25/2012-01:50:34:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings.
library!WindowsService_0!9bc!04/25/2012-01:50:34:: i INFO: Call to CleanBatch() ends
library!ReportServer_0-2!1414!04/25/2012-01:58:15:: Call to GetPermissionsAction(/).
library!ReportServer_0-2!1d00!04/25/2012-01:58:15:: Call to GetPropertiesAction(/, PathBased).
library!ReportServer_0-2!1a80!04/25/2012-01:58:15:: Call to GetSystemPermissionsAction().
library!ReportServer_0-2!eb4!04/25/2012-01:58:15:: Call to ListChildrenAction(/, False).
library!ReportServer_0-2!17b4!04/25/2012-01:58:15:: Call to GetSystemPropertiesAction().
library!ReportServer_0-2!1d00!04/25/2012-01:58:15:: Call to GetSystemPropertiesAction().
library!ReportServer_0-2!15a4!04/25/2012-01:58:15:: Call to GetSystemPropertiesAction().
library!ReportServer_0-2!17b4!04/25/2012-01:58:17:: Call to GetPermissionsAction(/CallsToTickets Reports).
library!ReportServer_0-2!15c4!04/25/2012-01:58:17:: Call to GetPropertiesAction(/CallsToTickets Reports, PathBased).
library!ReportServer_0-2!15a4!04/25/2012-01:58:17:: Call to GetSystemPermissionsAction().
library!ReportServer_0-2!15c4!04/25/2012-01:58:17:: Call to ListChildrenAction(/CallsToTickets Reports, False).
library!ReportServer_0-2!1050!04/25/2012-01:58:18:: Call to GetSystemPropertiesAction().
library!ReportServer_0-2!15c4!04/25/2012-01:58:18:: Call to GetSystemPropertiesAction().
library!ReportServer_0-2!1a80!04/25/2012-01:58:18:: Call to GetSystemPropertiesAction().
library!ReportServer_0-2!1050!04/25/2012-01:58:18:: Call to GetPermissionsAction(/CallsToTickets Reports/Calls to Tickets Report - SelDate).
library!ReportServer_0-2!15c4!04/25/2012-01:58:19:: Call to GetSystemPropertiesAction().
library!ReportServer_0-2!1414!04/25/2012-01:58:19:: Call to GetPropertiesAction(/CallsToTickets Reports/Calls to Tickets Report - SelDate, PathBased).
library!ReportServer_0-2!1414!04/25/2012-01:58:19:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., no data found for snapshot;
 Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
library!ReportServer_0-2!1414!04/25/2012-01:58:20:: i INFO: Exception InternalCatalogException dumped to: E:\SQLSERVER2008\MSRS10.COMPASSNORM\Reporting Services\Logfiles flags= ReferencedMemory, AllThreads, SendToWatson
ui!ReportManager_0-1!15a4!04/25/2012-01:58:20:: e ERROR: System.Web.Services.Protocols.SoapException: An internal error occurred on the report server. See the error log for more details. ---> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
   at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.GetProperties(String Item, Property[] Properties, Property[]& Values)
   at Microsoft.ReportingServices.WebServer.ReportingService2005.GetProperties(String Item, Property[] Properties, Property[]& Values)
ui!ReportManager_0-1!15a4!04/25/2012-01:58:20:: e ERROR: HTTP status code --> 200
-------Details--------
System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: An internal error occurred on the report server. See the error log for more details. ---> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
   at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.GetProperties(String Item, Property[] Properties, Property[]& Values)
   at Microsoft.ReportingServices.WebServer.ReportingService2005.GetProperties(String Item, Property[] Properties, Property[]& Values)

   at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)

   at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)

   at Microsoft.SqlServer.ReportingServices2005.ReportingService2005.GetProperties(String Item, Property[] Properties)

   at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetProperties(String Item, Property[] Properties)

   at Microsoft.ReportingServices.UI.ReportingWebControl.GetItemProperties(String itemPath, String[] properties)

   at Microsoft.ReportingServices.UI.ReportWrapperPage.Page_Init(Object sender, EventArgs e)

   at System.EventHandler.Invoke(Object sender, EventArgs e)

   at System.Web.UI.Control.OnInit(EventArgs e)

   at System.Web.UI.Page.OnInit(EventArgs e)

   at System.Web.UI.Control.InitRecursive(Control namingContainer)

   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
library!ReportServer_0-2!15c4!04/25/2012-01:58:20:: Call to GetSystemPropertiesAction().
ui!ReportManager_0-1!15a4!04/25/2012-01:58:20:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted.
   at System.Threading.Thread.AbortInternal()
   at System.Threading.Thread.Abort(Object stateInfo)
   at System.Web.HttpResponse.End()
   at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at    at System.Threading.Thread.AbortInternal()
   at System.Threading.Thread.Abort(Object stateInfo)
   at System.Web.HttpResponse.End()
   at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)
dbcleanup!WindowsService_0!1a5c!04/25/2012-02:00:00:: i INFO: Expiring old execution log entries
dbcleanup!WindowsService_0!1a5c!04/25/2012-02:00:00:: i INFO: Expiration of old execution log entries is complete.  Removed 41 entries.
library!WindowsService_0!1a5c!04/25/2012-02:00:00:: Using folder E:\SQLSERVER2008\MSRS10.COMPASSNORM\Reporting Services\RSTempFiles for temporary files.
dbcleanup!WindowsService_0!1a5c!04/25/2012-02:00:00:: i INFO: Cleaned 1 broken snapshots, 0 chunks, there were 0 unsuccessful attempts
dbcleanup!WindowsService_0!1a5c!04/25/2012-02:00:00:: i INFO: Cleaned 0 parameters values
dbcleanup!WindowsService_0!1a5c!04/25/2012-02:00:07:: i INFO: Cleaned 3906 unused segment mappings.

Answer 1

As suggested by the error description, have you viewed the logs. The log file would give more details toward identifying the underlying reason for the error.

Regards

Irshad

 

---

Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.

BH

Answer 2

I have viewed the error log, but still not understanding the problem based on the results.

-------------------------------------------------------------------------------------------------------------

(163C:9E4) 04/25/12 04:38:48, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied
(163C:9E4) 04/25/12 04:38:48, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,  Parameter 1: 5820
(163C:9E4) 04/25/12 04:38:48, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,  Parameter 2: 0
(163C:9E4) 04/25/12 04:38:48, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,  Parameter 3: 0:0
(163C:9E4) 04/25/12 04:38:48, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,  Parameter 4: 0000000000DB0630
(163C:9E4) 04/25/12 04:38:48, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parsed parameters:
(163C:9E4) 04/25/12 04:38:48, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     ProcessID = 5820
(163C:9E4) 04/25/12 04:38:48, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     ThreadId = 0
(163C:9E4) 04/25/12 04:38:48, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     Flags = 0x0
(163C:9E4) 04/25/12 04:38:48, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     MiniDumpFlags = 0x0
(163C:9E4) 04/25/12 04:38:48, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     SqlInfoPtr = 0x0000000000DB0630
(163C:9E4) 04/25/12 04:38:48, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     DumpDir = <NULL>
(163C:9E4) 04/25/12 04:38:48, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     ExceptionRecordPtr = 0x0000000000000000
(163C:9E4) 04/25/12 04:38:48, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     ContextPtr = 0x0000000000000000
(163C:9E4) 04/25/12 04:38:48, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     ExtraFile = <NULL>
(163C:9E4) 04/25/12 04:38:48, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     InstanceName = <NULL>
(163C:9E4) 04/25/12 04:38:48, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     ServiceName = <NULL>
(163C:9E4) 04/25/12 04:38:48, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used
(163C:9E4) 04/25/12 04:38:48, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 15 not used
(163C:9E4) 04/25/12 04:38:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
(163C:9E4) 04/25/12 04:38:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: E:\SQLSERVER2008\MSRS10.COMPASSNORM\Reporting Services\Logfiles\SQLDmpr0029.mdmp
(163C:9E4) 04/25/12 04:38:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Location of module 'dbghelp.dll' : 'C:\Program Files\Microsoft SQL Server\100\Shared\dbghelp.dll'
(163C:9E4) 04/25/12 04:38:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, File version of module 'C:\Program Files\Microsoft SQL Server\100\Shared\dbghelp.dll' : '6.8:4.0'
(163C:9E4) 04/25/12 04:38:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Product version of module 'C:\Program Files\Microsoft SQL Server\100\Shared\dbghelp.dll' : '6.8:4.0'
(163C:9E4) 04/25/12 04:38:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Location of module 'sqldumper.exe' : 'C:\Program Files\Microsoft SQL Server\100\Shared\SQLDUMPER.EXE'
(163C:9E4) 04/25/12 04:38:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, File version of module 'C:\Program Files\Microsoft SQL Server\100\Shared\SQLDUMPER.EXE' : '2007.100:1600.22'
(163C:9E4) 04/25/12 04:38:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Product version of module 'C:\Program Files\Microsoft SQL Server\100\Shared\SQLDUMPER.EXE' : '10.0:1600.22'
(163C:9E4) 04/25/12 04:38:49, ACTION, ReportingServicesService.exe, Watson Invoke: No

Answer 3

The snapshops were jacked...So we redeployed all reports and appears to be working fine now.