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

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()