SAP Knowledge Base Article - Preview

3525452 - GRAC_SPM_LOG_SYNC_UPDATE caused dump in backend system with DBSQL_SQL_ERROR

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.