SAPSQL_ARRAY_INSERT_DUPREC

[Former Member]

Dears,

We are getting following dump today while creating order by IW31.Order is generating but on searching system says " It does not exist".

Runtime Error SAPSQL_ARRAY_INSERT_DUPREC

Except. CX_SY_OPEN_SQL_DB

Date and Time 10.06.2009 16:54:25

Error in ABAP application program.

The current ABAP program "SAPLCOVB" had to be terminated because one of the

statements could not be executed.

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

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 "AFFL_POST"

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

Please suggest.

Shivam

[Former Member]

(causes for the number range inconsistency )

Overflow of the number range interval, OR Initialization of the current number level OR Manual resetting of the current number level,

Can you pls check the note 126063 .

Thanks

Sirigiri

[Former Member]

Hi,

Can you please check SAP Note 312115 (PM order:Duplicate completn confirmtn no.in opertns)

regards,

Subhajit.

[former_member204746]

did someone play around with number ranges? If not, transfer this to your functional team.

[former_member617960]

Dear Sir,

Can you provide specific detail of Object Number Ranges ..

The Case is as below.

We have Copied the Production Client to a another client for testing a third party application. but after coping the client , as we create the order by Tcode IW31, we are getting the Order No Generated but as we again try to open this order it shows " The Order Does Not Exists". Can you help on this regard forther to at Table/Object Level .

Thanks in Advance

Raj

[Former Member]

Hi,

Insert_Duprec means table already having record which ur trying to insert new record.

Table having primary key or Unique key so this dump coming.

If it is Ztcode then contact to abaper.

Surendrajain