Symptom
When running a Stories report, error message is displayed, or contains the following.
error code [4]; SAP DBTech JDBC: [4]: cannot allocate enough memory: OOM. please check traces for further information; nested exception is com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [4]: cannot allocate enough memory: OOM. please check traces for further information.
This is happening for new reports and older reports that were running.
Environment
- SuccessFactors Learning Management
- SuccessFactors Analytics
Cause
The report is currently trying to return too much data that has hit the memory cap for the database.
Resolution
- Per our Documentation "Currently, your query can include only up to 120 columns, which are selected from maximum 30 tables. Your query can retrieve data up to 1,000,000 cells."This is a recommendation and the data within those cells can also fluctuate the limits. When this error is seen. Please filter your reports to return less data.
See Also
- https://launchpad.support.sap.com/#/notes/3071139 Browser Limitations
Keywords
LMS, ANA, Learning, Analytics, OOM , Out of Memory, Hana, , KBA , LOD-SF-LMS-SAC , Stories for Learning , LOD-SF-ANA-SAC , Stories in People Analytics , Problem