Error in System Log: "The SQL Server Analysis Services (xxxxxx) service terminated unexpectedly. It has done this x time(s)."

  • My SSAS service stopped twice today with this message in the System Log:

    The SQL Server Analysis Services (xxxxxx) service terminated unexpectedly. It has done this x time(s).

    How can I troubleshoot this?

    (I'm on SQL 2008 SP1).

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

  • Here is what's on the SQLDUMPER_ERRORLOG.log file:

    (1158:1718) 04/06/10 09:05:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied

    (1158:1718) 04/06/10 09:05:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parameter 1: 1908

    (1158:1718) 04/06/10 09:05:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parameter 2: 0

    (1158:1718) 04/06/10 09:05:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parameter 3: 0:0

    (1158:1718) 04/06/10 09:05:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parameter 4: 0000000003585A90

    (1158:1718) 04/06/10 09:05:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parsed parameters:

    (1158:1718) 04/06/10 09:05:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 1908

    (1158:1718) 04/06/10 09:05:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0

    (1158:1718) 04/06/10 09:05:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0

    (1158:1718) 04/06/10 09:05:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0

    (1158:1718) 04/06/10 09:05:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x0000000003585A90

    (1158:1718) 04/06/10 09:05:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>

    (1158:1718) 04/06/10 09:05:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x0000000000000000

    (1158:1718) 04/06/10 09:05:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x0000000000000000

    (1158:1718) 04/06/10 09:05:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>

    (1158:1718) 04/06/10 09:05:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL>

    (1158:1718) 04/06/10 09:05:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>

    (1158:1718) 04/06/10 09:05:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Threads processed: 60

    (1158:1718) 04/06/10 09:05:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used

    (1158:1718) 04/06/10 09:05:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 15 not used

    (1158:1718) 04/06/10 09:05:18, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used

    (1158:1718) 04/06/10 09:05:18, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: G:\SQL\MSAS10.xxxxxx\OLAP\Log\SQLDmpr0002.mdmp

    (1158:1718) 04/06/10 09:05:18, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Location of module 'dbghelp.dll' : 'C:\Program Files\Microsoft SQL Server\100\Shared\dbghelp.dll'

    (1158:1718) 04/06/10 09:05:18, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, File version of module 'C:\Program Files\Microsoft SQL Server\100\Shared\dbghelp.dll' : '6.8:4.0'

    (1158:1718) 04/06/10 09:05:18, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Product version of module 'C:\Program Files\Microsoft SQL Server\100\Shared\dbghelp.dll' : '6.8:4.0'

    (1158:1718) 04/06/10 09:05:18, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Location of module 'sqldumper.exe' : 'C:\Program Files\Microsoft SQL Server\100\Shared\SQLDUMPER.EXE'

    (1158:1718) 04/06/10 09:05:18, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, File version of module 'C:\Program Files\Microsoft SQL Server\100\Shared\SQLDUMPER.EXE' : '2007.100:1600.22'

    (1158:1718) 04/06/10 09:05:18, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Product version of module 'C:\Program Files\Microsoft SQL Server\100\Shared\SQLDUMPER.EXE' : '10.0:1600.22'

    (1158:1718) 04/06/10 09:05:19, ACTION, msmdsrv.exe, Watson Invoke: No

    (112C:1738) 04/06/10 12:09:24, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied

    (112C:1738) 04/06/10 12:09:24, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parameter 1: 1316

    (112C:1738) 04/06/10 12:09:24, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parameter 2: 0

    (112C:1738) 04/06/10 12:09:24, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parameter 3: 0:0

    (112C:1738) 04/06/10 12:09:24, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parameter 4: 0000000003585A90

    (112C:1738) 04/06/10 12:09:24, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parsed parameters:

    (112C:1738) 04/06/10 12:09:24, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 1316

    (112C:1738) 04/06/10 12:09:24, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0

    (112C:1738) 04/06/10 12:09:24, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0

    (112C:1738) 04/06/10 12:09:24, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0

    (112C:1738) 04/06/10 12:09:24, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x0000000003585A90

    (112C:1738) 04/06/10 12:09:24, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>

    (112C:1738) 04/06/10 12:09:24, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x0000000000000000

    (112C:1738) 04/06/10 12:09:24, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x0000000000000000

    (112C:1738) 04/06/10 12:09:24, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>

    (112C:1738) 04/06/10 12:09:24, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL>

    (112C:1738) 04/06/10 12:09:24, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>

    (112C:1738) 04/06/10 12:09:24, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Threads processed: 35

    (112C:1738) 04/06/10 12:09:24, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used

    (112C:1738) 04/06/10 12:09:24, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 15 not used

    (112C:1738) 04/06/10 12:09:24, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used

    (112C:1738) 04/06/10 12:09:24, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: G:\SQL\MSAS10.xxxxxx\OLAP\Log\SQLDmpr0003.mdmp

    (112C:1738) 04/06/10 12:09:24, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Location of module 'dbghelp.dll' : 'C:\Program Files\Microsoft SQL Server\100\Shared\dbghelp.dll'

    (112C:1738) 04/06/10 12:09:24, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, File version of module 'C:\Program Files\Microsoft SQL Server\100\Shared\dbghelp.dll' : '6.8:4.0'

    (112C:1738) 04/06/10 12:09:24, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Product version of module 'C:\Program Files\Microsoft SQL Server\100\Shared\dbghelp.dll' : '6.8:4.0'

    (112C:1738) 04/06/10 12:09:24, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Location of module 'sqldumper.exe' : 'C:\Program Files\Microsoft SQL Server\100\Shared\SQLDUMPER.EXE'

    (112C:1738) 04/06/10 12:09:24, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, File version of module 'C:\Program Files\Microsoft SQL Server\100\Shared\SQLDUMPER.EXE' : '2007.100:1600.22'

    (112C:1738) 04/06/10 12:09:24, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Product version of module 'C:\Program Files\Microsoft SQL Server\100\Shared\SQLDUMPER.EXE' : '10.0:1600.22'

    (112C:1738) 04/06/10 12:09:24, ACTION, msmdsrv.exe, Watson Invoke: No

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply