ORA-00001: unique constraint Error while Invoking "processInteractionRequest" WS
Last updated on MARCH 07, 2018
Applies to:Oracle Communications Unified Inventory Management - Version 220.127.116.11.0 to 18.104.22.168.0 [Release 7.3.0]
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