SAP Knowledge Base Article - Preview

3110532 - CDS Based Delta Extraction Fails with STATEMENT_MEMORY_LIMIT

Symptom

You are encountering the memory dump during data extraction from CDS view. And in the CDS view  DETECT DELETED RECORDS =  TRUE annotation is being used.

Category               External Error
Runtime Errors         DBSQL_SQL_INTERNAL_DB_ERROR

 SQL error "SQL code: 2048" occurred while accessing table "****".   

|    Database error number: SQL code: 2048                                                         |
|    Database error text: "SQL message: column store error: search table error:                    |
|     [9] Memory allocation failed;exception 1000002: Allocation failed ;                          |
|     $size$=536870000; $name$=PopExec; $type$=TempAllocator;                                      |
|     $failure_type$=STATEMENT_MEMORY_LIMIT; $failure_flag$=


Read more...

Environment

  • Source System of BW system
  • SAP R/3
  • SAP R/3 Enterprise
  • SAP ERP Central Component
  • SAP ERP
  • SAP enhancement package for SAP ERP
  • SAP enhancement package for SAP ERP, version for SAP HANA
  • SAP S/4HANA
  • SAP BW/4HANA
  • SAP NetWeaver

Product

SAP ERP Central Component all versions ; SAP ERP Central Component for discrete industries all versions ; SAP ERP all versions ; SAP R/3 Enterprise all versions ; SAP R/3 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-ODP , Operational Data Provisioning (ODP) and Delta Queue (ODQ) , Problem

About this page

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

Search for additional results

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