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.
SAP Knowledge Base Article - Preview