Skip to Content

Data loading and streaming process chains

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.

capture.png (48.5 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Jul 05, 2019 at 08:24 AM

    Check note:

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.