Microsoft KB Archive/311863

= BUG: Internal Error Occurs When You Run a MDX Query with a NON EMPTY Clause Against a Virtual Cube =

Article ID: 311863

Article Last Modified on 2/20/2007

-

APPLIES TO


 * Microsoft SQL Server 2000 Analysis Services

-



This article was previously published under Q311863



BUG #: 12666 (Plato7X)



SYMPTOMS
The following error message may occur when you execute a multidimensional expressions (MDX) query that contains the NON EMPTY clause against a virtual cube.

An unexpected internal error has occurred.

The error message may occur if both of the following conditions are true:
 * The Non Empty Behavior property of the &quot;calculated member&quot; equals the name of its parent measure dimension.


 * You execute a MDX query with a NON EMPTY clause and a calculated member on the virtual cube.

This problem does not influence other connections.



WORKAROUND
To work around this problem you can either:
 * Leave the Non Empty Behavior property of the calculated member blank.


 * Use the regular cube instead of the virtual cube.


 * Do not use the NON EMPTY clause with a MDX query.



STATUS
Microsoft has confirmed that this is a problem in SQL Server 2000 Analysis Services.

Additional query words: nternal error non empty behavior

Keywords: kbbug kbpending KB311863

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.