Question Locked

How to interpret and decypher .mdmp and .log files from SQLDmpr.

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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?

2 replies

by oldbaritone

Create a boolean global called "Debug".

Where you think the program may be going astray, insert some "if (Debug) {}" output statements.

Good places are at the top and bottom of methods - at the top, "if (Debug) {write "Object.Method starting"}" and at the end of it, put "if (Debug) {write "Object.Method returned "&&(return-value))"

It's a lot easier to follow your program logic that way, and when you isolate the routine with the problem, add more "if (Debug)" calls in that routine to figure it out.

Then just set "Debug" to false and run it again.

When it's all debugged, do a global replace of "if (Debug)" with "# if (Debug)" and they all go away.

This is MUCH easier than trying to figure out "Core Dumps" - because YOU control what is relevant, in a way you can understand.

When you get something you don't understand, just add more information or more Debug lines until you get something you do understand.

If you're like most of us, when you figure it out, you'll say "MAAAAANNNN... How could I possibly have missed THAT?"

Been there, done that, got a tee shirt, don't need another tee shirt...

;-)

h

This discussion is closed to new replies.