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

Runtime Error SAPSQL_ARRAY_INSERT_DUPREC for Insertio on table PBED

Hi,

Is there any SAP Note to rectify the error or any solution?

It happened in standard program : SAPLM60U. Include name : LM60UF0P Form name : PBET_BEARBEITEN

ST22 information below:

Error Analysis:

An exception occurred that is explained in detail below.

The exception, which is assigned to class 'CX_SY_OPEN_SQL_DB', was not caught

in

procedure "PBET_BEARBEITEN" "(FORM)", nor was it propagated by a RAISING

clause.

Information on where terminated
Termination occurred in the ABAP program "SAPLM60U" - in "PBET_BEARBEITEN".
The main program was "RSM13000 ".

In the source code you have the termination point in line 272
of the (Include) program "LM60UF0P".
The program "SAPLM60U" was started in the update system.
The termination is caused because exception "CX_SY_OPEN_SQL_DB" occurred in
procedure "PBET_BEARBEITEN" "(FORM)", but it was neither handled locally nor
declared
in the RAISING clause of its signature.

The procedure is in program "SAPLM60U "; its source code begins in line
203 of the (Include program "LM60UF0P ".

source code.jpg (47.6 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Sep 02, 2013 at 11:46 AM

    Hi Paul,

    some entries already exist in this table:

    Try to reproduce this error and debug this line. So you can see, which entries should be inserted. (Itab: da_pbedi)

    There are two Scenarios:

    Same primary keys or same unique index.

    If you enhanced this table with a unique Index, check if you need it as unique...

    Otherwise you have some inconsistencies. You could check SM13 for Example if some Update-Processes are still to be executed.

    regards

    Jan Martin

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 02, 2013 at 11:49 AM

    Hi Paul,

    do you has copied customizing from one system to another?

    Because it seems that a number range has problems.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 02, 2013 at 11:51 AM

    Hi Paul,

    It is a standard error but custom one...

    What I mean is the table is already having the entry you are showing in the debug mode activate update debugger and put a breakpoint on this line.

    Check the entries in this table and check if the entry with this key is already existing in the PBED table.

    Also check if the number range [if any for this field] has been reset.

    Regards

    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.