error rectification

[Former Member]

Hi,

I got one error regarding while 'creating production order conformation'.

the runtime error is'Runtime error sapsql_array_insert_duprec has occured'

How to rectify and what is the meaning of that i'm unable to get?

please give the suggestion..

Thanks,

srii.

[former_member265047]

Hi Sridhar,

Pl. let me know when are u getting this error, any standard program is giving this error or ur custom program giving this error.

The meaning of this error is when ever you re trying to insert duplicate records in to internal table or db table , we will get this message. You can do the dump analysis in ST22 and analyse the in which context you re getting this error message.

If any standard program throwing this error message, then u can check for any OSS note to rectify that.

Pl. let me know if you need any other information.

Regrads,

Naveen Veshala

[Former Member]

hi naveen,

Thanks for your replay.

yes,I have standard program in that customized include zapp01.

I'm unable to getting either standard program or customized include thwoing this error messge,by debugging also i dint find..

so, can u give me more clear.

Thanks,

srii.

[former_member265047]

Hi Sridhar,

You can go through ST22 and check this dump or you can paste that whole dump , then we can able to analyse that where exactly you are getting problem.

Regards,

Naveen Veshala

[Former Member]

Hi Naveen,

The error dump is like this.

Runtime Error SAPSQL_ARRAY_INSERT_DUPREC

Except. CX_SY_OPEN_SQL_DB

Date and Time 02.07.2008 18:02:54

ShrtText

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

What happened?

Error in ABAP application program.

The current ABAP program "SAPLKAUP" 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.

is especially useful if you want to keep a particular message.

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

"INSERT_TABLES" "(FORM)"

.

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.)

to correct the error

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

"SAPLKAUP" or "LKAUPF01"

"INSERT_TABLES"

-

---

If you cannot solve the problem yourself and you wish to send

an error message to SAP, include the following documents:

1. A printout of the problem description (short dump)

To obtain this, select in the current display "System->List->

Save->Local File (unconverted)".

2. A suitable printout of the system log

To obtain this, call the system log through transaction SM21.

Limit the time interval to 10 minutes before and 5 minutes

after the short dump. In the display, then select the function

"System->List->Save->Local File (unconverted)".

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

supply the source code.

To do this, select the Editor function "Further Utilities->

Upload/Download->Download".

4. Details regarding the conditions under which the error occurred

or which actions and input led to the error.

The exception must either be prevented, caught within the procedure

"INSERT_TABLES"

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

To prevent the exception, note the following:

stem environment

SAP Release.............. "640"

Application server....... "jmqas"

Network address.......... "20.201.80.13"

Operating system......... "Windows NT"

Release.................. "5.2"

Thanks,

srii.

[soumya_jose3]

Hi Sridhar,

In the form INSERT_TABLES you are inserting duplicate records, means in a database table you are trying to insert one more record which is already existing with the same key.

Regards,

Soumya.

[former_member265047]

Hi Sreedhar,

SAP standard program is causing this dump, even i can see so many oss notes in the service market place for the search criteria provided in the short dump, My suggestion is you can search relavant OSS notes or you can log a call in service site, so that they can help you to identify correct oss notes.

Regards,

Naveen Veshala