TMS 4.5.2 to 4.6.3 Upgrade Fails with "ORA-00001: unique constraint (TMS.TMS_THI_STATUS_UK1) violated" (Doc ID 1553106.1)

Last updated on MARCH 30, 2014

Applies to:

Oracle Thesaurus Management System - Version 4.6.3 and later
Information in this document applies to any platform.

Symptoms

The TMS 4.5.2 to 4.6.3 database upgrade fails with ** TMS THI Upgrade failed unexpectedly. Export the content of debug table TMP_TMS46_UPG_DEBUG and send to ORACLE.**


The TMP_TMS46_UPG_DEBUG table contains 7 records with error ORA-00001: unique constraint (TMS.TMS_THI_STATUS_UK1) violated - these are for the terms:
  AMAUROSE ¿IL GAUCHE
  CATARACTE DE L'¿IL DROIT OPEREE
  HEMMORAGIE CONJONCTIVALE ¿IL D
  INTERVENTION CATARACTE ¿IL G
  OPERATION CATARACTE ¿IL DROIT
  OPERATION CATARACTE ¿IL DT
  TENSION OCULAIRE ¿IL DROIT

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms