OLAP Service Shuts Down

For the last couple months, every several days the OLAP service will just shut down. For the few hours before it does, we receive the following message box:
Photo Sharing and Video Hosting at Photobucket

The description for Event ID ( 22 ) in Source ( MSSQLServerOLAPService ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Internal error: An unexpected exception occured..

Why this keeps happening, I have no idea. I’ve tried it on multiple servers and still receive the error.


This entry was posted in Uncategorized. Bookmark the permalink.

2 Responses to OLAP Service Shuts Down

  1. Dan Meyers says:

    There is usually a dump file associated with the crashes in the OLAP\\Logs folder in the Program Files directory for SQL Server 2005.  If there is nothing else in the system logs that will help you you could send this off to Microsft and they could probably tell what was going on at the time of the crash. 
    I just had a scenario  where I created calculated member in ProClarity that used the NONEMPTY() function and a crossjoin and everytime I ran the query the service would crash.  I moved the MDX into the cube and everything worked fine.  My point is that it could be some obscure chunk of MDX getting executed from somewhere and you may never find unless you analyze the dump file or have a trace running at the time of the crash.

  2. Jesse says:

    Oh yuck! I\’ll have to dig through the logs to see what I can find. It\’s somewhat scary to know the service can be crashed by something done through Proclarity.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s