Skip to Content
-2

DBSQL_DUPLICATE_KEY_ERROR in MM01

Hi Experts,

Need your help here. I am creating a Material in MM01, when i save the material is getting created, but I get the "Express document" error in the screen. if I go to ST22, i can see the dump as attached below.

The dump says, DBSQL_DUPLICATE_KEY_ERROR in MAKT.

Can anyone pls help?

Attached is the dump reference.img1.pngimg2.png

img1.png (20.4 kB)
img2.png (42.7 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Jul 24, 2017 at 06:36 AM

    If it is a customer program (you see the program in the short dump) tell it the developer. She must avoid writing duplicate entries. If it is a program delivered by SAP, report it to SAP. As a rule, such exceptions must be prevented or handled properly.

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 24, 2017 at 11:31 AM
    -1

    Apparently, you're trying to insert an entry that exists already in MAKT table. Is your material already created?

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 24, 2017 at 01:23 PM

    Hi,

    This is common issue ,faced it many times in previous project. Very recently we faced this issue after EHP8 upgrade.Sales order,delivery,purchase order etc giving dump at random due to old number being assigned.

    Since this is standard program,so how do you overcome this in the middle of a project?

    You need to setup manually the correct number range or need to check if number range buffering is active ,then need to flush the memory buffer.Please follow this link to reorg/reset ongoing number ranges.

    SAP help

    Regards,

    Avik

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 24, 2017 at 11:31 AM

    Probably some hundred times discussed already.

    You are in MM01, so it is SAP standard, as your information from the dump shows too.

    And if the dump is caused by the fact that the program failed to create a duplicate record, then it is usually originated from the fact that the number range is not consistent with the data in your system. And hence a new number which is automatically taken from the number range is identical to an existing master record in your database.

    So you need to analyse which numbers you already have used (in table MARA) and if the number range is telling here a different story.

    Then think how the data came into the system (IDocs can create material master with external numbers which fall into your internal range) or whether someone (you or your colleagues) changed and transported number ranges.

    Add comment
    10|10000 characters needed characters exceeded