Data loading and streaming process chains

[former_member290837]

Dear SAP BI consultants,

We currently have a streaming process chain that loads data from ECC table EKKO (via SLT) to our ADSO in the Acquisition layer. The reason for this is that we want to have the data realtime in SAP BW.

We want to load the data to our Integration layer, but this time not realtime but only once a day. When running the DTP, the following error will popup:
Data target EKKO(Active Table) is locked by process {2017-05-26 08:52:45 000016 CET} (internal 6) ADSO EKKO_INT

Image: Error in the DTP monitor

How does the process chain looks like:
1. Starter process
2. DTP that loads the data from ECC to SAP BW (via SLT)
3. Activate the request

What's going wrong here? Do we need to unlock something? Or stop the streaming process chain? Who can help me with this?
We are using SAP BW 7.5 SP6 and for loading we're using the ODP framework.

[former_member243640]

Check note: https://launchpad.support.sap.com/#/notes/2574738

You might face similar symptoms when you try to load master data with several streaming process chains or with several DTPs in one streaming process chain. Enhanced master data update will not help, so try to organize ETL in different way.