ABAP dump SAPSQL_ARRAY_INSERT_DUPREC

[Former Member]

Hi ,

ABAP dump SAPSQL_ARRAY_INSERT_DUPREC has been generated with error message The ABAP/4 Open SQL array insert results in duplicate database records.The current ABAP program "SAPLMLVK" had to be terminated because one of the

statements could not be executed.

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

"MS_UPDATE_ACCOUNT_SERVICE" "(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.

Also the update termination error is alos appearing in SM13 for the same dump.

please suggest.

Thanks & regards

Joy Garg

[Former Member]

Hi Joy,

Check user might trying to post a duplicate entry.

Cheers

Deepanshu

[Former Member]

Hi,

This is configuration issue so consultant your related functional team.they can check number range .

If it is Zprogram then also inform to abaper

Note 1251231 - SAPSQL_ARRAY_INSERT_DUPREC

SurendraJain

[former_member475159]

Hi Joy,

This error means that a transaction / program was attempting to commit

information to the database that would result in a duplicate entry in a

table with primary key. Depending on when and where you are getting it it

can be caused by some SAP bugs in Phsyical Inventory Document Clearing,

number ranges being out of synchronisation after a client copy etc.

Please give the details of your system i.e (OS,DB and SAP release)

Also tell me whether your system is ECC or BW or SCM or anyother.

This dump can occur in many scenarios. Tell me the action when you are getting the error.

For your information

just check this out with the user what he is doing or check it out the functinal consultant but I guess this is not a big issue as the error SAPSQL_ARRAY_INSERT_DUPREC indicates he was trying to insert duplicate records in the table and hence the update failed,these are very common errors and can be ignored

Thanks

Debdeep

Edited by: Debdeep Ray on Jul 23, 2009 4:12 PM

[Former Member]

Hi,

os : Windows 2000

DB : Oracle 10.2

SAP : r/3 4.7 c

The user is marketing guy & user was trying to run tcode ME23N.

Also please suggest shalli delete the update error in SM13. Will it affect anything?

Thanks & Regards

Joy Garg

[anindya_bose]

Hi Joy

Check the follwoing links.

You should delete the update error from sm13 and the run the update again.

From st22 short dump try to identify the table where duplicate records exists.

[former_member475159]

Hi Joy,

Please check the link

Please check the note

Note 54021 - Termination SAPSQL_ARRAY_INSERT_DUPREC in ME21, ME22

Regrading SM13 screen, You can delete the data, but the data that the user trying to enter will not be saved.The user have to enter it once again.

Thanks

Debdeep

Edited by: Debdeep Ray on Jul 23, 2009 5:26 PM