We are trying to use Live Office XI 3.1 (latest SP and FP) in Excel 2007 to create a single column dataset with approx. 250,000 rows. The file size for this dataset is approx. 12mb and in the CMC we have set the "Maximum Character Stream Size" to 50mb in the Webi Processing Server settings. The process returns a very generic error message stating "An error occurred when refreshing". When we click the "Show Details" button, we get the "unknowned error" message. We have successfully run a much smaller dataset from the same universe.
Any ideas why the larger dataset would return this error?
Thanks.