Emails Fail To Download: ORA-00001: Unique Constraint (IEM.IEM_RT_PP_QUEUES_U2)
(Doc ID 1314247.1)
Last updated on JULY 14, 2020
Applies to:
Oracle Email Center - Version 12.0.6 to 12.1.3 [Release 12.0 to 12.1]Information in this document applies to any platform.
Symptoms
Emails are not downloading for one email account and remain in the Inbox on the Email Server. The following error is reported in the DP Errors console:
Error
Error occurred when executing PLSQL
java.lang.Exception: FNDFND_AS_UNEXPECTED_ERRORNPKG_NAMEIEM_PP_QUEUE_PVT NPROCEDURE_NAMEcreate_pp_queueNERROR_TEXTORA-00001: unique constraint (IEM.IEM_RT_PP_QUEUES_U2) violated at oracle.apps.iem.emta.database.QueueData.storeData(QueueData.java:393) at oracle.apps.iem.emta.jms.QueueManager.enQueue(QueueManager.java:92) at oracle.apps.iem.emta.broker.PrepBroker.preprocess(PrepBroker.java:338) at oracle.apps.iem.emta.broker.PrepBroker.procMails(PrepBroker.java:182) at oracle.apps.iem.emta.broker.BrokerHandler.procMail(BrokerHandler.java:75) at oracle.apps.iem.emta.controller.Worker.run(Worker.java:156) at java.lang.Thread.run(Thread.java:735)
Changes
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 |
| Changes |
| Cause |
| Solution |
| References |