The SQL Server Analysis Services (MSSQLSERVER) service terminated unexpectedly.

240 pts.
Tags:
SQL Server 2008
SQL Server Analysis Services
Windows Server 2008
We have installed sql server 2008 (64 bit) on windows server 2008 enterprise edition, in which around 10 jobs to populate the dimensions from relational db to analysis cubes. I am frequently facing the same error and the services gets stopped. "The SQL Server Analysis Services (MSSQLSERVER) service terminated unexpectedly. It has done this 1 time(s)." when i try to restart the analysis services, in next few minutes the service gets disabled.I tried disabling the sql service and disabling the agent jobs which indicates the dawaflow will be stopped. I have enough memory and cpu resources. Can any one pour some inputs to solve the issue. Thanks..

Answer Wiki

Thanks. We'll let you know when a new response is added.

What does it say in the log file for analysis services and in the application log?

Discuss This Question: 10  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • GIG
    In application log, i could see the below message. The description for Event ID 22 from source MSSQLServerOLAPService cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer. If the event originated on another computer, the display information had to be saved with the event. The following information was included with the event: Internal error: An unexpected exception occurred. the message resource is present but the message is not found in the string/message table System log: "The SQL Server Analysis Services (MSSQLSERVER) service terminated unexpectedly. It has done this 1 time(s)." Thinking this is like a RTM bug, i have cleared all the db's and the cubes in the analysis services and restarted the service. I did not face any problem for 16 hrs. Then again, I have re processed my cube and in next 2 minutes i could see the same error in the event and the application log and nothing releated to analysis services in the sql log.
    240 pointsBadges:
    report
  • Denny Cherry
    There won't be anything about analysis services in the SQL Server log. The SSAS service should have its own log file that it is writing to. It should be in the log folder under the folder which contains the binaries for SSAS.
    66,085 pointsBadges:
    report
  • GIG
    Thanks Mr Denny Please help me if you have any idea...I could not sort out the problem, for which i am spending a lot of time. The error in the log file (sql dumper error log file) which is recursive every 15-20 minutes. I can see many crash dump files (1468:1AFC) 10/31/08 09:02:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied (1468:1AFC) 10/31/08 09:02:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parameter 1: 7900 (1468:1AFC) 10/31/08 09:02:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parameter 2: 0 (1468:1AFC) 10/31/08 09:02:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parameter 3: 0:0 (1468:1AFC) 10/31/08 09:02:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parameter 4: 0000000002A5F730 (1468:1AFC) 10/31/08 09:02:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parsed parameters: (1468:1AFC) 10/31/08 09:02:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 7900 (1468:1AFC) 10/31/08 09:02:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0 (1468:1AFC) 10/31/08 09:02:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0 (1468:1AFC) 10/31/08 09:02:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0 (1468:1AFC) 10/31/08 09:02:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x0000000002A5F730 (1468:1AFC) 10/31/08 09:02:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL> (1468:1AFC) 10/31/08 09:02:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x0000000000000000 (1468:1AFC) 10/31/08 09:02:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x0000000000000000 (1468:1AFC) 10/31/08 09:02:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL> (1468:1AFC) 10/31/08 09:02:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL> (1468:1AFC) 10/31/08 09:02:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL> (1468:1AFC) 10/31/08 09:02:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Threads processed: 49 (1468:1AFC) 10/31/08 09:02:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used (1468:1AFC) 10/31/08 09:02:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 15 not used (1468:1AFC) 10/31/08 09:02:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used (1468:1AFC) 10/31/08 09:02:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:\Program Files\Microsoft SQL Server\MSAS10.MSSQLSERVER\OLAP\Log\SQLDmpr0402.mdmp (1468:1AFC) 10/31/08 09:02:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Location of module 'dbghelp.dll' : 'C:\Program Files\Microsoft SQL Server\100\Shared\dbghelp.dll' (1468:1AFC) 10/31/08 09:02:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, File version of module 'C:\Program Files\Microsoft SQL Server\100\Shared\dbghelp.dll' : '6.8:4.0' (1468:1AFC) 10/31/08 09:02:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Product version of module 'C:\Program Files\Microsoft SQL Server\100\Shared\dbghelp.dll' : '6.8:4.0' (1468:1AFC) 10/31/08 09:02:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Location of module 'sqldumper.exe' : 'C:\Program Files\Microsoft SQL Server\100\Shared\SQLDUMPER.EXE' (1468:1AFC) 10/31/08 09:02:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, File version of module 'C:\Program Files\Microsoft SQL Server\100\Shared\SQLDUMPER.EXE' : '2007.100:1600.22' (1468:1AFC) 10/31/08 09:02:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Product version of module 'C:\Program Files\Microsoft SQL Server\100\Shared\SQLDUMPER.EXE' : '10.0:1600.22' (1468:1AFC) 10/31/08 09:02:14, ACTION, msmdsrv.exe, Watson Invoke: No
    240 pointsBadges:
    report
  • Denny Cherry
    Can you look in the files C:\Program Files\Microsoft SQL Server\MSAS10.MSSQLSERVER\OLAP\Log\SQLDmpr0402.* and post anything which might be useful? I would also recommend downloading and installing first hot fix for SQL Server and see if that helps any.
    66,085 pointsBadges:
    report
  • GIG
    I have applied the hot fix, but did not solve the problem. I could see "starting in: (infinite)+" in the log. I am just selecting the max date from a table here... I am not sure why this is going wrong, this runs fine in 2005. I think there should be something else in the log which is missing. Also how to change the language in the log. I could see only english in the log, how to change this option. I have looked in the properties> of analysis services, it shows only english, but my log is a combination of english and a different language Thanks..
    240 pointsBadges:
    report
  • GIG
    Processing of the 'shipment' cube has started.. Processing of the ''shipment' measure group has started. Finished building processing schedule. Starting to write data of the ''shipment_INCR_UPDATE_TEMP_goot4_' partition. The job completed with failure. Internal error: The operation terminated unsuccessfully. Internal error: The operation terminated unsuccessfully. Internal error: An unexpected exception occurred. Errors in the OLAP storage engine: An error occurred while processing the ''shipment_INCR_UPDATE_TEMP_goot4_' partition of the ''shipment' measure group for the ''shipment' cube from the ISOS database. Server: The operation has been cancelled.
    240 pointsBadges:
    report
  • GIG
    The message is from profiler: Processing of the ’shipment’ cube has started.. Processing of the ‘’shipment’ measure group has started. Finished building processing schedule. Starting to write data of the ‘’shipment_INCR_UPDATE_TEMP_goot4_’ partition. The job completed with failure. Internal error: The operation terminated unsuccessfully. Internal error: The operation terminated unsuccessfully. Internal error: An unexpected exception occurred. Errors in the OLAP storage engine: An error occurred while processing the ‘’shipment_INCR_UPDATE_TEMP_goot4_’ partition of the ‘’shipment’ measure group for the ‘’shipment’ cube from the ISOS database. Server: The operation has been cancelled. The cube will not be processed. When i try to manually process the cube, the cube will be processed sucessfully. I think the problem is with the pro active caching also.This fails when it tries to cache the data and while dealing with the partition. we use a xmla to process the cube, we create daily cubes based on the this xmla. In which we have a option of pro cative caching for every three minutes. Thanks for any help.
    240 pointsBadges:
    report
  • Denny Cherry
    As you are getting a storage engine error I would recommend opening a case with PSS at Microsoft. It sounds like you may have found a bug in the SSAS engine. If you don't want to open a case you should at least report the issue to Microsoft on the connect website http://connect.microsoft.com.
    66,085 pointsBadges:
    report
  • GIG
    Thanks MrDenny for following up my question. I have raised as a bug in microsoft. I will update you once i get the feedback from microsoft.
    240 pointsBadges:
    report
  • XSteady
    I have the same problem. Is there any solution from Microsoft?
    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following