AnsweredAssumed Answered

Unique constraint violated

Question asked by Madhuri Chinthaparthi on Jun 14, 2017

Hi Team,


We have faced one issuue today morning


06/14/2017 01:59:15.843 ERROR (Worker_jobq#JobQ1#WPDS_301) [SmartStatement] - SQLException caught
java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (AVUSER.PK_WP_PROCI_CONTROL) violated

Due to which All nodes have went to down state and we were not able to access production and impacted business.Kindly let us know what could be the issues.


Please find the other issues as well: