Deadlocks In Om_user_privilege_pkg While Deleting The Users From OSM (Doc ID 2107719.1)

Last updated on MARCH 01, 2016

Applies to:

Oracle Communications Order and Service Management - Version 7.2.2 and later
Information in this document applies to any platform.

Symptoms

Customer is experiencing deadlock exceptions when trying to add extra partitions to the DB (More than 4 at a time).


Dead lock messages appear  in OSM logs while OSM server is started:
####<Nov 5, 2015 1:38:17 PM CST> <Error> <oms> <sc58losmp21> <OsmServer1> <[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'> <oms-internal> <> <0000L3P9huO9_amMwqvX6G1MEuzD000002> <1446752297476> <BEA-000000> <userinfo.UserInfoMgr: Proxy Exception Occured ORA-02292: integrity constraint (ORDERMGMT1.FK_USER_PREF_ATTR_01) violated - child record found
ORA-06512: at "ORDERMGMT1.OM_USER_PRIVILEGE_PKG", line 68
Nested Exception: ORA-02292: integrity constraint (ORDERMGMT1.FK_USER_PREF_ATTR_01) violated - child record found
ORA-06512: at "ORDERMGMT1.OM_USER_PRIVILEGE_PKG", line 68

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