We have recently upgraded to 18.104.22.168 from 22.214.171.124. I have an ASO cube which I need to copy Actuals to Forecast on a monthly basis. This is done currently in our .3 environment using Maxl calling a calc script file with out any issues. However, in the .4 environment, every time it runs I get the error "Request grid size is more than allowed limit . Increase it using the config setting MAX_REQUEST_GRID_SIZE." I have made a number of adjustments to the grid size setting in the config file, even up to ridiculous sizes and I continue to get this error. As far as I can tell everything appears to be the same at the app level between environments so I don't understand what is causing this.
Here are some stats on the db:
Scenario - 14 stored members
Version - 18
Department - 687
Years - 23
Accounts - 2269
BU - 30
LifeCycle - 19
Location - 163
Project - 5106
Periods - 31
Groupings (attribute) - 5
Project Type (attribute) - 63
Number of input cells - 3190801
Number of incremental data slices - 1
Number of aggregate views - 0
Number of aggregate cells - 0
Number of incremental aggregate cells - 0
Cost of querying incr. data (ratio to total cost) - 0
Input-level data size (KB) - 61408
Aggregate data size (KB) - 0
Cache hit ratio - .62
Current cache size (KB) - 8192
Current cache size limit (KB) - 1048576
Page reads since last startup - 6
Page size (KB) - 32
Disk space allocated for data (KB) - 122880
Disk space used by data (KB) - 61536
Thanks for any help!
Are you restarting essbase between setting that variable?
Assuming you are, there were some limiters put on ASO cubes - I've hit them in big data copies\data exports and have needed to work around them. I've not seen that error message, but I'm normally working in CDFs so the error messages can be different.