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