My Oracle Support Banner

ORA-00001: Unique Constraint (<prefix>_ORASDPM.DEVICE_ADDRESS$UQ1) Violated (Doc ID 2781554.1)

Last updated on APRIL 11, 2022

Applies to:

Oracle SOA Suite - Version 12.2.1.4.0 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.1.4.0 version, Fabric

The following error is occurring constantly in the logs

ERROR
-----------------------

Local Exception Stack:
Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.7.v20190604-418f1a1c56): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (<PREFIX>_ORASDPM.DEVICE_ADDRESS$UQ1) violated

Error Code: 1
Call: UPDATE DEVICE_ADDRESS SET ADDRESS = ?, version = ? WHERE ((id = ?) AND (version = ?))
bind => [4 parameters bound]
Query: UpdateObjectQuery(oracle.ucsinternal.userprefs.persistence.DeviceAddressImpl@cb5b4a31)
at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:331)


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.