SAP Knowledge Base Article - Preview

3545027 - Slow delete or lock on table /IWBEP/SU_ERRLOG in SAP Gateway Framework

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

SAP S/4HANA all versions

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.