ORA-00001: unique constraint Error while Invoking "processInteractionRequest" WS
(Doc ID 2107133.1)
Last updated on SEPTEMBER 22, 2022
Applies to:
Oracle Communications Unified Inventory Management - Version 7.3.1.0.0 to 7.3.1.0.0 [Release 7.3.0]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
Changes
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 |
| Changes |
| Cause |
| Solution |