Troilus83 on Mon, 08 Apr 2013 21:26:42
Hello everybody, I have an instance of SSAS Tabular that when I build reports from an Excel Pivot Table, sometimes i got the error: "The operation has been cancelled because there is not enough memory available for the application. If using a 32-bit
version of the product, consider upgrading to the 64-bit version or increasing the amount of memory available on the machine." I read some posts about this error but I think that it could be a different problem, the system is a 4x2 core and got 32 GB
RAM, when you go to the pivot table and build any report by an aggregation level, the response time is very fast but when I go to the lowest granularity level on the fact (product id) and try to obtain product id on a report aggregate by 3 dimensions and 1xMeasure
I got this error. The fact table actually have about 30 million records and that dimension (product id) contains a large number of records (around 5-7 millions). The same report but with filtered values takes about 3 minutes to get the result. The Tabular
has the default configuration properties. Any tip or help would be appreciate. Thanks in advance. Cheers.
Olaf Helper on Tue, 09 Apr 2013 06:08:10
using a 32-bit version of the product, consider upgrading to the 64-bit advance.
A 32 bit application can only use max 3 GB memory, even if more free memory is available.
Troilus83 on Tue, 09 Apr 2013 07:17:13
Thanks for your response, the server is 64-bit and this kind of reports consumes all the RAM until it exceeds the HardMemoryLimit.