Deadlocks In Om_user_privilege_pkg While Deleting The Users From OSM
(Doc ID 2107719.1)
Last updated on MARCH 31, 2023
Applies to:
Oracle Communications Order and Service Management - Version 7.2.2 and laterInformation in this document applies to any platform.
Symptoms
Customer is experiencing deadlock exceptions when trying to add extra partitions to the database (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
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 |