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

MM42 change material, split valuation at batch level, M301, locking table

Dear All,

I'm working on ECC 6.0 retail and I have activated split valuation at batch level. Now in MBEW for this specific material I have almost 14.400 entries.

If I try to change some material data (MM42) I receive an error message M3021 A system error has occurred while locking and then Lock table overflow.

I used SM12 to see the table (while MM42 is still running) and it seems that MBEW is the problem.

What should I do? For any material modification the system has to modify every entry in MBEW? Is there any possibility to skip this?

Thank you.

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Posted on Jun 10, 2010 at 09:33 PM

    had you already searched for OSS notes?

    Talk to your basis guys to increase the size of the locking table.

    Archive the batches with SARA object MM_SPSTOCK

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks Jürgen!

      I have searched for Sap Notes but nothing seems to solve my problem. I will forward your answer to the basis consultant to see if this will solve the problem. If not, we will consider archiving the batches.

      There are no other solutions?

      Thanks again for your help.

      Florina

  • author's profile photo Former Member
    Former Member
    Posted on Jun 11, 2010 at 06:39 AM

    Hi,

    First, is this mass update going to happen on reguarly?

    If no - you may want to further increase enque/table_size until it can finish this one-time run of the mass update.

    If yes - you may want to work with your SAP basis guy and read note 13907. From your side, you may need to reduce the volume of this mass update. From the basis side, they need to determine a proper size for the enqueue table size.

    Try this option also:-

    Set enque/table_size to maximum (check RZ11) and monitor the statistics in SM12. This is all that can be done to support large updates.

    Hope this will solve your problem,

    pherasath

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 11, 2010 at 06:43 AM

    Hi,

    Symptom

    Key word: Enqueue

    FM: A system error has occurred in the block handler

    Message in the syslog: lock table overflowed

    Other terms

    M3021 MM02 F5 288 F5288 FBRA

    Reason and Prerequisites

    The lock table has overflowed.

    Cause 1: Dimensions of the lock table are too small

    Cause 2: The update lags far behind or has shut down completely, so that the lock entries of the update requests that are not yet updated cause the lock table to overflow.

    Cause 3: Poor design of the application programs. A lock is issued for each object in an application program, for example a collective run with many objects.

    Solution

    Determine the cause:

    SM12 -> Goto -> Diagnosis (old)

    SM12 -> Extras -> Diagnosis (new)

    checks the effectiveness of the lock management

    SM12 -> Goto -> Diagnosis in update (old)

    SM12 -> Extras -> Diagnosis in update (new)

    checks the effectiveness of the lock management in conjunction with updates

    SM12 -> OkCode TEST -> Error handling -> Statistics (old, only in the enqueue server)

    SM12 -> Extras -> Statistics (new)

    shows the statistics of the lock management, including the previous maximum fill levels (peak usage) of the partial tables in the lock table

    If the owner table overflows, cause 2 generally applies.

    In the alert monitor (RZ20), an overrunning of the (customizable) high-water marks is detected and displayed as an alert reason.

    The size of the lock table can be set with the profile parameter u201Cenque/table_size =u201C. specifies the size of the lock table in kilobytes. The setting must be made in the profile of the enqueue server ( u2026_DVEBM.. ). The change only takes effect after the restart of the enqueue server.

    The default size is 500 KB in the Rel 3.1x implementation of the enqueue table. The resulting sizes for the individual tables are:

    Owner table: approx 560.

    Name table: approx 560.

    Entry table: approx 2240.

    As of Rel 4.xx the new implementation of the lock table takes effect.

    It can also be activated as described in note 75144 for the 3.1I kernel. The default size is 2000 KB. The resulting sizes for the individual tables are:

    Owner table: approx 5400

    Name table: approx 5400

    Entry table: approx 5400

    Example: with the

    u201Cenque/table_size =32000u2033 profile parameter, the size of the enqueue table is set to 32000 KB. The tables can then have approx 40,000 entries.

    Note that the above sizes and numbers depend on various factors such as the kernel release, patch number, platform, address length (32/64-bit), and character width (Ascii/Unicode). Use the statistics display in SM12 to check the actual capacity of the lock table.

    If cause 2 applies, an enlargement of the lock table only delays the overflow of the lock table, but it cannot generally be avoided.

    In this case you need to eliminate the update shutdown or accelerate the throughput of the update program using more update processes. Using CCMS (operation modes, see training BC120) the category of work processes can be switched at runtime, for example an interactive work process can be converted temporarily into an update process, to temporarily increase the throughput of the update.

    For cause 3, you should consider a tuning of the task function. Instead of issuing a large number of individual locks, it may be better to use generic locks (wildcard) to block a complete subarea. This will also allow you to considerably improve the performance.

    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.