UIM: Error while invoking "processInteractionRequest" WS - ORA-00001: unique constraint (Doc ID 2107133.1)

Last updated on MARCH 04, 2016

Applies to:

Oracle Communications Unified Inventory Management - Version 7.3.1.0.0 to 7.3.1.0.0 [Release 7.3.1]
Information in this document applies to any platform.

Symptoms

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

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms