SAP Knowledge Base Article - Preview

1742979 - DBCLONE: ORA-00001: unique constraint violated encountered during upgrade

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.