Monday, December 16, 2019

Error "IndexError: index out of range: 1" while executing a batch process in FDMEE

Error "IndexError: index out of range: 1" while executing a batch process in FDMEE

Three major aspects of this issue are:
  1. Insufficient Batch timeout value defined in the System settings / Application settings in the FDMEE application
  2. Stuck thread timeout setting needs to be increased in the ErpIntegrator0 managed server (weblogic)
  3. Increase the Connection Pool - Maximum Capacity range for EPM in the weblogic console
1. To increase the batch timeout setting in the FDMEE application
  • Navigate to Data Management from EPM workspace
  • From the Setup tab, and then under Configure, select System Settings
  • In System Settings, from Profile Type, select Other
  • Define a timeout value for the “Batch timeout in minutes”
            Note : In this the maximum batch timeout value can be 30000
2. To increase the Stuck Thread timeout setting in the ErpIntegrator0 managed server in weblogic
  • Navigate to weblogic admin console
  • Under domain structure, expand Environment and choose servers
  • Choose ErpIntegrator0 from the servers list
  • Under configuration, choose tuning
  • Choose Lock & Edit to modify the setting value
  • Increase the Stuck Thread Max time value, set the value to 9600
  • Note : The value is in seconds. By default it will be 600 seconds
  • Choose activate configuration so that the settings take effect
  • Restart the FDMEE services.
3. To increase the Connection Pool - Maximum Capacity range for EPM in the weblogic console
  • Navigate to weblogic admin console
  • Under domain structure, expand Services and choose Data Sources
  • Click on the 'Connection Pool' tab
  • Click the 'Lock and Edit' button in the left pane
  • Increase the ‘Maximum Capacity’ value from 30 to 300
  • Click the 'Activate Changes' button in the left pane
  • Restart the FDMEE services

No comments:

Post a Comment

Other posts

How is the data size calculated for a EPM Cloud service instance?

The total size of data used by your EPM Cloud service instance is the sum of the following: Application data stored in Essbase Artifact...