3694390 - Delta extraction with CO-OM line item data source 0CO_OM_CCA_9 failed due to memory shortage during access on view V_COEP_ACDOCA_R3

Prerequisites:

• 3498504 - BW-BCT: CO-OM line item data source with K_TIMESTMP selection and HINT
• 3589853 - The DELTA extraction of a line item DataSource is slow or terminates due to lack of memory

Delta extraction with CO-OM line item data source 0CO_OM_CCA_9 failed due to memory shortage caused by the view for V_COEP_ACDOCA_R3, despite that both mentioned SAP Note already applied.

Comment:

• Execute the Full-DTP the load works.
• Execute the Delta-DTP (delta-initialization) with exact same filter set runs into memory dump (it contains TIMESTMP).

Symptoms:

1. Transaction Code: SM21
   
   17.11.2025    09:00:00    hostname_HXE_00    BTC    092    002    USERNAME    @5D\Qhigh priority@    B64    An internal database error caused the database transaction to abort
   17.11.2025    09:00:00    hostname_HXE_00    BTC    092    002    USERNAME    @5C\Qvery high priority@    BY4    Database error 4 with PRE access to table V_COEP_ACDOCA_R3
   17.11.2025    09:00:00    hostname_HXE_00    BTC    092    002    USERNAME    @SR\Qinformation@    BY0    > cannot allocate enough memory: Allocation failed $REASON$ 
   
   
2. Transaction Code: ST11
   
   C Mon Nov 17 09:00:00:393 2025
   C  *** ERROR =>   execute() of C_0494, #rec=0, rc=1, rcSQL=4
    [dbsdbsql.cpp 2969]
   C  {root-id=005056BC1F001FE0B0F1D2A4818F217B}_{conn-id=6919793010072A71E10000000A966E36}_66
   C  *** ERROR => EXECUTE C_0494 on connection 0, rc=4
    [dbslsdb.cpp  8712]
   C  SQLCODE    : 4
   C  SQLERRTEXT : cannot allocate enough memory: Allocation failed $REASON$
   C  sc_p=7f61427473e0,no=494,idc_p=(nil),con=0,hit=1,cnt=2,act=1,slen=1731,smax=2048,#vars=14,stmt=7f4b4fbc3ab0,#tabs=2,tables=V_COEP_ACDOCA_R3              COBK
   C  prepared=0,lastPrepareTime=20251117092242,nativeSQL=0,ignoreStmtId=0
   C  statementHash=8bc9fedd6b194586ff1db65852288f0f
   C  SELECT "B" . "AWORG_REV" , "B" . "AWREF_REV" , "A" . "BEKNZ" , "B" . "BELNR" , "A" . "BELTP" , "B" .\
   C   "BLART" , "B" . "BLDAT" , "B" . "BLTXT" , "B" . "BUDAT" , "A" . "BUKRS" , "A" . "BUZEI" , "B" . "CP\
   C  UDT" , "A" . "EBELN" , "A" . "EBELP" , "A" . "EXTAPPLICATION" , "A" . "EXTDOCUMENTNO" , "A" . "FKBER\
   C  " , "A" . "GEBER" , "B" . "GJAHR" , "A" . "GKOAR" , "A" . "GKONT" , "A" . "GRANT_NBR" , "A" . "GSBER\
   C  " , "B" . "KOKRS" , "A" . "KSTAR" , "B" . "KWAER" , "A" . "MATNR" , "A" . "MEFBTR" , "A" . "MEGBTR" \
   C  , "A" . "MEINH" , "A" . "OBJNR" , "A" . "CO_ACCASTY_N1" , "A" . "OWAER" , "A" . "PAROB1" , "A" . "PB\
   C  UKRS" , "A" . "PERIO" , "A" . "PERNR" , "A" . "PFKBER" , "A" . "PGEBER" , "A" . "PGRANT_NBR" , "A" .\
   C   "QMNUM" , "B" . "REFBK" , "B" . "REFBN" , "B" . "REFBT" , "A" . "REFBZ" , "B" . "REFGJ" , "A" . "RE\
   C  SID" , "A" . "SGTXT" , "B" . "STFLG" , "B" . "STOKZ" , "A" . "TWAER" , "A" . "USPOB" , "A" . "VBUND"\
   C   , "A" . "VERSN" , "A" . "VRGNG" , "A" . "WERKS" , "A" . "WKFBTR" , "A" . "WKGBTR" , "A" . "WOGBTR" \
   C  , "A" . "WORKDATE" , "A" . "WRTTP" , "A" . "WTGBTR" , "A" . "ZZFICOAKZB" , "A" . "ZZFICOAKZF" , "A" \
   C  . "ZZFWF" , "A" . "ZZGEHN1" , "A" . "ZZGEHN2" , "A" . "ZZJOURNALIST" , "A" . "ZZLIFNR" , "A" . "ZZRE\
   C  SSOURCE_TXT" , "A" . "AUFNR" , "A" . "KOSTL" , "A" . "LSTAR" , "A" . "PSPNR" FROM "V_COEP_ACDOCA_R3"\
   C   "A" INNER JOIN "COBK" "B" ON "A" . "MANDT" = "B" . "MANDT" AND "A" . "KOKRS" = "B" . "KOKRS" AND "A\
   C  " . "BELNR" = "B" . "BELNR" WHERE "A" . "MANDT" = ? AND "A" . "LEDNR" = N'00' AND ( "A" . "OBJNR" BE\
   C  TWEEN ? AND ? OR "A" . "OBJNR" BETWEEN ? AND ? OR "A" . "OBJNR" BETWEEN ? AND ? OR "A" . "OBJNR" BET\
   C  WEEN ? AND ? OR "A" . "OBJNR" BETWEEN ? AND ? ) AND "A" . "WRTTP" = ? AND "B" . "TIMESTMP" BETWEEN ?\
   C   AND ?  WITH HINT(USE_HEX_PLAN);
   B  ***LOG B64=> internal DB error aborts transaction [dbsh         1250]
   B  SQL code: 4, SQL text: cannot allocate enough memory: Allocation failed $REASON$
   B  ***LOG BY4=> sql error 4      performing PRE on table V_COEP_ACDOCA_R3 [dbdbslst     5958]
   B  ***LOG BY0=> cannot allocate enough memory: Allocation failed $REASON$ [dbdbslst     5958]
   B  DbDbslStatement::handleDbslRc: dbsl_rc=99, exeception=CX_SY_OPEN_SQL_DB_Internal_DB_Error, program=LBWOMRU01, line=308 

Further investigation:

1. 3327150 - SQL Statement Collection: "HANA_SQL_StatementHash_DataCollector" report for SAP HANA

SAP HANA, platform edition

STATEMENT_MEMORY_LIMIT_FROM_GLOBAL_CONFIG, statement memory limit, memory, out of memory, composite limit violation, hint, hex, query optimizer, USE_HEX_PLAN, NO_USE_HEX_PLAN, co-om, 0CO_OM_CCA_9, 0CO_OM_OPA_6, delta extraction, V_COEP_ACDOCA_R3, COBK, delta init, delta-init, program, SAPLBWOMR, LBWOMRU01, delta-initialization  , KBA , HAN-DB-PERF , SAP HANA Database Performance , BW-BCT-CO-OM , BW only - Overhead Cost Controlling , Problem