cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Hi All,

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

Best regards,

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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 ?