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


The information in this article 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 "calculated member" 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.
Modification Type:MinorLast Reviewed:7/16/2004
Keywords:kbBug kbpending KB311863
©2004 Microsoft Corporation. All rights reserved.