Symptom
- Slow delete operation on table /IWBEP/SU_ERRLOG
- In HANA database : TransactionLockWaitSmpStat lock
- Involved code : /IWBEP/CL_SUTIL_RUNTIME~LOG_WRITE
* Same log entry found
ELSE.
" Update Error Count & First Error Time
ls_log-first_tstmp = ls_log_old-first_tstmp.
ls_log-error_count = ls_log_old-error_count + 1." Delete the old one and create a new one
DELETE /iwbep/su_errlog CONNECTION (/iwbep/if_sutil_constants=>co_dbcon_name) FROM ls_log_old.
INSERT /iwbep/su_errlog CONNECTION (/iwbep/if_sutil_constants=>co_dbcon_name) FROM ls_log. "#EC CI_USE_WANTED
COMMIT CONNECTION (/iwbep/if_sutil_constants=>co_dbcon_name). "#EC CI_USE_WANTED
ENDIF.
ENDIF.
Read more...
Environment
- SAP Gateway Framework
Product
Keywords
Slow delete, /IWBEP/SU_ERRLOG, SAP Gateway Framework, OData v4, digital orders, application issue, log aggregate, table size, KBA 0002499354, /IWBEP/error_log, global configuration, aggregate by Service, User and Error, TransactionLockWaitSmpStat , /IWBEP/CL_SUTIL_RUNTIME~LOG_WRITE, /IWBEP/CL_SUTIL_RUNTIME, LOG_WRITE , KBA , OPU-GW-COR , Framework , 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.