3230520 - Widgets return Internal Error Occured due to Memory Allocaton Failed - People Analytics Story

• Story widgets show "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"}]}

SAP SuccessFactors People Analytics

1.  Login to instance
2. Go to Report Center
3.  Run a Story report
4. 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.]

This is due to the number of records fetched for the 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. 

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

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