I have the task of tracking down and determining why a server running SQL Server 2005 and SSRS is creating hundreds of SQLDmpr{sequential number}.mdmp, SQLDmpr{sequential number}.log, SQLDmpr and {sequential number}.mft files. These files are listed in the SQLDUMPER_LOG.log file along with other information.
The SQLDmpr6721.mft file reads:
Version=131072
General_AppName=w3wp.exe
UI LCID=1033
EventType=SQL90Exception
P1=w3wp.exe
P2=6.0.3790.3959
P3=45D6968E
P4=SQLDUMPER_UNKNOWN_MODULE.DLL
P5=0.0.0.0
P6=00000000
P7=0
P8=109C724D
P9=00000000
FilesToKeep=c:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\LogFiles\SQLDmpr6721.mft|c:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\LogFiles\SQLDmpr6814.mdmp|c:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\LogFiles\SQLDmpr6814.log
ReportingFlags=370
UIFlags=1
LoggingFlags=4
EventLogSource=SQLDUMPER
SQLDmpr6814.log snippet (there are many lines to this log):
w3wp!library!1!03/30/2010-17:46:42:: i INFO: Exception dumped to: c:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
w3wp!library!6!03/30/2010-17:46:42:: 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.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.WebServer.WebServiceHelper.ConstructRSServiceObjectFromSecurityExtension()
at Microsoft.ReportingServices.WebServer.Global.ConstructRSServiceFromRequest(String item)
at Microsoft.ReportingServices.WebServer.Global.get_Service()
at Microsoft.ReportingServices.WebServer.Global.DispatchRequest()
at Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e)
— End of inner exception stack trace —
w3wp!library!6!03/30/2010-17:46:46:: i INFO: Exception dumped to: c:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
w3wp!library!6!03/30/2010-17:46:46:: 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.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.WebServer.WebServiceHelper.ConstructRSServiceObjectFromSecurityExtension()
at Microsoft.ReportingServices.WebServer.Global.ConstructRSServiceFromRequest(String item)
at Microsoft.ReportingServices.WebServer.Global.get_Service()
at Microsoft.ReportingServices.WebServer.Global.DispatchRequest()
at Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e)
— End of inner exception stack trace —
In this log there are listings of a particular report, which I run to see if it generates an error. It does not.
w3wp!library!6!03/30/2010-17:41:12:: i INFO: Call to RenderNext( ‘/AKAIMS Reports/AKAIMS Agency Reports/Staff Productivity/Staff Productivity – Chart’ )
w3wp!cache!6!03/30/2010-17:41:12:: i INFO: Session live: /AKAIMS Reports/AKAIMS Agency Reports/Staff Productivity/Staff Productivity – Chart
w3wp!webserver!6!03/30/2010-17:41:12:: i INFO: Processed report. Report=’/AKAIMS Reports/AKAIMS Agency Reports/Staff Productivity/Staff Productivity – Chart’, Stream=”
w3wp!library!1!03/30/2010-17:42: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.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.WebServer.WebServiceHelper.ConstructRSServiceObjectFromSecurityExtension()
at Microsoft.ReportingServices.WebServer.Global.ConstructRSServiceFromRequest(String item)
at Microsoft.ReportingServices.WebServer.Global.get_Service()
at Microsoft.ReportingServices.WebServer.Global.DispatchRequest()
at Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e)
— End of inner exception stack trace —
SQLDUMPER_ERRORLOG.log yields:
03/30/10 17:46:46, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied
03/30/10 17:46:46, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 2492
03/30/10 17:46:46, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0
03/30/10 17:46:46, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0
03/30/10 17:46:46, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0
03/30/10 17:46:46, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x10465860
03/30/10 17:46:46, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir =
03/30/10 17:46:46, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x00000000
03/30/10 17:46:46, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x00000000
03/30/10 17:46:46, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile =
03/30/10 17:46:46, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName =
03/30/10 17:46:46, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName =
03/30/10 17:46:46, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used
03/30/10 17:46:46, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 15 not used
03/30/10 17:46:50, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
03/30/10 17:46:50, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: c:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\LogFiles\SQLDmpr6814.mdmp
03/30/10 17:46:50, ACTION, w3wp.exe, Watson Invoke: Yes
03/30/10 17:46:50, ACTION, w3wp.exe, Watson Invoked: c:\PROGRA~1\COMMON~1\MICROS~1\DW\DW20.EXE dw20.exe -d “c:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\LogFiles\SQLDmpr6721.mft”
Where can I look to decypher these files and logs? Is there anything else that I need to look to determine where the error is and why it is dumping the memory to a .mdmp file several times a day?
