Getting ERROR ORA-00001: unique constraint (DM_PROD.AUDIT_FILTERS_PK) violated
Hi All
Getting the following error in collaborator log
ERROR update.process: Insert to Audit Tables process was failed.Update Data: Id: 1901, User: GH485, WS: 19172, Update Table: SALES_DATA, Combination: L646M1L575M3L579M335L424M16756L496M9L490M5682012-05-18 13:32:58,034 EDT [AuditTrail_0] ERROR update.process: java.sql.BatchUpdateException: ORA-00001: unique constraint (DM_PROD.AUDIT_FILTERS_PK) violated.Any idea what this about. We are witnessing lot of locks on db since we started getting this error. Also Demantra performance has slowed down significntly.Nikhil0