UIM: Error while invoking "processInteractionRequest" WS - ORA-00001: unique constraint
Last updated on DECEMBER 20, 2017
Applies to:Oracle Communications Unified Inventory Management - Version 188.8.131.52.0 to 184.108.40.206.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
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms