User/Workgroup Data Not Syncronized Between Cluster Nodes (Doc ID 2417477.1)

Last updated on JULY 09, 2018

Applies to:

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

Cause