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 for Me (Login required).

Search for additional results

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