AS stops working, Eventid 22, category 256

Hi!

During the last week my AS2005 server has behaved strangely. It works for two-three days and then it stops and cant handle any more queries. However i can list the catalog and cubes in ProClarity but when i try to connect to a cube it does not work. The same when i go to Management Studio. If i restart the service it works again, probably for another 2-3 days.

Also AS2005 send a lot of error events to the eventlog. All like this(i think one for every query that fails but i am not sure). Event id looks like this:

Event Type: Error
Event Source: MSSQLServerOLAPService
Event Category: (256)
Event ID: 22
Date: 2006-08-23
Time: 13:09:47
User: N/A
Computer: XXXXX
Description:
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.

It is a x64 box with 4GB ram and Windows Server 2003 R2. I have SP1 installed and its only AS 2005 running on it.

Any clue to what the reason could be? Could it be something that is fixed in the cumalitve hotfix package?

Description for the error code 22 is "An unexpected exception occured." doesnt give you much.

There is not much I can suggest you here. Try contacting Microsoft customer support services and report your problem.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.