Hi all,

Setup:
SQL 2005 Server Standard Edition on x86 32-bit server, 3.5Gb RAM. (standard
install, no tuning/configuring)
Windows Server 2003 SP1
Cube consists of 3 measures groups, over 10 dimensions with up to 10
attributes, some parent-child and other hierarchies.
Measure groups consists of 2-3 measures, and includes up to 1 million rows
each.
There are about 20 Calculated measures, using LastPeriods() function
heavily.

Problem:
Issuing some specific big queries, error message "Internal Error: An
unexpected exception occured." appears and service stops responding and must
be restarted manually.
Profiler shows some more info on error:
Query End, 0 - MDXQuery, Error: 3238002710 (can this error ID help somehow?)

MDX query template looks like:
SELECT NON EMPTY
HIERARCHIZE(AddCalculatedMembers(
{DrillDownLevel({[Date].[DateTree].[All]})
})) DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON COLUMNS ,
{ -- lost of measures, most of them calcuated here --}
DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON ROWS FROM [VE_FA_01]
WHERE ( -- lots of dimensions here, most of them just left at [All] level,
some of them pointing to specific member --)

This query sometimes runs ok, I have noticed that it may depend on cube
cache, when data gets warm and cached, then it sometimes works fine, though
when cube is cold - it crashes all the time.

Another related problem is that when processing this cube it sometimes fails
and analysis service stops, though when it is restarted and rerun again -
runs just fine.
The error which is logged looks like this:The description for Event ID (
22 ) in Source ( MSSQLServerOLAPService ) cannot be found. ..... The
following information is part of the event: Internal error: An unexpected
exception occured. Internal error: An unexpected exception occured. Internal
error: An unexpected exception occured. Internal error: An unexpected
exception occured. Internal error: An unexpected exception occured. Internal
error: An unexpected exception occured. Internal error: An unexpected
exception occured..

I have been using cell securing and agregations, though after removing
these - the problem still exists.
I have only one idea left - to remove all calculated measures (I could move
some of the calculations to DW part, though that would be time consuming
process Any other ideas, please?

Sorry for a long message, any help or ideas would be appreciated.

Thanks,
A.S.