3216061 - Lock wait on table SFOBUEV000

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;

• SAP BW/4HANA

rto, lock, wait, performance, slow, formula, formel, dtp, load, infosource, stacked , KBA , BW4-DM-TRFN , SAP HANA execution in Transformation and DTP , BW4-DM-DTP , ABAP Orchestration of Data Transfer Process , BW4-ME-TRFN , Transformation Metadata , Problem