Skip to Content

Unable to save Delivery Note

Hi,

need some help.

I have a sales order but when i am doing my delivery, system will give me a DN number but when i search the system for the document. It does not exist.

Then i went to ST22 to view the short dump, there is a error saying that

"The ABAP/4 Open SQL array insert results in duplicate database records."

when i go to the line in the code where the error occurs, it shows that there is error when they try to insert into LIPS table and i assume it found duplicate records.

I search OSS notes and it says when you combine 2 sales order into 1 delivery, duplicate records might occur due to the item number being identical. But the thing is i am doing 1 order 1 delivery, there should not be identical item number.

Pls help.

Add a comment
10|10000 characters needed characters exceeded

Related questions

6 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jun 08, 2007 at 01:14 AM

    looks like problem at LIKP and LIPS table ,activate the table in se11 ,and check the transaction again in VL01N and see the results.

    if not then talk to basis guy

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 08, 2007 at 01:18 AM

    funny thing is this does not happen always. But once in a while this happens to my delivery. so it is hard to pinpoint the problem. And when i use the user's id, i am unable to save properly. But when i use my own id(more powerful), i am able to save without problem.

    Unable to simulate in my testing server because i do not know where the error lies.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      The error you are getting is SAP_SQL_DUPREC. This most probably happens in the partner determination area, and mostly due to incorrect coding in user-exits. You can search for the *DUPREC text in SAP Notes and you will find one Note which explains how to correct this error.

  • author's profile photo Former Member
    Former Member
    Posted on Jun 08, 2007 at 07:02 AM

    Hi Dylan,

    Please check in SM13 for any update termination. You can find the log of update terminations. In this log, you will find the reason for update terminations.

    Most of the times, this update terminations might be due to text objects. Check in your line item level, whether any mandatory texts are not maintained.

    This can also happen due to printers no longer in use and are still mentioned in condition types.

    Please check in this direction.

    Hope this helps,

    Thanks & Regards,

    CLN

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 08, 2007 at 07:15 AM

    I checked SM13 and found that the system is trying to insert 2 lines of 0040 into LIPS but on the delivery note, it shows as 1 line.

    Is there anyway to prevent this from happening?

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 08, 2007 at 07:47 AM

    i don't think it could be with authorisation. User is able to create delivery for that plant but once in a while it just does not work

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 12, 2007 at 05:08 AM

    Hi,

    The SAP Note you should read carefully is:

    575667 - FAQ: Runtime error in delivery processing

    Best Regards

    Nikhilesh

    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.