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

[Former Member]

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.

[Former Member]

Hi

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

[Former Member]

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.....

[Former Member]

thank u