We have a new community! Please visit support.timextender.com
Follow

Error: "The sort order specified for distinct count records is incorrect"

Note:  This is an old article.  However, the troubleshooting tips may still apply to newer versions. 

Symptoms

During deploy and execute of a cube that contains a distinct count measure, the process fails with the following error message:

The sort order specified for distinct count records is incorrect

Cause

This is most likely cause by different collations being used on the data warehouse database and the Analysis Services database. In many cases the data warehouse database will be using a SQL Server collation such as SQL_Latin1_General_CP1_CI_AS while Analysis Services will often use the Windows collation Latin1_General_CI_AS. Although much alike, these are not identical.

Resolution

Modify the collation settings of the data warehouse and Analysis Services databases to the same Windows collation.

 

Was this article helpful?
0 out of 0 found this helpful

0 Comments

Please sign in to leave a comment.