topic Re: SAPSQL_ARRAY_INSERT_DUPREC Exception in Application Development and Automation Discussions

SAPSQL_ARRAY_INSERT_DUPREC Exception

Former Member — Fri, 04 Apr 2008 08:59:15 GMT

hi all

can anybody help me to get details regarding the exception

SAPSQL_ARRAY_INSERT_DUPREC exception

CX_SY_OPEN_SQL_DB.

the termination occured in abap program.............

hw i can rectify it????

rewards will be given for useful answers

Re: SAPSQL_ARRAY_INSERT_DUPREC Exception

Sm1tje — Fri, 04 Apr 2008 09:07:39 GMT

You are trying to insert data into a database table for an entry that already exists. Before insert, make sure record is not yet in database table. If already existant, do an update of the record.

Re: SAPSQL_ARRAY_INSERT_DUPREC Exception

Former Member — Fri, 04 Apr 2008 11:14:16 GMT

it is a standard sap program.i cant change it,

is there any solution?

Re: SAPSQL_ARRAY_INSERT_DUPREC Exception

Former Member — Fri, 04 Apr 2008 11:20:14 GMT

Hi there,

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

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,

I request you to take it on high priority basis as this is an daily load and because of the red request next request will not be activated.

I think this is due to duplicate entry but i have checked the data their is no duplicacy. In that request we have only 7 request and all are in Active table.

Do reward if helpful or get back if need further assistance.

Re: SAPSQL_ARRAY_INSERT_DUPREC Exception

Former Member — Fri, 04 Apr 2008 13:07:59 GMT

Hi,

This is due to primary key violation....U r trying to insert records which are already available in DB table..so best practice is to use MODIFY statement instead of INSERT.

MODIFY will insert records if not present in table and it will modify the record if present already

Regards,

Hari