Skip to Content

SAPSQL_ARRAY_INSERT_DUPREC: STATUS UPDATE TX MIGO_GR

Hi All,

Upon processing MIGO_GR we're getting an error of EXPRESS DOCUMENT and the number range intervals skips 10 matdocs ( MATDOC 5_010 became MATDOC 5_020 which is supposed to be MATDOC 5_011).

As per checking with ST22 / SM13 we got SAPSQL_ARRAY_INSERT_DUPREC which says we got duplicate entries in our serials(serialnumber_post error) then later on the error moves in STATUS_UPDATE.

We have searched how to solve it,

• we tried to +1 in intervals

• Clear SM12

• Run Risteq07

• Run RS_UPDATE_STARTUP & RS_UPDATE_STATUS

But still fail to solve.

Please help on this guys.

sm13.png (17.0 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Oct 13, 2017 at 02:32 PM

    Hi All,

    Problems have been solved. Thanks Dibyendu Patra .

    Cause: Number Range for EQUIP_NR has been reached it's limit then the sequence repeat itself that lead to duplication of records

    Solution: SNRO > EQUIP_NR > ADJUST INTERVALS

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 13, 2017 at 12:01 PM

    When standard transaction gets dump without any custom enhancement, then always try to find OSS notes or KBA. I have tried to find the same and have found couple of OSS notes.

    I would suggest to try it yourself.

    Add comment
    10|10000 characters needed characters exceeded