SAP Note 1074030 - R3trans: "Duplicate key" composite SAP note (as of Rel 6.10)

Component : Transport Tools - Upgrade Tools

Solution : https://service.sap.com/sap/support/notes/1074030 (SAP Service marketplace login required)

Summary :
This SAP Note addresses the issue of R3trans termination during imports due to a "duplicate key" error when inserting an array in SAP_BASIS Release 6.10 and later. It outlines possible causes such as multiple unique indexes, missing primary indexes, inconsistent key fields in the source and target system, and database-specific errors. Solutions involve adjusting table definitions, recreating indexes, modifying key structures, and using updated R3trans versions. It emphasizes the importance of a detailed problem analysis to identify the correct cause before referring to this composite note to resolve the issue. The note also details various conditions under specific database management systems that can lead to this error, offering solutions like database patches and correct procedures during table transport.

Key words :
db interface  2eetw000      db call info  2eetw000 function, cdmmt cosrv konv m_mbanp t622 wlk1 solution, sap service marketplace software center, ebp support package 6- sapk-603ddinsapappl, directory /usr/sap/upgrade/exe, r3transoptions = dbcalltrace=dbtrace safeandslow=yesthis, omit parallel import processes or3, /usr/sap/trans/cofiles, /usr/sap/put/cofiles, rt_mi_end function code represents

Related Notes :

1603705R3trans: Error does not cause return code 8 or higher
1260968COPYTOSHADOW: R3trans loses reports
1247020OTR: Texts are not transported
1173582Error occurs during export: invalid value '...' in E071.LANG
1164883RFDOPR10/RFDSLD00/RFKSLD00: Variants with special characters
1079778DB2-z/OS: SAPKB71002 duplicate key error on WDKFIELDS
1028798DB6: UTF-8 to UCS-2 conversion may result in subst. char
822379Known problems with Support Packages in SAP NW 7.0x AS ABAP
802371TK 364: Request contains corrupted (non-ASCII) table key
731478Error during SAPK-10026INHRCEE import or upgrade process
718511R3trans: Export error due to "scrap characters"
695899Multibyte character set in SAP-R/3
672651OCS: Known problems with Support Packages in Basis Rel.6.40
638357Transport between Unicode systems and non-Unicode systems
626915Transport problems with tables with a unique index
600027Installing the Corrected MS SQL Server Collation
563543CRM3.0 SP9 and SP12 import not possible in the same queue
539519Ramp-up 2: Upgrading to SAP R/3 Enterprise Core 4.70
532563R3trans: Duplicate key error with NUMC fields
513536Add. information on upgrade to SAP R/3 Enterprise Core 4.70
452710duplicate record with RSMPTEXTS/EUDB table
376746DB6: Display of COLLATING SEQUENCE from database
335455R3trans: duplicate key error for key with _
333534R3trans: Performance during import of table with INT fields
317229Error during tp, R3trans or Support Package import
185822ora-1555 - cause and action
88656R3trans: Duplicate key composite SAP note (Release 4.0-4.6)
80727Transporting non-LATIN-1 texts
60233Oracle rollback segments, more information.
45548Transporting language-dependent objects
28324R3trans: Composite note "duplicate key" array insert
19466Downloading SAP kernel patches