Last updated on MARCH 04, 2016
Applies to:Oracle Communications Unified Inventory Management - Version 22.214.171.124.0 to 126.96.36.199.0 [Release 7.3.1]
Information in this document applies to any platform.
Customer is experiencing the following error when using Service Fulfillment Web service (SFWS): ORA-00001: unique constraint
In the UIM Server log:
2016-02-11 11:31:01,909 ERROR [uim] [[ACTIVE] ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)'] [TransactionManager] An error has occured flushing the user transaction.
javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (UIMDBDEV.IDX_SRV_EOID_ED) violated
Error Code: 1
Call: INSERT INTO Service (ENTITYID, ACTIVITY, ADMINSTATE, CREATEDDATE, CREATEDUSER, DESCRIPTION, ENDDATE, ENTITYCLASS, ENTITYVERSION, EXTERNALARRANGEMENT, EXTERNALMANAGEMENTDOMAIN, EXTERNALNAME, EXTERNALOBJECTID, ID, LASTMODIFIEDDATE, LASTMODIFIEDUSER, NAME, NOSPEC, OBJECTSTATE, OWNER, PARTITION, PERMISSIONS, STARTDATE, CURRENTASSIGNMENT, SPECIFICATION) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
bind => [25
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms