topic The ABAP/4 Open SQL array insert results in duplicate database records? in Application Development and Automation Discussions

The ABAP/4 Open SQL array insert results in duplicate database records?

Former Member — Thu, 20 Nov 2008 12:57:31 GMT

Hi,

Experts,

I have imported CRMC_BLUEPRINT table structure and content from one Ecc6.0 it successfully completed.

Now i am exporting these structure and content into another Ecc6.0 structure is created successfully but while exporting table content i am getting run time error as 'The ABAP/4 Open SQL array insert results in duplicate database records".

Please suggest me how to over come from these error i am new to this .

Thank u,

Shabeer Ahmed.

Re: The ABAP/4 Open SQL array insert results in duplicate database records?

Former Member — Fri, 21 Nov 2008 03:48:17 GMT

Make sure you are not inseritng duplicate reocrds in the table.

This error normally happens if you try to insert records with same primary keys again and again.

If records already exist you will get this dump.

Please check following links they might be useful:

1-http://sap.ittoolbox.com/groups/technical-functional/sap-basis/sapsql_array_insert_duprec-error-while-activating-ods-893003

It can be a basis problem also ,in order to figure out the exact problem ,first analyze the dump and then

enter the dump description in SAP service market place and search for the appropriate OSS note for the same.

Regards

Neha

Re: The ABAP/4 Open SQL array insert results in duplicate database records?

Former Member — Fri, 21 Nov 2008 11:51:35 GMT

Duplicate database errors usually occurs if there are more than one entry which is having the same primary key fields...which is totally not acceptable...

However you can skip this dump by writing insert.......ACCEPTING DUPLICATE.....

Re: The ABAP/4 Open SQL array insert results in duplicate database records?

Former Member — Wed, 03 Dec 2008 09:21:41 GMT

thank u