cancel
Showing results for 
Search instead for 
Did you mean: 

Error with "Attribute Change run" jobs...

Former Member
0 Kudos

Hi,

We have multiple process chains for loading master data. One for SD, one for Finance etc. Each of those process chains have 'attribute change run' jobs in them for only the infoobjects in the respective chains. They start at different times independent of each other. Now the issue is, whenever these chains overlap, there has been a failure with 'deadlocks have occured' 'DB Exception failed' error messages. The process chains have independent InfoObjects and same InfoObject is not there in two chains. i would like to know what tables does an attribute change run job locks?

For example,

in job1, we have an infoobject Z_ONE which has 0PROFIT_CTR as a NAV attribute.

in job 2, we have another infoobject Z_TWO which also has 0PROFIT_CTR as a NAV attribute.

Now when an 'attribute change run' is running for Z_ONE, what tables does it lock? does it lock any of the 0PROFIT_CTR tables? If I start 'attribute change run' for Z_TWO, while the first one is running, does the second job fail because they have common Infoobjects as NAV attributes? If not, in what situations does the second job fail? What if the common attributes are disply attributes?

I tried to study the failed jobs. Looked at system log SM21, ST22, SM37 messages but from them, the exact failure reason is not obvious. SM12 can only display current locks status. System trace was turned off. Are there any other places where I can still find some info. Or are there any OSS messages?

Any suggestions/input/advice greatly appreciated.

Thanks

John

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

John,

I think this is the solution !

Note 785840 'Multiple change runs are started simultaneously' and

730980 'Realignment run blocked when started'

Bye,

Roberto

Former Member
0 Kudos

Hi John,

take a look to OSS Note 316329 'Master data table locked'...maybe it can be useful...

Bye,

Roberto

and to 421419 'Parallel loading of master data (several requests)'