There are two possible causes for this error:
1. Essbase cannot allocate enough blocks from heap to perform the calculation.
2. The database Block Size is not optimal
Your seeting seems to be fine but I am not sure about your block size. Check this.
Data Cache Setting:
This is the size of memory that Essbase is allowed to store blocks while doing a dynamic calc process. To find out how many blocks can fit into this cache, take the current setting and divide it by the block size.
Data Cache in K
______________ = Number of blocks that can be allocated
Block Size in K
Data Cache needs to be set high enough to hold N blocks (to calculate: N x 2 x blocksize (in K)).
Check for these two settings.
Hope this helps....
Try increase the database properties->Caches->Cache sizes. Try change the default values, cause its always less than you need.
Thanks. I have increased the cache size and the problem is resolved for this time being.