SAP Knowledge Base Article - Preview

3567621 - Memory allocation failure during the Datasource extraction

Symptom

This document is not for any specific datasource. It's for the datasource who has the custom coding anywhere (e.g. SAPLRSAP, RSU5_SAPI_BADI ...)

  • Data extraction (initial/delta/full) ends with DBSQL_SQL_ERROR dump in the source system.
  • SQL code: 4 occurred while accessing a big table like BSEG, COEP and so on.
  • Memory allocation failure in ABAP program "EXIT_SAPLRSAP_001"

The details of the dump is as below:

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 xxx

Database error text: "SQL message: cannot allocate enough memory: search table                
error:  [9] Memory allocation failed;exception 1000002: Allocation failed ;                  
$size$=49994154120; $name$=JECreateNTuple; $type$=pool; $inuse_count$=10;                    
$allocated_size$=2523559490; $failure_type$=ST"

"DBSQL_SQL_ERROR" CX_SY_OPEN_SQL_DB
"SAPLXRSA" bzw. ZXRSAU01
"EXIT_SAPLRSAP_001"


Read more...

Environment

  • SAP Netweaver
  • BW/4hana
  • SAP R/3
  • SAP R/3 Enterprise
  • SAP ERP
  • SAP ERP Central Component
  • SAP enhancement package for SAP ERP
  • SAP enhancement package for SAP ERP, version for SAP HANA
  • SAP S/4HANA

Product

SAP BW/4HANA all versions ; SAP ERP Central Component all versions ; SAP ERP all versions ; SAP NetWeaver all versions ; SAP S/4HANA all versions ; SAP enhancement package for SAP ERP all versions ; SAP enhancement package for SAP ERP, version for SAP HANA all versions

Keywords

KBA , BC-BW , BW Service API , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.