Tech Tip: possible db error after DB restore: ORA-00001: unique constraint (EHEALTH.NH_ELEMENT_IX2) violated )"

Document created by Roberto_Milani Employee on Jan 7, 2015Last modified by SamCreek on Dec 17, 2016
Version 2Show Document
  • View in full screen mode

ehelath 6.3.2.xx


the following error may occurs after a DB restore on cluster environment :


error "Pgm nhiReplDriver: Database error:

(ORA-00001: unique constraint (EHEALTH.NH_ELEMENT_IX2) violated )" and  "Pgm nhiReplServer: Driver command 'E:/ehealth/bin/sys/nhiReplDriver -opType import -objType element -fileName



run the following command :

$NH_HOME/bin/sys/nhSynchronize -cluster -objType element -allElements



This step recovers any objects created on the local system between the time when the backup was created and the time that the system returned to service after the database load.