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

SAPSQL_ARRAY_INSERT_DUPREC in iw21

Hi Experts,

we have upgraded EHP1 to EHP4 .After upgradation, if i am trying to create the notification in iw21 and assign an order to the notification and while saving it is getting saved. and issueing order no as 'X'(X belongs to different order type )..

And if i run Tcode iw22 ,if i check the order no (X) linked to the notification order no is not available.

If i see the st22 it is telling the error "SAPSQL_ARRAY_INSERT_DUPREC' and if i see the ABAP editor it is showing the error in

funtion module STATUS_UPDATE in include LBSVUU01 from the program SAPLCOZV

"

IF sy-tabix > 0.

INSERT jsto CLIENT SPECIFIED

FROM TABLE jsto_ins."

i have searched for the notes 970434, 82295.But i think that will not solve the issue. i dont know which note should be applied.

Could you please help me to solve the issue.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Nov 23, 2011 at 11:08 PM

    Such problems usually occur because of misaligned number ranges or incorrect custom code (enhancements, user exits and the like). It is difficult to give you the exact reason without analyzing the actual dump you are getting.

    The program terminates because it tries to insert a new status entry for the notification in the status table (JSTO). Apparently an entry with the same key exists already in this table that belongs to an already existing notification. The key for JSTO is derived from the notification number, it starts with QM...

    Check the dump to see what the notification number is (in internal table jsto_ins) and verify the number range statuses. Adjust the number range of the notification type if necessary so that it doesn't overlap with already existing notifications in the DB.

    Also, if you do have custom code / enhancements that are executed, it's possible that there is an illegal COMMIT that causes standard tables to get updated too early. If the number ranges are OK, that's also a possible area to check.

    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.