User/Workgroup Data Not Syncronized Between Cluster Nodes
(Doc ID 2417477.1)
Last updated on MARCH 05, 2019
Applies to:
Oracle Communications Order and Service Management - Version 7.3.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
Changes made to user/workgroup association does not get propagated to other nodes in the cluster. This results in data mismatches between nodes as well as possibly between the DB and all managed servers. This can lead to constraint violation errors like below and inconsistent behavior for users accessing the OSM UI's.
Logs :
[2018-04-19T16:24:27.062+00:00] [OsmServer1] [ERROR] [] [oracle.communications.ordermanagement.ui.admin.AdminUserBean] [tid: [ACTIVE].ExecuteThread: '15' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: osmadmin] [ecid: 78f84727-f353-490f-9dc5-b44c3d009218-00013dac,0] [APP: oms] [partition-name: DOMAIN] [tenant-name: GLOBAL] [DSID: 0000] Error saving user user1[[
com.mslv.oms.dataaccesslayer.ProxyException: ORA-00001: unique constraint (ORDERMGMT1.XPKOM_USER_WORKGROUP) violated
ORA-06512: at "ORDERMGMT1.OM_USER_PRIVILEGE_PKG", line 8
ORA-06512: at "ORDERMGMT1.OM_USER_PRIVILEGE_PKG", line 27
ORA-06512: at line 1
Nested Exception: ORA-00001: unique constraint (ORDERMGMT1.XPKOM_USER_WORKGROUP) violated
ORA-06512: at "ORDERMGMT1.OM_USER_PRIVILEGE_PKG", line 8
ORA-06512: at "ORDERMGMT1.OM_USER_PRIVILEGE_PKG", line 27
ORA-06512: at line 1
Nested Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (ORDERMGMT1.XPKOM_USER_WORKGROUP) violated
ORA-06512: at "ORDERMGMT1.OM_USER_PRIVILEGE_PKG", line 8
ORA-06512: at "ORDERMGMT1.OM_USER_PRIVILEGE_PKG", line 27
ORA-06512: at line 1
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 |
References |