My Oracle Support Banner

'ORA-00001: unique constraint ' Causes Queue Buildups in EJournalImport in ORCO (Doc ID 1523825.1)

Last updated on FEBRUARY 02, 2018

Applies to:

Oracle Retail Central Office - Version 12.0 and later
Information in this document applies to any platform.

Symptoms

In Oracle Retail Central Office (ORCO) , Ejournals get stuck in the EjournalImport queue when the following error is encountered while processing an Ejournal sent from ORPOS.

 2012-10-12 16:59:43,531 ERROR [oracle.retail.stores.commerceservices.transaction.ejb.EJournalImportServiceBean]
  javax.transaction.TransactionRolledbackException: EJB Exception: :
  javax.ejb.EJBException: nested exception is: javax.ejb.CreateException:
  Could not create EJournal: ORA-00001: unique constraint (EQACO07.SYS_C004089685) violated

Steps to Reproduce:

1. Simulate a duplicate key exception for an EJournal Import in ORCO.
2. Observe in Central Office log that multiple attempts are made to save the Ejournal that causes the duplicate key exception, causing a queue build up, thus delaying processing of other Ejournals.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.