During our unit and load testing of the SSAS database using VSTST 2010 Ultimate; we are getting a memory error with some of our MDX queries (below). Futher analysis showed:
The adomdDataAdapter "Fill" command is our error point The error is occuring when the result data set has getter than 16,384 Columns; actual returned column count is 41,339 columns - business requirement does not let us change this query at this time.
The MDX query works fine in MS Excel 2007 The MDX Query works fine in MS SQL Studio 2008
How can we resolve the unit test data set with such a large column count?
Memory error: While attempting to store a string, a string was found that was larger than the page size selected. The operation cannot be completed.
In reference to thread:
View Complete Post