SAP Knowledge Base Article - Public

3230520 - Table widget returns Internal Error Occured due to Memory Allocaton Failed - People Analytics Story

Symptom

  • Story Table widget shows "Server Error - Internal Error Occurred" message
  • Data source or query has no filter
  • Browser network logs show the following error for GetResponse:
    • {"Messages":[{"Type":2,"Number":42014,"Text":"Internal error occurred while processing.","DetailedError":"Caught exception : exception 42111: SQL Error : search table error:  [9] Memory allocation failed;exception 1000002: Allocation failed ; \\$size\\$\u003d1125871496; \\$name\\$\u003dJECreateNTuple; \\$type\\$\u003dpool; \\$inuse_count\\$\u003d20; \\$allocated_size\\$\u003d15106570608; \\$failure_type\\$\u003dSTATEMENT_MEMORY_LIMIT; \\$failure_flag\\$\u003d\n,Exception in executor plan558008463@pc02hdblb401:30203 while executing pop 49\n"}]}

Environment

SAP SuccessFactors People Analytics

Reproducing the Issue

  1.  Login to instance
  2. Go to Report Center
  3.  Runa  Story with  a Learning data source
  4. 5. You will notice below error for the widget that uses that data source
    Unable to Retrieve data from the data source.
    Error: [Internal error occurred while processing.]

Cause

This is due to the number of records fetched for the list Table widget - huge volume of data returned causing memory allocation error.   Preview Query only retrieves a limited number of row which is why there is no error during Query Design.  But at Story level all data is read. 

Resolution

Please add a filter accordingly to the query or the data source itself to limit the data returned.  In this case please edit the User data source and apply filters to limit scope. e.g. filter by Program ID etc.
In addition, you can also apply an additional Story level filter and apply the following to help improve performance of the report
3200914 - Apply Selection for filters - Stories in People Analytics
https://launchpad.support.sap.com/#/notes/0003200914

Keywords

memory allocation failed, LMS Story, LMS query, Story internal error occurred, widget error, server error,  exception 42111, story designer , KBA , LOD-SF-ANA-SAC-SDS , Story Designer - Story & Formatting , Problem

Product

SAP SuccessFactors HXM Suite Core 2205