Query consumes all available server memory - by Jim Fernandez

Status : 

  Not Reproducible<br /><br />
		The product team could not reproduce this item with the description and steps provided.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 786118 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 5/2/2013 8:57:04 AM
Access Restriction Public


Our configuration: SSAS 2012 Enterprise (11.0.3349.0), Win Server 2012, 8 core, 254 Gb RAM
The following simple query that utilizes a VB function will consume all available memory within a few minutes, forcing a restart of services to free up resources.  
WITH MEMBER A AS Value("03/28/2013")
FROM [Adventure Works]
Sign in to post a comment.
Posted by Microsoft on 1/9/2014 at 12:47 PM
this issue will be fixed in next service pack. Please note that member function is not supported with DAX/Tabular model so it supposed to give an error instead of running out of stack.
This new behavior is incorporated in the next service pack.
Posted by Microsoft on 10/1/2013 at 11:02 PM
Hi Jim,
Thanks for submitting the issue. We are working on it.
Posted by Jim Fernandez on 6/1/2013 at 9:28 AM
any activity on this issue?