This Essbase discussion board is provided as a free service and dedicated to all the Essbase professionals out there!
 Return to Index  

MAX_REQUEST_GRID_SIZE Error

January 5 2017 at 11:47 AM
No score for this post
John 
from IP address 108.171.130.163

We have recently upgraded to 11.1.2.4 from 11.1.2.3. 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 [5000000]. 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:

12 dimensions
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!


 
Scoring disabled. You must be logged in to score posts.Respond to this message   
Responses

  1. 1 Quick question - Pete on Jan 5, 2017, 4:06 PM
  2.  
  3. Re: MAX_REQUEST_GRID_SIZE Error - Mike Henderson on Jan 5, 2017, 4:06 PM
    1. Re: MAX_REQUEST_GRID_SIZE Error - John on Jan 6, 2017, 9:03 AM
      1. Re: MAX_REQUEST_GRID_SIZE Error - Mike Henderson on Jan 6, 2017, 9:21 AM
        1. Re: MAX_REQUEST_GRID_SIZE Error - John on Jan 6, 2017, 10:21 AM
     

RSS feed for this forum - http://www.network54.com/Forum/58296?xml=rss. Please email hypess (at) gmail.com, if you have any questions/feedback/issues.