Error "ORA-00001 unique constraint violated" when deleting a project in NuGenesis SDMS Administrator - WKB31397

SYMPTOMS

• The following error occurs when deleting a project in SDMS Administrator:
  • ORA-00001: unique constraint (NGSDMS60.NGPROJDEFS_PURGE_PK) violated
    ORA-06512: at 'NGSDMS60.NG_PROJECTBACKUP_TRG_CLU', line 2
    ORA-04088: error during execution of trigger 'NGSDMS60.NG_PRJECT_BACKUP_TRG_CLU'

ENVIRONMENT

• NuGenesis 8 SDMS
• NuGenesis database was migrated from SDMS v7.1

CAUSE

An old trigger, which should have been removed from the database after the migration to NuGenesis, remains in the database. This trigger tries to write the same information into the ngsdms60.ngprojdefs_topurge table as the new trigger, and these two simultaneous writes of the same data into the same table trigger the ORA-00001 error.

FIX or WORKAROUND

1. In SQL*Plus or a SQL tool connected to the NuGenesis database as SYS or SYSTEM, drop the old trigger:
   • DROP TRIGGER ngsdms60.ng_project_backup_trg
2. Delete the project in SDMS Administrator.

ADDITIONAL INFORMATION