Article ID: 275135 - View products that this article applies to.
This article was previously published under Q275135
This article has been archived. It is offered "as is" and will no longer be updated.
BUG #: 11193 (PLATO 7.X)
Use of the Multi-Dimensional Expression (MDX) function StrToSet to convert a String to a Set results in an error if the string size is over 1 K.
Reduce the size of the input string for the StrToSet function to less than 1 K.
Microsoft has confirmed this to be a problem in SQL Server OLAP Services version 7.0. This problem has been corrected in U.S. Service Pack 3 for Microsoft SQL Server OLAP Services version 7.0. For information about how to download and install the latest SQL Server OLAP Services Service Pack, see the following Microsoft Web site:
http://www.microsoft.com/downloads/details.aspx?familyid=F62F45E9-24ED-4FA6-BD74-8A26606F96D8For more information, contact your primary support provider.
This problem does not occur in Microsoft SQL Server 2000 Analysis Services version 8.0.
Steps to Reproduce the Behavior
Memory could not be read.
Abnormal Program Termination
Afterwards, the MDX sample is unstable and does not run another query until you restart the MDX Sample application.
MDX syntax error.