Microsoft KB Archive/311528

= BUG: Infinite Recursion Error with Parent-Child Dimension and Custom Member =

Article ID: 311528

Article Last Modified on 2/20/2007

-

APPLIES TO


 * Microsoft SQL Server 2000 Analysis Services

-



This article was previously published under Q311528



BUG #: 9731, 12582, 12675 (Plato7x)



SYMPTOMS
When you view data associated with a custom member of a parent-child dimension, the cell values may display as &quot;#Err&quot;. When you examine the cell properties of any of the custom members, you receive the following error message:

Infinite recursion detected during execution of calculated member.



CAUSE
This behavior is due to a stack overflow, which may occur when viewing custom members from a parent-child dimension with 15 or more levels where members at the lowest level contain a custom member formula that references a member at a higher level.



WORKAROUND
Use the Image Configuration Utility (ImageCfg.exe) that ships with the Microsoft Windows 2000 Resource Kit to increase the stack size that is allocated to Msmdsrv.exe.

WARNING: The Image Configuration Utility impacts the allocation of operating system memory. This tool may reduce the amount of memory available for critical operating system functions. Refer to your application documentation before using this tool.

NOTE: Some software application manufacturers configure their applications to use application memory tuning. Refer to your application documentation before using this tool.



STATUS
Microsoft has confirmed that this is a problem in SQL Server OLAP Services version 8.0.



Steps to Reproduce Behavior
 Open Analysis Manager and select the FoodMart 2000 sample. Edit the Account shared dimension. Write-enable the dimension by setting the Write-Enable advanced property to true. Enable Custom Members and select a new column named Custom_Members. In Microsoft Access, open FoodMart 2000.mdb and then open the Account Table.</li> Add the following values:

</li> Incrementally process the Account dimension.</li> Open the Budget cube for editing.</li> In the Cube Editor, right-click the Account dimension and click Browse. Drill down to member Test 15 and enter the following custom member formula &quot;[ACCOUNT].&[5000]&quot;.</li> Save and browse the cube.</li> Examine the cell properties of any of the Test members.</li></ol>

Additional query words: OLAP

Keywords: kbbug KB311528

-

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

© Microsoft Corporation. All rights reserved.