Retail Point-of-Service Solutions (MOSC)

MOSC Banner

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 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center