on 10-09-2008 5:19 PM
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
Hi All,
I have found the answer for it. Additionally material entry needs to be removed from /SAPAPO/MATEXEC
Best regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
15 | |
4 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.