You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Groovy Script error- There are too many Groovy data grids in use at this time.

edited Oct 9, 2018 3:05AM in Planning 4 comments

Content

Hi all,

I have created data grid  for smartpush using  groovy script. Getting below error message when running the groovy rule. I did close datagrid at the end.  I have restarted the instances (resetservice) and its working for few times, but again this issue keep occurring it.

"A method called by the script failed on line: 112, with error: There are too many Groovy data grids in use at this time. Please try again later"

I am not sure this is related to memory or code issue.

 

Thanks

Senthil

 

Code Snippet

Cube cube = operation.application.getCube("OEP_FS")

// Get Project Members for Aggregated Account1

DataGridDefinitionBuilder ProjectsBuilder = cube.dataGridDefinitionBuilder()
ProjectsBuilder.setSuppressMissingBlocks(true)
ProjectsBuilder.addPov(['Entity', 'Site', 'Currency', 'Version', 'Scenario', 'Product', 'Customer', 'Account',  'Department', 'Plan Element'], [[sRTPSEntity], [sRTPSSite], [sCurrency], [sVersion], [sScenario], [sProduct], [sCustomer], [sAggAccounts1], [sAggDepartment], [sAggPlanElement] ])
ProjectsBuilder.addColumn([, 'Years', 'Period'], [['&OEP_RollingFcst'], [sPeriods]])
ProjectsBuilder.addRow(['Projects'], [[sProjects]])
DataGridDefinition ProjectsGridDefinition = ProjectsBuilder.build()
DataGrid ProjectsDataGrid = cube.loadGrid(ProjectsGridDefinition, true)
ProjectsDataGrid.dataCellIterator().each { 
  if( !it.isMissing() ){
    projectsList << it.getMemberName('Projects')
  }
}

ProjectsDataGrid.close()

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!