topic Re: SAPSQL_ARRAY_INSERT_DUPREC Exception in Application Development and Automation Discussions

SAPSQL_ARRAY_INSERT_DUPREC Exception

omar_elkassi2 — Thu, 20 Oct 2011 14:46:27 GMT

Hi Expert,

I have a serieus problem in a specifique programm. during Execution i Have a SAPSQL_ARRAY_INSERT_DUPREC exception. when i check in the ST22 i have the details below :

error source : " >>>>> insert (x_tabname) from table x_profval."

Variable values a the time of the exception : X_TABNAME refers to " EPROFVALMONTH" table.

values of xprofval_ key fields are : 000000000001066507 and 20110801 as date.

when I check tha table X_PROFVAL for entries with this Key values, i don't found records. so i can't understand how can i have a duplicated ket Insert problem if no data exist in this Table.

Thanks a lot,

Omar.

Re: SAPSQL_ARRAY_INSERT_DUPREC Exception

Former Member — Thu, 20 Oct 2011 15:01:19 GMT

The duplicates are in EPROFVALMONTH, not X_TABNAME.

Rob

Re: SAPSQL_ARRAY_INSERT_DUPREC Exception

omar_elkassi2 — Thu, 20 Oct 2011 15:35:02 GMT

Exectly. sorry for the writing mistak. i checked EPROFVALMONTH where no records found four my key fields.

Re: SAPSQL_ARRAY_INSERT_DUPREC Exception

Former Member — Thu, 20 Oct 2011 22:01:50 GMT

The dump will not only be if the key entry already exist in the database table but also if the Internal table x_profval has two rows with same key values ( "000000000001066507" and "20110801" ) at the time of Insert.

Re: SAPSQL_ARRAY_INSERT_DUPREC Exception

Subhankar — Thu, 20 Oct 2011 23:14:55 GMT

To analysis the issue, I will suggest to add the try catch block.

TRY .

INSERT ZTAB FROM wa.

CATCH sapsql_array_insert_duprec.

Write : wa. " You can write the key fields only,

ENDTRY.

If you are inserting from internal table, then loop it and write the key fields. So from the output you can get the particular data.

Hope this will help your analysis.

Thanks

Subha

Re: SAPSQL_ARRAY_INSERT_DUPREC Exception

raviahuja — Fri, 21 Oct 2011 00:34:30 GMT

Hi,

Or you can use 'ACCEPTING DUPLICATE KEYS' in front of your insert statement. It won't give you dump at least. But make sure remove all duplicate entries for your table primary key. You can do this by sorting by primary key and using DELETE ADJACENT ENTRIES.

Thanks.

Ravi