InternalCatalogException: An internal error occurred on the report server.
Hi All We have a Microsoft System Center Operations Manager setup. Our SCOM Report Server which uses SQL Server Reporting Service is having this error in the log file: "InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.ServiceModel.FaultException: The creator of this fault did not specify a Reason." That is, we are not able to go to our https://servname/ReportServer at all. Got an Internal Error page. We are using SCOM 2007 R2 on Windows 2003 SP2 64bit, SQL Server 2005 SP2 64bit. Our SQL Server Reporting Service Configuration seems to be okay, as we can connect to the report server there. We had posted this problem to the SCOM forum but were asked to post here as this looks like a SQL Reporting Service issue. We also tried the /usepmtimer in our boot.ini even though our machine is using Intel Xeon processor and not AMD. Can anybody advise how to fix this problem? Thank you very much in anticipation. cmgui In the SQLDUMPER_ERRORLOG.log file, we have this: 07/14/11 06:59:47, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied 07/14/11 06:59:47, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 3692 07/14/11 06:59:47, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0 07/14/11 06:59:47, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0 07/14/11 06:59:47, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0 07/14/11 06:59:47, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x000000004740F608 07/14/11 06:59:47, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL> 07/14/11 06:59:47, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x0000000000000000 07/14/11 06:59:47, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x0000000000000000 07/14/11 06:59:47, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL> 07/14/11 06:59:47, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL> 07/14/11 06:59:47, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL> 07/14/11 06:59:48, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used 07/14/11 06:59:48, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 15 not used 07/14/11 06:59:51, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used 07/14/11 06:59:51, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: c:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\LogFiles\SQLDmpr0180.mdmp 07/14/11 06:59:51, ACTION, w3wp.exe, Watson Invoke: No --- more from the SQLDmprxxx.log file: w3wp!library!7!07/14/2011-06:59:47:: Call to ListChildrenAction(/Microsoft.Exchange.Server.2003.Monitoring, False). w3wp!library!7!07/14/2011-06:59:47:: Call to ListChildrenAction(/Microsoft.Exchange.Server.2007.Reports, False). w3wp!library!6!07/14/2011-06:59:47:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.ServiceModel.FaultException: The creator of this fault did not specify a Reason. Server stack trace: at System.ServiceModel.Channels.ServiceChannel.HandleReply(ProxyOperationRuntime operation, ProxyRpc& rpc) at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout) at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation) at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message) Exception rethrown at [0]: at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg) at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type) at Microsoft.EnterpriseManagement.Common.ISecuritySpaceDataAccess.GetUserRolesForOperationAndUser(Guid operationId, String userName) at Microsoft.EnterpriseManagement.Reporting.Security.ManagementGroupConnection.GetReportingUser(String userName) at Microsoft.EnterpriseManagement.Reporting.Security.GroupAuthorization.CheckAccess(String userName, Byte[] secDesc, RequiredOperation requiredOperation) at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType catItemType, Byte[] secDesc, FolderOperation fldOper, String folderPath) at Microsoft.ReportingServices.Library.GetItemTypeAction.PerformActionNow() at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute() --- End of inner exception stack trace --- w3wp!library!7!07/14/2011-06:59:47:: Call to ListChildrenAction(/Microsoft.SQLServer.2000.Monitoring, False). w3wp!library!8!07/14/2011-06:59:47:: Call to ListChildrenAction(/Microsoft.SQLServer.2005.Monitoring, False). w3wp!library!7!07/14/2011-06:59:48:: Call to ListChildrenAction(/Microsoft.SQLServer.2008.Monitoring, False). w3wp!library!1!07/14/2011-06:59:51:: Call to ListChildrenAction(/Microsoft.SystemCenter.ClientMonitoring.Views.Internal, False).
July 15th, 2011 5:11pm

Hi cm_gui, Thanks for your question. Based on my research and past experiences, it seems like a permissions problem. Please help me collect the answers of these questions. 1. Can you open the Report Manager? 2. Can you restart the Reporting Services in Reporting Services Configuration Manager? 3. Is there any mistake about the Service Account? For example, the password of the Account had expired or the Kerberos authentication error of this error. Please let me know the results of previous questions. Thanks, Sharp Wang Please remember to mark the replies as answers if they help you and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
July 18th, 2011 4:58am

Hi cm_gui, Thanks for your question. Based on my research and past experiences, it seems like a permissions problem. Please help me collect the answers of these questions. 1. Can you open the Report Manager? 2. Can you restart the Reporting Services in Reporting Services Configuration Manager? 3. Is there any mistake about the Service Account? For example, the password of the Account had expired or the Kerberos authentication error of this error. Please let me know the results of previous questions. Thanks, Sharp Wang Please remember to mark the replies as answers if they help you and unmark them if they provide no help. Hi Sharp Wang Thank you for offering to help. 1) By Report Manager, do you mean http://server/ReportServer or http://server/Reports ? Anyway, we are not able to go to both sites. The error pages we get are shown below. 2) Yes, I am able to restart Reporting Services in the Reporting Services Configuration Manager. 3) By Service Account, do you mean the Logon as user account to start SQL Server Reporting Services in Control Panel->Administrative Tools->Services? The Logon as user account and its password are correct. The password did not expire as I reset it recently. The details of the other accounts in Reporting Services Configuration Manager are listed below. Thank you once again. Cmgui ---- Reporting Services Configuration Manager Server status Instance Name: MSSQLSERVER Instance ID: MSSQL.2 Initialized: Yes Service Status: Running Report Server Virtual Directory Settings Name: ReportServer Website: Default Web Site Report Manager Virtual Directory Name: Reports Website: Default Web Site Windows Service Identity Service Name: ReportServer Service Account: OurDomain\Data_Reader Windows Account - selected Account: OurDomain\Data_Reader Web Service Identity ASP .NET Service Account: OurDomain\Data_Reader Report Server: ReportServer Report Manager: ReportServer Database Setup Server Name: OurMachineName Database Name: ReportServer Database Version: C.0.8.54 ServerMode: Native Credentials Type: Service Credentials Execution Account Specify an execution account - selected Account: OurDomain\Data_Reader === In the IIS Application Pools' ReportServer Properties->Identity, Configurable is selected. User name: OurDomain\Data_Reader ---- When I go to http://server/ReportServer, I get this error Reporting Services Error An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help. The Creator of this fault did not specify a Reason. SQL Server Reporting Services. When I go to http://server/Reports, I get this error page: Server Error in '/Reports' Application. -------------------------------------------------------------------------------- Could not load file or assembly 'ReportingServicesWebServer' or one of its dependencies. The system cannot find the file specified. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.IO.FileNotFoundException: Could not load file or assembly 'ReportingServicesWebServer' or one of its dependencies. The system cannot find the file specified. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Assembly Load Trace: The following information can be helpful to determine why the assembly 'ReportingServicesWebServer' could not be loaded. WRN: Assembly binding logging is turned OFF. To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1. Note: There is some performance penalty associated with assembly bind failure logging. To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog]. Stack Trace: [FileNotFoundException: Could not load file or assembly 'ReportingServicesWebServer' or one of its dependencies. The system cannot find the file specified.] System.Reflection.Assembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection) +0 System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection) +465 System.Reflection.Assembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection) +181 System.Reflection.Assembly.Load(String assemblyString) +42 System.Web.Configuration.CompilationSection.LoadAssemblyHelper (String assemblyName, Boolean starDirective) +190 [ConfigurationErrorsException: Could not load file or assembly 'ReportingServicesWebServer' or one of its dependencies. The system cannot find the file specified.] System.Web.Configuration.CompilationSection.LoadAssemblyHelper (String assemblyName, Boolean starDirective) +3650888 System.Web.Configuration.CompilationSection.LoadAssembly(Asse mblyInfo ai) +245 System.Web.Configuration.AssemblyInfo.get_AssemblyInternal() +36 System.Web.Compilation.BuildManager.GetReferencedAssemblies(C ompilationSection compConfig) +235 System.Web.Compilation.BuildProvidersCompiler..ctor(VirtualPath configPath, Boolean supportLocalization, String outputAssemblyName) +76 System.Web.Compilation.ApplicationBuildProvider.GetGlobalAsaxB uildResult(Boolean isPrecompiledApp) +2952796 System.Web.Compilation.BuildManager.CompileGlobalAsax() +63 System.Web.Compilation.BuildManager.EnsureTopLevelFilesCompil ed() +757 [HttpException (0x80004005): Could not load file or assembly 'ReportingServicesWebServer' or one of its dependencies. The system cannot find the file specified.] System.Web.Compilation.BuildManager.ReportTopLevelCompilation Exception() +79 System.Web.Compilation.BuildManager.EnsureTopLevelFilesCompil ed() +2952376 System.Web.Hosting.HostingEnvironment.Initialize(ApplicationMana ger appManager, IApplicationHost appHost, IConfigMapPathFactory configMapPathFactory, HostingEnvironmentParameters hostingParameters) +1163 [HttpException (0x80004005): Could not load file or assembly 'ReportingServicesWebServer' or one of its dependencies. The system cannot find the file specified.] System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +2745191 System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +88 System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerReques t wr) +2745101 -------------------------------------------------------------------------------- Version Information: Microsoft .NET Framework Version:2.0.50727.1882; ASP.NET Version:2.0.50727.1887
July 20th, 2011 12:23am

Hi cm_gui, Thanks for your question and Jeff’s reply. According to your description through the thread, the issue may be not in report server side. As we know, for SSRS is 2005, the website of Report Manager and reportserver should being replied on the IIS. Based on my research and past experiences, I would suggest you try to recycle the Application Pool of Reporting Services in the IIS. By default, please follow below steps: 1. Click Start, All programs, Administrative Tools, Internet Information Services (IIS) Manager. 2. In the dialog box of Internet Information Services (IIS) Manager, in the left pane, expand the Application Pools, right-click the node of ReportServer, select and click Recycle. Hope it helps you. If your issue still exists, please feel free to let me know. Thanks, Sharp Wang Please remember to mark the replies as answers if they help you and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
July 28th, 2011 2:44am

Thank you Sharp Wang. I tried the Recycle of the ReportServer application pool in IIS as per your suggestion and it didn't work. Actually, I had also re-installed SQL Reporting Services and SCOM Report Server and am now getting new errors. I posted the errors here: http://social.technet.microsoft.com/Forums/en-US/operationsmanagerreporting/thread/16a179da-6822-48ac-92db-896d52971ff8 Not sure if it is SCOM related or SQL related.
July 29th, 2011 10:07am

Resolved by reinstalling SQL Reporting and SCOM report server -- as per http://stuartrenes.wordpress.com/2009/06/03/how-to-reinstall-system-center-operations-manager-reporting/
Free Windows Admin Tool Kit Click here and download it now
July 30th, 2011 2:28am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics