3525452 - GRAC_SPM_LOG_SYNC_UPDATE caused dump in backend system with DBSQL_SQL_ERROR

• 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"

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