Skip to Content
avatar image
Former Member

The ABAP/4 Open SQL array insert results in duplicate --

Hi all,

We are trying to CIF materials from R/3 to APO and we are facing the following error "The ABAP/4 Open SQL array insert results in duplicate".

There are no entries in table /SAPAPO/MATKEY, /SAPAPO/MATLOC, /SAPAPO/MATMAP

Still its showing error.

Kindly suggest where else we can look for the entries.

Best regards,

~Vaibhav

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Oct 09, 2008 at 04:23 PM

    Is there any application log entry for these errors ? in R/3 end.

    Else double click on these errors in /sapapo/cq (at APO end)and check if any further detail available ?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 09, 2008 at 04:33 PM

    Please run livechache consistency check /SAPAPO/OM17.

    Clear all the queues in SMQ1/SMQ2 both in R/3 and APO.

    Run CCR report and than create and active IM again.

    Hope it will resolve the issue.

    Also check below OOS note it is fit in your system and problem:

    1. 0.510 SCM-APO-INT-MD-PPM 443174 ABAP/4 Open SQL array insert results in duplicate database 03.06.2003

    2. 0.470 SCM-APO-INT-MD-PPM 421896 The ABAP/4 Open SQL array insert results in duplicate 27.02.2002

    3. 0.380 SCM-APO-INT-SLS 958663 Duplicate records error during saving of sales doc in SCM 02.08.2006

    4. 0.380 SCM-APO-SPP-SRE 1097525 Error 'CX_SY_OPEN_SQL_DB' when running DRP 28.09.2007

    5. 0.370 SCM-APO-INT 149075 Re-transfer causes duplicate entries 03.05.2000

    6. 0.370 SCM-APO-INT 149536 Duplicate entries during key completion 30.04.1999

    7. 0.360 SCM-APO-ATP-BOP 989113 PAL: Update incorrect because of schedule line level check 31.03.2008

    8. 0.360 SCM-APO-ATP-BOP 980764 /SAPAPO/BOP: SAPSQL_ARRAY_INSERT_DUPREC dump when STO & PAL

    Manish

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 10, 2008 at 12:42 AM

    Please check application log SLG1 or queue manager /sapapo/cq for more details.I assume you are running delta CIF run using CFM1 IM creation & CFM3 IM activation.Can you try running total refresh CIF program RIMODINI , before running this please delete any queue block relevant to this error from SMQ1 & SMQ2.

    Also check OSS note 606883 - relevant to your issue

    https://websmp230.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=606883

    Sanjay Karkun

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 10, 2008 at 04:49 AM

    Hi All,

    I have found the answer for it. Additionally material entry needs to be removed from /SAPAPO/MATEXEC

    Best regards,

    Add comment
    10|10000 characters needed characters exceeded