topic Re: Error info... 00 671: ABAP/4 processor: SAPSQL_ARRAY_INSERT_DUPREC in Application Development and Automation Discussions

Error info... 00 671: ABAP/4 processor: SAPSQL_ARRAY_INSERT_DUPREC

Former Member — Tue, 15 Dec 2009 12:51:13 GMT

Hi All,

We are using BAPI BAPI_PRDSRVAPS_SAVEMULTI2 for product creation and return table does not return any values but following dump message is created:-

Update was terminated

Transaction.. SE38

Update key... 4B2771FC66B412D3E10000009B7DA72E

Generated.... 15.12.2009, 12:52:45

Completed.... 15.12.2009, 12:52:46

Error info... 00 671: ABAP/4 processor: SAPSQL_ARRAY_INSERT_DUPREC

We are already checking if the product exists and exclude those records from creation but still this message is updated in the SAP mailbox.

Can somebody suggest the rootcause for this issue and how

Regards,

Chandan

JL23 — Tue, 15 Dec 2009 12:54:47 GMT

you have to analyze the root cause in SM13

It is for sure that SAP tries to insert a record into a table that has already an entry with the same key.

This often happens if someone has reset a number range (or transported a number range from a developement client)

Former Member — Sat, 19 Dec 2009 10:07:13 GMT

Hi Chandan,

To translate this dump into plain english, you are inserting the data in the dbtable in that line which is already filled.

You can delete the previous filled data from that table and this error would be gone or change the key through which you are inserting the data.

rgrds,

Yashwin