ORA-00001: unique constraint violated Error on Creating Logical Device with Device Interface
(Doc ID 1987842.1)
Last updated on SEPTEMBER 06, 2024
Applies to:
Oracle Communications Unified Inventory Management - Version 7.2.4 and laterInformation in this document applies to any platform.
Symptoms
There is an issue while creating a LogicalDevice, from UIM user Interface.
An error has occured committing the user transaction.: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.1.v20111018-r10243): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (DEV01.SYS_C0012387) violated
Error Code: 1
Query: InsertObjectQuery([ DeviceInterfaceDAO oid=oracle.communications.platform.entity.impl.DeviceInterfaceDAO-17405579 !PTDND!=TTFTF entityVersion=1 id=17775002-1 name=null description=null noSpec=false interfaceNumber=null vendorInterfaceNumber=null customerInterfaceNumber=null ifType=null maxSpeed=null minSpeed=null nominalSpeed=0 nativeEMSName=null nativeEMSServiceState=null nativeEMSAdminServiceState=null physicalLocation=null rateCodeNominalBitRate=0 createdDate=Tue Mar 03 14:09:14 EET 2014 createdUser=uimabc partition=null owner=null permissions=null startDate=Tue Mar 03 14:09:14 EET 2014 endDate=Tue Jan 19 05:14:07 EET 2038 adminState=INSTALLED objectState=ACTIVE activity=CREATE ])
An error has occured flushing the user transaction.: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.1.v20111018-r10243): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (DEV01.SYS_C0012387) violated
Error Code: 1
Query: InsertObjectQuery([ DeviceInterfaceDAO oid=oracle.communications.platform.entity.impl.DeviceInterfaceDAO-17405579 !PTDND!=TTFTF entityVersion=1 id=17775002-1 name=null description=null noSpec=false interfaceNumber=null vendorInterfaceNumber=null customerInterfaceNumber=null ifType=null maxSpeed=null minSpeed=null nominalSpeed=0 nativeEMSName=null nativeEMSServiceState=null nativeEMSAdminServiceState=null physicalLocation=null rateCodeNominalBitRate=0 createdDate=Tue Mar 03 14:09:14 EET 20
Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (DEV01.SYS_C0012387) violated
Error Code: 1
Query: InsertObjectQuery([ DeviceInterfaceDAO oid=oracle.communications.platform.entity.impl.DeviceInterfaceDAO-17405579 !PTDND!=TTFTF entityVersion=1 id=17775002-1 name=null description=null noSpec=false interfaceNumber=null vendorInterfaceNumber=null customerInterfaceNumber=null ifType=null maxSpeed=null minSpeed=null nominalSpeed=0 nativeEMSName=null nativeEMSServiceState=null nativeEMSAdminServiceState=null physicalLocation=null rateCodeNominalBitRate=0 createdDate=Tue Mar 03 14:09:14 EET 2014 createdUser=uimabc partition=null owner=null permissions=null startDate=Tue Mar 03 14:09:14 EET 2014 endDate=Tue Jan 19 05:14:07 EET 2038 adminState=INSTALLED objectState=ACTIVE activity=CREATE ])
An error has occured flushing the user transaction.: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.1.v20111018-r10243): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (DEV01.SYS_C0012387) violated
Error Code: 1
Query: InsertObjectQuery([ DeviceInterfaceDAO oid=oracle.communications.platform.entity.impl.DeviceInterfaceDAO-17405579 !PTDND!=TTFTF entityVersion=1 id=17775002-1 name=null description=null noSpec=false interfaceNumber=null vendorInterfaceNumber=null customerInterfaceNumber=null ifType=null maxSpeed=null minSpeed=null nominalSpeed=0 nativeEMSName=null nativeEMSServiceState=null nativeEMSAdminServiceState=null physicalLocation=null rateCodeNominalBitRate=0 createdDate=Tue Mar 03 14:09:14 EET 20
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 |