Skip to Content
avatar image
Former Member

Error when locking update of table

Hello Experts,

ACR is failing with the below logs and it has become repetitive now it is happening twice or thrice in a month.

Data loading to the infoobject from 3 sources - 1 is data source and from 2 DSO's, all these loads are running in different times and not even near by.

Could you  please explain me how could I go further to find root cause of the problem to fix it permanently.

Regards,

Guru

Untitled.jpg (82.0 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Best Answer
    Nov 02, 2015 at 02:20 PM

    Hi,

    It Seems that some transcational data loads containing this infoobject is running, check if any transactional data loads are running..

    Thanks,

    Naveen

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 02, 2015 at 02:29 PM

    Hi,

    its loading issue. mean other load may be loading to/from same info object or transaction data load loading to target which one(target) have your info object.

    please check long text message and see the more details about locking.

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 02, 2015 at 12:48 PM

    Hi,

    You can check SM21 and  SM12 for the lock and Database error details to get more insight. May be it is locked using parallel process:Can you try to run using one batch process in DTP stetting and check if that get success ?

    Thanks,

    -J

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 02, 2015 at 01:19 PM

    Hi

    Can you please check if any other ACR jobs are running at the same time from sm37 logs?

    As far as I know only one ACR should run at a time

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 02, 2015 at 01:24 PM

    Hi Guru,

    Can you click on the symbol in the error message for detailed log and paste here for reference, also check in SM12 for locks. May be that is being used in somewhere at the same time when ACR is running.

    Regards,

    Vengal.

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 03, 2015 at 04:53 AM

    Hi Guru,

    I guess all this process which you are doing is manual and you want some automated way to resolve this.

    I will suggest for this you can mantain one table in dictionary with following entries.

    in above case you already mainain chain name in this table(one time activity) & when u are going for data loading(updating) then you set X in Active column(with updated last modified date and time).

    now question is how you can do active entry as X or blank.

    --> you need to do this inside process chain abap step.(before data load/ACR you need to put abap step)

    so every time when you want to daata load/ACR you need to check in this table whether the process chain is ACTIVE or not(means set X in table or not for respective process chain).

    If PC active state = blank.

    Then run ACR/data load.

    If PC acitbe state = X.

    Then stop the process chain with red status.--> so in this scenario you got to know some other process ACR is still going on.

    Regards,

    Hitesh


    Capture.PNG (8.3 kB)
    Add comment
    10|10000 characters needed characters exceeded