Skip to Content
avatar image
Former Member

Data target XXXX (Activation Queue) is locked by process (internal 4)

Hi All,

While trying to delete the request from ADSO giving below error because of this not able to delete the request and further requests are also failing with same issue.

Error:

Data target XXXX (Activation Queue) is locked by process {2017-01-02 23:33:07 000049 CET} (internal 4)

We are using SAP BW 7.4 on HANA service pack 9 .

Thank you .

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

7 Answers

  • avatar image
    Former Member
    Jan 05, 2017 at 05:53 AM
    -1

    Hello Srini,

    I will advise you try the following :

    1st : Check in SM12 if your data target has an exclusive lock (if this is the case then remove that lock and try deleting again)

    2nd : Ensure that the data target is not locked by any DTP etc.

    3rd : you can also take a look in sm51 and try checking if any process is assigned to the data target you mentioned (sometimes with the description in the 'table ' column gives you a hint)

    4th : Your last option if nothing works is to delete the request from the following control tables : RSICCONT, RSMONICDP, RSODSACTUPDTYPE and RSODSACTREQ. This your basis team would easily perform.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 05, 2017 at 02:18 PM
    -1

    RSPMREQUEST is the table which stores the ADSO requests.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 09, 2017 at 06:38 PM

    glad I could help. Please close the thread as answered.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 25, 2017 at 10:39 AM

    I have deleted request from table RSPMREQUEST. But still getting same error.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      How did you delete the request from RSPMREQUEST?

      Please suggest

      Thanks.

  • avatar image
    Former Member
    May 24, 2017 at 07:29 AM

    Hello Srini,

    We have a similar problem and would like to know how the problem was resolved. Appreciate help.

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 03, 2017 at 01:50 PM

    Dear Srini

    Tables like RSICCONT, RSPMREQUEST, RSREQDONE, RSMONICDP etc. should NEVER be touched, edited or deleted manually. This is not supported and this can easily leading to a destruction of your own system!!!!!

    The reported situation above is described in the notes:
    2294504RSPM 102 because of aborted new DMART extraction from ADSO

    2225908Error Message 'Data target ... is locked by process ... (internal ...)' after DTP Load

    Deleting manually from any kind of request administration tables is NOT supported and SAP does not take any responsibility if it causes further problems, dumps, data inconsistency.

    br

    Roland

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 13 at 11:33 AM

    Hello,

    my answer is far too late, but it may help others with the same problem.
    In my case the ADSO was in planning mode, so I just had to switch the ADSO to data load mode, then I could delete and load data.

    Regards,
    Katharina

    Add comment
    10|10000 characters needed characters exceeded