Unique constraint error on Replication
We are getting numerous replication errors in Xcenter even though the store is posting correctly and the transactions replicate to Xcenter without issue.
The problem is the Xcenter and Xstore stock ledger appears to be out of balance due to the constraint errors.
The error we are seeing is below and I also attached the full error.
dtv.data2.access.exception.PersistenceException: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (DTV.PK_INV_STOCK_LEDGER_ACCT) violated at dtv.data2.access.pm.PersistenceManager.handleConstraintViolation(PersistenceManager.java:1207) at dtv.data2.access.pm.PersistenceManager.makePersistent(PersistenceManager.java:399) at dtv.data2.access.pm.DefaultPersistenceMgr.makePersistent(DefaultPersistenceMgr.java:103) at dtv.data2.access.DataFactory.makePersistent(DataFactory.java:453) at dtv.data2.access.DataFactory.makePersistent(DataFactory.java:400) at com.micros_retail.xcenter.replication.ReplRunnable.saveDtxDataToXcenterDb(ReplRunnable.java:262) at com.micros_retail.xcenter.replication.ReplRunnable.publishReplObject(ReplRunnable.java:205) at com.micros_retail.xcenter.replication.ReplRunnable.run(ReplRunnable.java:128) at java.lang.Thread.run(Thread.java:748) Caused by: dtv.data2.access.exception.ConstraintViolationException: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (DTV.PK_INV_STOCK_LEDGER_ACCT) violated at dtv.data2.access.exception.ConstraintViolationException.getNewException(ConstraintViolationException.java:64) at dtv.data2.access.impl.jdbc.JDBCPersistenceStrategy.handlePersistenceException(JDBCPersistenceStrategy.java:630) at dtv.data2.access.impl.jdbc.JDBCPersistenceStrategy.makePersistentImpl(JDBCPersistenceStrategy.java:831) at dtv.data2.access.impl.AbstractPersistenceStrategy.makePersistent(AbstractPersistenceStrategy.java:112) at dtv.data2.access.pm.PersistenceManager.makePersistent(PersistenceManager.java:354) ... 7 more