3530637 - SQL error "SQL code: 4" occurred while accessing table "RSSTATMANREQMAP"

DTP Execution terminates in DUMP: 

Category               Installation Errors
Runtime Errors         DBSQL_SQL_ERROR
Except.                CX_SY_OPEN_SQL_DB

Short Text                                                                                        
    SQL error "SQL code: 4" occurred while accessing table "RSSTATMANREQMAP".  

What happened?    
    Database error text: "SQL message: cannot allocate enough memory:  [9] Memory  
     allocation failed;exception 1000002: Allocation failed ;
     $failure_type$=STATEMENT_MEMORY_LIMIT_FROM_GLOBAL_CONFIG; $failure_flag$=;
     $size$=786687; $name$=ihm; $type$=pool; $inuse_count$=141299; $allo"  

"DBSQL_SQL_ERROR" CX_SY_OPEN_SQL_DB
"CL_RSSM_STATMAN_SOURCE_DTASRC=CP" or CL_RSSM_STATMAN_SOURCE_DTASRC=CM004   
 "IF_RSBK_REQUEST_SERVER~GET_REQUESTS"

SELECT MAX( parent_rnr_sid ) FROM rsstatmanreqmap AS m INTO l_min_src_sid 
WHERE dta_source_type = rsbc_c_srctp-datasource AND dta_source = l_src  AND EXISTS

|  412|    IF cl_rsbk_dtp=>factory( i_dtp )->get_deltaonlyonce( ) = rs_c_false.                    |
|>>>>>|      SELECT MAX( parent_rnr_sid ) FROM rsstatmanreqmap AS m INTO l_min_src_sid             |
|  414|        WHERE dta_source_type = rsbc_c_srctp-datasource AND dta_source = l_src  AND EXISTS  |
|  415|        ( SELECT * FROM rsbkrequest WHERE requid = m~rnr_sid AND dtp = i_dtp AND ustate = '\|
|2'                                                                                                |
|  416|        OR ustate = '8' OR ustate = '7'  )."#EC CI_CMPLX_WHERE

Or, one of the following SQL can be found as expensive SQL in ST12 trace:

SELECT MAX( "PARENT_RNR_SID" ) FROM "RSSTATMANREQMAP" "M" WHERE "DTA_SOURCE_TYPE" = N'DTASRC' AND "DTA_SOURCE" = ? AND EXISTS ( SELECT * FROM "RSBKREQUEST" WHERE "RSBKREQUEST" . "REQUID" = "M" . "RNR_SID" AND "RSBKREQUEST" . "DTP" = ? AND "RSBKREQUEST" . "USTATE" = N'2' OR "RSBKREQUEST" . "USTATE" = N'8' OR "RSBKREQUEST" . "USTATE" = N'7' )

SELECT MAX( parent_rnr_sid ) FROM rsstatmanreqmap AS m INTO l_min_src_sid WHERE dta_source_type = rsbc_c_srctp-datasource AND dta_source = l_src  AND EXISTS ( SELECT * FROM rsbkrequest WHERE requid = m~rnr_sid AND dtp = i_dtp AND ustate = '2'

SAP Netweaver BW 7.x

DBSQL_SQL_ERROR, after update, after upgrade, BI_PROCESS_DTP_LOAD, CL_RSSM_STATMAN_SOURCE_DTASRC=CP, SQL code: 4, last request, SM66 , KBA , BW-WHM-DST-DTP , Data Transfer Process , Problem