Getting the following error
Errors in the OLAP storage engine: The sort order specified for distinct
count records is incorrect.

setting CheckDistinctRecordSortOrder to 0 gets around the error but why does
it happen?

Since Analysis Services 2005 generates the query and the sort wouldn't it
have to be in the correct order?
The query being run has
ORDER BY "AS_PAYROLL_VCZP"."EMP_ID" ASC
so the sort is happening.

The problem has only happened on queries returning 1 million+ records, could
the message be volume(or time to process) related?

Thanks

Hello,

You may want to check the data type of the column having distint count
aggregate function. OLAP distinct count requests numerical data type. Also,
you more want to try different cube to see if it could be reproduced. If
the issue occurs consistently only for for 1 million+ records, this could
be a volume related issue. Since we are not able to find any known issue in
our database, this has been reported to the proper channel.

To find out the root cause of this issue we may need to analyze memory
dumps, this work has to be done by contacting Microsoft Product Support
Services. Therefore, we probably will not be able to resolve the issue
through the newsgroups. I recommend that you open a Support incident with
Microsoft Product Support Services so that a dedicated Support Professional
can assist with this case. If you need any help in this regard, please let
me know.

For a complete list of Microsoft Product Support Services phone numbers,
please go to the following address on the World Wide Web:
http://support.microsoft.com/directory/overview.asp

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

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


--------------------

I also get the same error.

However the situation is different. I have a cube that has been working fine for some time (about 2 months) which I feed through an SSIS package that performs a "Dimension Process Update" and a "Measure Incremental Update".

It worked fine until one day I got the error "The sort order specified for distinct count records is incorrect."
I tried some minor changes but nothing worked. I should note here the if I try to "Full process" the cube, it works fine so that leads me to think that there is nothing really wrong with the data.

I also tried to remove the DistinctCount measure and place it in a measure group on its own. This change allowed the incremental update to complete and feed proper data into the cube. Yet, the result for the DistinctCount measure was completely wrong.

Could it be that the sort order of the dimensions also has something to do in this?

Help anyone?

Andreas