Symptom
- The issue is encountered while running the EAM Log Sync Update report GRAC_SPM_LOG_SYNC_UPDATE. Dump DBSQL_SQL_ERROR occurs in target system (with STATEMENT_MEMORY_LIMIT). There is no error in GRC system, the job log (SM37) shows "Finished".
- The same execution was successful before GRC system upgrade (and/or before the backend system upgrade) with the same STATEMENT_MEMORY_LIMIT parameter in the backend system.
- The type of upgrade, e.g. GRC upgrade on GRC system and GRC Plugin update on the ERP system (backend system).
- The identified ST22 dump in backend system:
####
Category Installation error
Runtime Errors DBSQL_SQL_ERROR
Except. CX_SY_OPEN_SQL_DB
Date and Time 2024-09-23 11:10:10
Short Text
SQL error "SQL code: 4" occurred while accessing table "CDPOS".
What happened?
Database error text: "SQL message: cannot allocate enough memory: Allocation
failed $REASON$"####
SQL query :
SELECT * FROM "CDPOS" WHERE "MANDANT" = ? ORDER BY "CDPOS" . "MANDANT" , "CDPOS" . "OBJECTCLAS" , "CDPOS" . "OBJECTID" , "CDPOS" . "CHANGENR" , "CDPOS" . "TABNAME" , "CDPOS" . "TABKEY" , "CDPOS" . "FNAME" , "CDPOS" . "CHNGIND"
Read more...
Keywords
SAP, HANA, OOM, out, of, memory, out-of-memory, 4adc9b7b594988856dae7cff3f718d2f, GRAC_SPM_LOG_SYNC_UPDATE, Log, Sync, Update, TSV_TNEW_PAGE_ALLOC_FAILED, DBSQL_SQL_ERROR, GRC, EAM, Emergency, Access, Management, CDPOS, composite, limit, compositelimit_oom , KBA , HAN-DB , SAP HANA Database , GRC-SAC-EAM , Emergency Access Management , 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.