Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSRS Report Manager Error Expand / Collapse
Author
Message
Posted Thursday, July 18, 2013 1:12 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, August 12, 2013 9:36 PM
Points: 1, Visits: 17
Hi Everyone,

Hope you could help me with this. I have set up Reporting Services and when I've tried accessing the Report Manager, I can see all the created Folders and uploaded RDL files. However, when I've tried to make changes in a shared data source, it won't allow the changes and throws up the error:

"An internal or system error occurred in the HTTP Runtime object for application domain ReportManager_MSSQLSERVER_0-1-130186043382179983"

It also shows up when I've tried to upload new RDL files. I have also checked the log files and here are the details:

<Header>
<Product>Microsoft SQL Server Reporting Services Version 2009.0100.1600.01 ((KJ_RTM).100402-1539 )</Product>
<Locale>English (United States)</Locale>
<TimeZone></TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\Logfiles\ReportServerService__07_18_2013_17_00_47.log</Path>
<SystemName>APPSSERVER</SystemName>
<OSName>Microsoft Windows NT 6.1.7601 Service Pack 1</OSName>
<OSVersion>6.1.7601</OSVersion>
<ProcessID>4044</ProcessID>
<Virtualization>Hypervisor</Virtualization>
</Header>
rshost!rshost!f68!07/18/2013-17:00:47:: i INFO: CLR runtime is initialized.
rshost!rshost!f68!07/18/2013-17:00:47:: i INFO: Derived memory configuration based on physical memory as 8388152 KB
appdomainmanager!DefaultDomain!1040!07/18/2013-17:00:47:: i INFO: Entered managed ServiceMain in DefaultDomain.
library!DefaultDomain!dcc!07/18/2013-17:00:47:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
library!DefaultDomain!dcc!07/18/2013-17:00:47:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
library!DefaultDomain!dcc!07/18/2013-17:00:47:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
library!DefaultDomain!dcc!07/18/2013-17:00:47:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
library!DefaultDomain!dcc!07/18/2013-17:00:47:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
library!DefaultDomain!dcc!07/18/2013-17:00:47:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
library!DefaultDomain!dcc!07/18/2013-17:00:47:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
library!DefaultDomain!dcc!07/18/2013-17:00:47:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
library!DefaultDomain!dcc!07/18/2013-17:00:47:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
library!DefaultDomain!dcc!07/18/2013-17:00:47:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
library!DefaultDomain!dcc!07/18/2013-17:00:47:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
library!DefaultDomain!dcc!07/18/2013-17:00:47:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
library!DefaultDomain!dcc!07/18/2013-17:00:47:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException,Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException' as specified in Configuration file.
library!DefaultDomain!dcc!07/18/2013-17:00:47:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Threading.ThreadAbortException,System.Web.UI.ViewStateException,System.OutOfMemoryException,System.Web.HttpException,System.IO.IOException,System.IO.FileLoadException,Microsoft.SharePoint.SPException' as specified in Configuration file.
library!DefaultDomain!dcc!07/18/2013-17:00:47:: i INFO: Initializing AuthenticationTypes to '5' as specified in Configuration file.
library!DefaultDomain!dcc!07/18/2013-17:00:47:: i INFO: Initializing RSWindowsExtendedProtectionLevel to 'Off' as specified in Configuration file.
library!DefaultDomain!dcc!07/18/2013-17:00:47:: i INFO: Initializing RSWindowsExtendedProtectionScenario to 'Proxy' as specified in Configuration file.
library!DefaultDomain!dcc!07/18/2013-17:00:47:: i INFO: Initializing EnableAuthPersistence to 'True' as specified in Configuration file.
library!DefaultDomain!dcc!07/18/2013-17:00:47:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
library!DefaultDomain!dcc!07/18/2013-17:00:47:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
library!DefaultDomain!dcc!07/18/2013-17:00:47:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
library!DefaultDomain!dcc!07/18/2013-17:00:47:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
library!DefaultDomain!dcc!07/18/2013-17:00:47:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
library!DefaultDomain!dcc!07/18/2013-17:00:47:: i INFO: Initializing MemorySafetyMargin to '80' percent as specified in Configuration file.
library!DefaultDomain!dcc!07/18/2013-17:00:47:: i INFO: Initializing MemoryThreshold to '90' percent as specified in Configuration file.
library!DefaultDomain!dcc!07/18/2013-17:00:47:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
library!DefaultDomain!dcc!07/18/2013-17:00:47:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
library!DefaultDomain!dcc!07/18/2013-17:00:47:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
library!DefaultDomain!dcc!07/18/2013-17:00:47:: w WARN: Initializing UrlRoot to default value of '' because it was incorrectly specified in Configuration file as ''.
library!DefaultDomain!dcc!07/18/2013-17:00:47:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
library!DefaultDomain!dcc!07/18/2013-17:00:47:: i INFO: Initializing IsReportManagerEnabled to 'True' as specified in Configuration file.
library!DefaultDomain!dcc!07/18/2013-17:00:47:: i INFO: Initializing MaxConnections to '2' as specified in Configuration file.
library!DefaultDomain!dcc!07/18/2013-17:00:47:: i INFO: Initializing Timeout to '10' second(s) as specified in Configuration file.
library!DefaultDomain!dcc!07/18/2013-17:00:47:: i INFO: Initializing AppID to '(Default)' as specified in Configuration file.
library!DefaultDomain!dcc!07/18/2013-17:00:47:: i INFO: Initializing CacheLevel to 'Default' as specified in Configuration file.
resourceutilities!DefaultDomain!dcc!07/18/2013-17:00:47:: i INFO: Reporting Services starting SKU: Standard
configmanager!DefaultDomain!dcc!07/18/2013-17:00:48:: i INFO: Using report server internal url http://localhost:80/ReportServer.
configmanager!DefaultDomain!dcc!07/18/2013-17:00:48:: i INFO: Using report server external url http://APPSSERVER:80/ReportServer.
configmanager!DefaultDomain!dcc!07/18/2013-17:00:48:: i INFO: Using url root http://APPSSERVER:80/ReportServer.
rshost!rshost!dcc!07/18/2013-17:00:48:: i INFO: Configuring maxPhysicalCpu=4, minLogicalCpu=0
rshost!rshost!dcc!07/18/2013-17:00:48:: i INFO: Logical processor per physical processor 1
rshost!rshost!dcc!07/18/2013-17:00:48:: i INFO: Maximum logical CPU is 1
configmanager!DefaultDomain!dcc!07/18/2013-17:00:48:: i INFO: Using report server internal url http://localhost:80/ReportServer.
configmanager!DefaultDomain!dcc!07/18/2013-17:00:48:: i INFO: Using report server external url http://APPSSERVER:80/ReportServer.
configmanager!DefaultDomain!dcc!07/18/2013-17:00:48:: i INFO: Using url root http://APPSSERVER:80/ReportServer.
appdomainmanager!DefaultDomain!dcc!07/18/2013-17:00:48:: i INFO: Appdomain:2 WindowsService_0 started.
resourceutilities!WindowsService_0!dcc!07/18/2013-17:00:48:: i INFO: Reporting Services starting SKU: Standard
library!WindowsService_0!1218!07/18/2013-17:00:48:: i INFO: Catalog SQL Server Edition = Standard
rshost!rshost!1390!07/18/2013-17:00:48:: i INFO: Registered url=http://+:80/ReportServer/, vdir=/ReportServer, pdir=C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer.
rshost!rshost!1390!07/18/2013-17:00:48:: i INFO: Currently registered url http://+:80/ReportServer/ on endpoint 2
crypto!WindowsService_0!1218!07/18/2013-17:00:48:: i INFO: Initializing crypto as user: NT AUTHORITY\SYSTEM
rshost!rshost!1264!07/18/2013-17:00:48:: i INFO: Registered url=http://+:80/Reports/, vdir=/Reports, pdir=C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportManager.
rshost!rshost!1264!07/18/2013-17:00:48:: i INFO: Currently registered url http://+:80/Reports/ on endpoint 3
rshost!rshost!1264!07/18/2013-17:00:48:: i INFO: Endpoint 4 is disabled and no url is registered vdir=/ReportServer/ReportBuilder, pdir=C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\ReportBuilder.
resourceutilities!DefaultDomain!dcc!07/18/2013-17:00:48:: i INFO: Maximum memory limit is 65536Mb
rshost!rshost!dcc!07/18/2013-17:00:48:: i INFO: Derived memory configuration based on physical memory as 8388152 KB
crypto!WindowsService_0!1218!07/18/2013-17:00:48:: i INFO: Exporting public key
servicecontroller!DefaultDomain!1264!07/18/2013-17:00:48:: i INFO: Total Physical memory: 8589467648
rpcserver!DefaultDomain!1390!07/18/2013-17:00:48:: i INFO: Process monitoring started.
crypto!WindowsService_0!1218!07/18/2013-17:00:48:: i INFO: Performing sku validation
crypto!WindowsService_0!1218!07/18/2013-17:00:49:: i INFO: Importing existing encryption key
dbpolling!WindowsService_0!1218!07/18/2013-17:00:49:: i INFO: EventPolling polling service started
dbpolling!WindowsService_0!1014!07/18/2013-17:00:49:: i INFO: HeartbeatThread(EventPolling): heartbeat thread started.
dbpolling!WindowsService_0!1218!07/18/2013-17:00:49:: i INFO: NotificationPolling polling service started
dbpolling!WindowsService_0!8ec!07/18/2013-17:00:49:: i INFO: HeartbeatThread(NotificationPolling): heartbeat thread started.
dbpolling!WindowsService_0!1218!07/18/2013-17:00:49:: i INFO: SchedulePolling polling service started
dbpolling!WindowsService_0!1218!07/18/2013-17:00:49:: i INFO: UpgradePolling polling service started
dbpolling!WindowsService_0!83c!07/18/2013-17:00:49:: i INFO: PollingMaintenance: Polling started
resourceutilities!WindowsService_0!83c!07/18/2013-17:00:49:: i INFO: Maximum memory limit is 65536Mb
rpcserver!DefaultDomain!1218!07/18/2013-17:00:49:: i INFO: RPC Server started.
servicecontroller!DefaultDomain!1218!07/18/2013-17:00:49:: i INFO: RPC Server started. Endpoint name ='ReportingServices$MSRS10_50.MSSQLSERVER'
appdomainmanager!WindowsService_0!1218!07/18/2013-17:00:49:: i INFO: Appdomain:2 WindowsService_0 initialized.
appdomainmanager!DefaultDomain!128c!07/18/2013-17:01:03:: i INFO: Appdomain:3 ReportManager_MSSQLSERVER_0-1-130186044634309801 started.
appdomainmanager!ReportManager_0-1!128c!07/18/2013-17:01:03:: i INFO: RS authentication mode is 5; effective ASP.NET authentication mode is Windows. vdir=/Reports.
appdomainmanager!DefaultDomain!128c!07/18/2013-17:01:03:: i INFO: Appdomain:3 ReportManager_MSSQLSERVER_0-1-130186044634309801 initialized (#1).
appdomainmanager!DefaultDomain!1040!07/18/2013-17:01:06:: i INFO: Appdomain:4 ReportServer_MSSQLSERVER_0-2-130186044667129637 started.
appdomainmanager!ReportServer_0-2!1040!07/18/2013-17:01:07:: i INFO: RS authentication mode is 5; effective ASP.NET authentication mode is Windows. vdir=/ReportServer.
appdomainmanager!DefaultDomain!1040!07/18/2013-17:01:07:: i INFO: Appdomain:4 ReportServer_MSSQLSERVER_0-2-130186044667129637 initialized (#1).
webserver!ReportServer_0-2!1040!07/18/2013-17:01:13:: i INFO: Reporting Web Server started
resourceutilities!ReportServer_0-2!1040!07/18/2013-17:01:13:: i INFO: Reporting Services starting SKU: Standard
resourceutilities!ReportServer_0-2!1040!07/18/2013-17:01:13:: i INFO: Maximum memory limit is 65536Mb
library!ReportServer_0-2!d10!07/18/2013-17:01:15:: Call to GetPermissionsAction(/Demo/BrokerCENTRAL).
library!ReportServer_0-2!d10!07/18/2013-17:01:15:: i INFO: Catalog SQL Server Edition = Standard
crypto!ReportServer_0-2!d10!07/18/2013-17:01:15:: i INFO: Initializing crypto as user: NT AUTHORITY\SYSTEM
crypto!ReportServer_0-2!d10!07/18/2013-17:01:15:: i INFO: Exporting public key
crypto!ReportServer_0-2!d10!07/18/2013-17:01:15:: i INFO: Performing sku validation
crypto!ReportServer_0-2!d10!07/18/2013-17:01:15:: i INFO: Importing existing encryption key
library!ReportServer_0-2!13d4!07/18/2013-17:01:15:: Call to GetSystemPermissionsAction().
library!ReportServer_0-2!1040!07/18/2013-17:01:16:: Call to GetSystemPropertiesAction().
library!ReportServer_0-2!13d4!07/18/2013-17:01:16:: Call to GetDataSourceContentsAction(/Demo/BrokerCENTRAL).
library!ReportServer_0-2!1040!07/18/2013-17:01:16:: Call to GetPropertiesAction(/Demo/BrokerCENTRAL, PathBased).
library!ReportServer_0-2!1040!07/18/2013-17:01:16:: Call to ListChildrenAction(/, False).
library!ReportServer_0-2!13d4!07/18/2013-17:01:16:: Call to ListChildrenAction(/Demo, False).
library!ReportServer_0-2!1224!07/18/2013-17:01:16:: Call to ListChildrenAction(/, False).
library!ReportServer_0-2!13d4!07/18/2013-17:01:16:: Call to ListChildrenAction(/Demo, False).
library!ReportServer_0-2!1224!07/18/2013-17:01:16:: Call to GetSystemPropertiesAction().
library!ReportManager_0-1!f1c!07/18/2013-17:01:29:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeInternalException: RsWorkerRequest::ReadEntityBody., Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeInternalException: An internal or system error occurred in the HTTP Runtime object for application domain ReportManager_MSSQLSERVER_0-1-130186044634309801. ---> System.InvalidCastException: Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.ReportingServices.HostingInterfaces.IRsHttpPipeline'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{07101601-428B-42DA-896A-7AE29CC5A777}' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)).
at Microsoft.ReportingServices.HostingInterfaces.IRsHttpPipeline.ReadEntityBody(Byte[] buffer, Int32 offset, Int32 size)
at ReportingServicesHttpRuntime.RsWorkerRequest.ReadEntityBody(Byte[] buffer, Int32 offset, Int32 size)
--- End of inner exception stack trace ---;
ui!ReportManager_0-1!f1c!07/18/2013-17:01:29:: e ERROR: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeInternalException: An internal or system error occurred in the HTTP Runtime object for application domain ReportManager_MSSQLSERVER_0-1-130186044634309801. ---> System.InvalidCastException: Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.ReportingServices.HostingInterfaces.IRsHttpPipeline'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{07101601-428B-42DA-896A-7AE29CC5A777}' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)).
library!ReportServer_0-2!1224!07/18/2013-17:01:29:: Call to GetSystemPermissionsAction().
ui!ReportManager_0-1!f1c!07/18/2013-17:01:29:: e ERROR: HTTP status code --> 500
-------Details--------
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeInternalException: An internal or system error occurred in the HTTP Runtime object for application domain ReportManager_MSSQLSERVER_0-1-130186044634309801. ---> System.InvalidCastException: Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.ReportingServices.HostingInterfaces.IRsHttpPipeline'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{07101601-428B-42DA-896A-7AE29CC5A777}' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)).
library!ReportServer_0-2!1040!07/18/2013-17:01:29:: Call to GetSystemPropertiesAction().
ui!ReportManager_0-1!f1c!07/18/2013-17:01:29:: e ERROR: 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)
library!ReportManager_0-1!f1c!07/18/2013-17:01:33:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeInternalException: RsWorkerRequest::ReadEntityBody., Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeInternalException: An internal or system error occurred in the HTTP Runtime object for application domain ReportManager_MSSQLSERVER_0-1-130186044634309801. ---> System.InvalidCastException: Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.ReportingServices.HostingInterfaces.IRsHttpPipeline'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{07101601-428B-42DA-896A-7AE29CC5A777}' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)).
at Microsoft.ReportingServices.HostingInterfaces.IRsHttpPipeline.ReadEntityBody(Byte[] buffer, Int32 offset, Int32 size)
at ReportingServicesHttpRuntime.RsWorkerRequest.ReadEntityBody(Byte[] buffer, Int32 offset, Int32 size)
--- End of inner exception stack trace ---;
ui!ReportManager_0-1!f1c!07/18/2013-17:01:33:: e ERROR: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeInternalException: An internal or system error occurred in the HTTP Runtime object for application domain ReportManager_MSSQLSERVER_0-1-130186044634309801. ---> System.InvalidCastException: Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.ReportingServices.HostingInterfaces.IRsHttpPipeline'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{07101601-428B-42DA-896A-7AE29CC5A777}' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)).
library!ReportServer_0-2!1224!07/18/2013-17:01:33:: Call to GetSystemPermissionsAction().
ui!ReportManager_0-1!f1c!07/18/2013-17:01:33:: e ERROR: HTTP status code --> 500
-------Details--------
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeInternalException: An internal or system error occurred in the HTTP Runtime object for application domain ReportManager_MSSQLSERVER_0-1-130186044634309801. ---> System.InvalidCastException: Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.ReportingServices.HostingInterfaces.IRsHttpPipeline'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{07101601-428B-42DA-896A-7AE29CC5A777}' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)).
library!ReportServer_0-2!1040!07/18/2013-17:01:33:: Call to GetSystemPropertiesAction().
ui!ReportManager_0-1!f1c!07/18/2013-17:01:33:: e ERROR: 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)
library!ReportServer_0-2!1224!07/18/2013-17:01:36:: Call to GetPermissionsAction(/).
library!ReportServer_0-2!d10!07/18/2013-17:01:36:: Call to GetPropertiesAction(/, PathBased).
library!ReportServer_0-2!13d4!07/18/2013-17:01:36:: Call to GetPropertiesAction(/, PathBased).
library!ReportServer_0-2!13d4!07/18/2013-17:01:36:: Call to GetSystemPermissionsAction().
library!ReportServer_0-2!1224!07/18/2013-17:01:36:: Call to ListChildrenAction(/, False).
library!ReportServer_0-2!13d4!07/18/2013-17:01:36:: Call to GetSystemPropertiesAction().
library!ReportServer_0-2!d10!07/18/2013-17:01:36:: Call to GetSystemPropertiesAction().
library!ReportServer_0-2!d10!07/18/2013-17:01:36:: Call to GetSystemPropertiesAction().

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

Hope someone could help me with this. Have no idea what to do. Much thanks in advance.
Post #1474916
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse