User/Workgroup Data Not Syncronized Between Cluster Nodes

(Doc ID 2417477.1)

Last updated on JULY 09, 2018

Applies to:

Oracle Communications Order and Service Management - Version 7.3.0.0.0 and later
Information 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



Cause

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