Symptom
During an upgrade /update the error ORA-00001 unique constraint violated is encountered in DBCLONE phase but finding the duplicate records as per the script of the SAP Note 23237 does not result any rows .
The error looks similar to the below ones -:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
CLONING ERRORS and RETURN CODE in DBCLONE03.<SID>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
1EETGCLN ORA-00001: unique constraint (SAPSR3.TFAIT^0) violated
1EETGCLN TFAIT
1EETGCLN
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
CLONING ERRORS and RETURN CODE in DBCLONE01.<SID>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
1EETGCLN ORA-00001: unique constraint (SAPSR3.THOLT^0) violated
1EETGCLN THOLT
1EETGCLN
Read more...
Environment
Database Oracle,SAP Netweaver Release Independent ,Upgrade or EHPI tool.
Keywords
DBCLONE , THOLT , TFAIT , Duplicate Keys , Index corruption ,Upgrade , EHPi, SUM, upgrade, ORA-00001, unique constraint, violated. , KBA , BC-DB-ORA , Oracle , BC-UPG , Upgrade - general , BC-EHP , Enhancement Package , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.