cancel
Showing results for 
Search instead for 
Did you mean: 

Error when locking update of table

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

Hi,

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

Thanks,

Naveen

Answers (5)

Answers (5)

former_member183519
Contributor
0 Kudos

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

RamanKorrapati
Active Contributor
0 Kudos

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

former_member186053
Active Contributor
0 Kudos

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.

yashcp
Active Participant
0 Kudos

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

Former Member
0 Kudos

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