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

 

Solution:

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.

Attachments

    Outcomes