MSSQLServerOLAPService Service seems to crash rather sporadically during our nightly ETL with the error of:
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. Internal error: An unexpected exception occured..
The time of the error in the event viewer seems to correspond with the step in the ETL that processes our AS 2005 database (Analysis Services Command Task). The job step reports success, and the data is refreshed so I don't understand why it is reporting an error in Event Viewer.
The server is x86 with SQL 2005 sp2 installed.
Has anyone else run across this?
I'm getting the same issue when I run a particular MDX query. I'm also on x86 with SQL 2005 sp2 installed. Please post if you find anything out.
Thanks,
Craig
No comments:
Post a Comment