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.

You should see files created in the Log folder with extension .mdmp. If you
have a support contract you should open a case with MS Support and make this
dump available to them -- it should help to diagnose the problem.

Thanks,
Akshai
--
This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Arturas Sirvydis" <ArturasSirvydis (AT) discussions (DOT) microsoft.com> wrote in
message news:17572C5B-C83E-490C-BD3B-5E81CAE73DF2 (AT) microsoft (DOT) com...