cancel
Showing results for 
Search instead for 
Did you mean: 

While trying to change a BOM with transaction CS02, a runtime error appears

Former Member
0 Kudos

While trying to change a BOM with transaction CS02, a runtime error appears.

In intial screen he entered material ,plant BOM usage and date valid from after executed then id displayed item list in that he wantu2019s delete one item, he has been deleted selected item after that when he was saving he is getting runtime error

Developer trace

ABAP Program SAPLKED1_WRITE_CE4_BPS1 .

Source LKED1_WRITE_CE4_BPS1U01 Line 30.

Error Code SAPSQL_ARRAY_INSERT_DUPREC.

Module $Id: //bas/640_REL/src/krn/runt/absapsql.c#17 $ SAP.

Function HandleRsqlErrors Line 775.

    • RABAX: level LEV_RX_STDERR completed.

    • RABAX: level LEV_RX_RFC_ERROR entered.

    • RABAX: level LEV_RX_RFC_ERROR completed.

    • RABAX: level LEV_RX_RFC_CLOSE entered.

    • RABAX: level LEV_RX_RFC_CLOSE completed.

    • RABAX: level LEV_RX_IMC_ERROR entered.

    • RABAX: level LEV_RX_IMC_ERROR completed.

    • RABAX: level LEV_RX_DATASET_CLOSE entered.

    • RABAX: level LEV_RX_DATASET_CLOSE completed.

    • RABAX: level LEV_RX_RESET_SHMLOCKS entered.

    • RABAX: level LEV_RX_RESET_SHMLOCKS completed.

    • RABAX: level LEV_RX_ERROR_SAVE entered.

    • RABAX: level LEV_RX_ERROR_SAVE completed.

    • RABAX: level LEV_RX_ERROR_TPDA entered.

    • RABAX: level LEV_RX_ERROR_TPDA completed.

    • RABAX: level LEV_RX_PXA_RELEASE_RUDI entered.

    • RABAX: level LEV_RX_PXA_RELEASE_RUDI completed.

    • RABAX: level LEV_RX_LIVE_CACHE_CLEANUP entered.

    • RABAX: level LEV_RX_LIVE_CACHE_CLEANUP completed.

    • RABAX: level LEV_RX_END entered.

    • RABAX: level LEV_RX_END completed.

    • RABAX: end RX_RFC

In sm21

Perform rollback

Run-time error "SAPSQL_ARRAY_INSERT_DUPREC" occurred

 Short dump "090618 110101 donalda 11557 " generated

Runtime Error SAPSQL_ARRAY_INSERT_DUPREC

Exception CX_SY_OPEN_SQL_DB

Occurred on 18.06.2009 at 11:01:01

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

What happened?

Error in ABAP application program.

The current ABAP program "SAPLKED1_WRITE_CE4_BPS1" had to be terminated because

one of the

statements could not be executed.

This is probably due to an error in the ABAP program.

What can you do?

Print out the error message (using the "Print" function)

and make a note of the actions and input that caused the

error.

To resolve the problem, contact your SAP system administrator.

You can use transaction ST22 (ABAP Dump Analysis) to view and administer

termination messages, especially those beyond their normal deletion

date.

Error analysis

An exception occurred. This exception is dealt with in more detail below

. The exception, which is assigned to the class 'CX_SY_OPEN_SQL_DB', was

neither

caught nor passed along using a RAISING clause, in the procedure

"RKE_WRITE_CE4__BPS1" "(FUNCTION)"

.

Since the caller of the procedure could not have expected this exception

to occur, the running program was terminated.

The reason for the exception is:

If you use an ABAP/4 Open SQL array insert to insert a record in

the database and that record already exists with the same key,

this results in a termination.

(With an ABAP/4 Open SQL single record insert in the same error

situation, processing does not terminate, but SY-SUBRC is set to 4.)

How to correct the error

The exception must either be prevented, caught within the procedure

"RKE_WRITE_CE4__BPS1"

"(FUNCTION)", or declared in the procedure's RAISING clause.

To prevent the exception, note the following:

Use an ABAP/4 Open SQL array insert only if you are sure that none of

the records passed already exists in the database.

You may able to find an interim solution to the problem

in the SAP note system. If you have access to the note system yourself,

use the following search criteria:

-


"SAPSQL_ARRAY_INSERT_DUPREC" CX_SY_OPEN_SQL_DBC

"SAPLKED1_WRITE_CE4_BPS1" or "LKED1_WRITE_CE4_BPS1U01"

"RKE_WRITE_CE4__BPS1"

-


If you cannot solve the problem yourself, please send the

following documents to SAP:

1. A hard copy print describing the problem.

To obtain this, select the "Print" function on the current screen.

-

2. A suitable hardcopy prinout of the system log.

To obtain this, call the system log with Transaction SM21

and select the "Print" function to print out the relevant

part.

3. If the programs are your own programs or modified SAP programs,

supply the source code.

To do this, you can either use the "PRINT" command in the editor or

print the programs using the report RSINCL00.

4. Details regarding the conditions under which the error occurred

or which actions and input led to the error.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi ,

you are getting beacuse u are trying to do mass update to database.

Please check that below note are applicable to your system.

Note 453313 - DBIF_RSQL_ERROR_INTERNAL for mass insert

Note 869534 - AFS MRP doesn't work properly with all BOM item categories

Thanks Rishi Abrol

Answers (0)