Skip to Content
author's profile photo Former Member
Former Member

Error with "Attribute Change run" jobs...

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Feb 08, 2005 at 02:56 PM

    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)'

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 08, 2005 at 03:02 PM

    John,

    I think this is the solution !

    Note 785840 'Multiple change runs are started simultaneously' and

    730980 'Realignment run blocked when started'

    Bye,

    Roberto

    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.