SAP Knowledge Base Article - Preview

3216061 - Lock wait on table SFOBUEV000

Symptom

During the execution of a Data Transfer Process (DTP) the system shows unusual lockwaits on table SFOBUEV000. In a highly parallel DTP this can lead to a delay of more than 15-20 seconds.

The lock wait can be checked via M_EXPENSIVE_STATEMENTS and the field LOCK_WAIT_DURATION shows the actual numbers:

Select m.start_time, m.DURATION_MICROSEC, m.LOCK_WAIT_DURATION, m.APP_USER, m.SESSION_VARIABLES, m.* 
from "PUBLIC"."M_EXPENSIVE_STATEMENTS" m
where m.STATEMENT_STRING like '%SFOBUEV000%' 
and m.APPLICATION_NAME != 'HDBStudio' -- Exclude MySelf
order by m.START_TIME desc;


Read more...

Environment

  • SAP BW/4HANA 1.00
  • SAP BW/4HANA 2.00

Product

SAP BW/4HANA 1.0 ; SAP BW/4HANA 2.0

Keywords

rto, lock, wait, performance, slow, formula, formel, dtp, load, infosource, stacked , KBA , BW4-DM-TRFN , SAP HANA execution in Transformation and DTP , BW4-ME-TRFN , Transformation Metadata , BW4-DM-DTP , ABAP Orchestration of Data Transfer Process , 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.