My Oracle Support Banner

EM13c - Recreate Private Role After the User Previously Assigned Same Role Has Been Deleted Fails (Doc ID 2463274.1)

Last updated on FEBRUARY 19, 2019

Applies to:

Enterprise Manager Base Platform - Version 13.2.0.0.0 to 13.2.0.0.0 [Release 13c]
Information in this document applies to any platform.

Symptoms

On Enterprise Manager Cloud Control 13.2.0.0.0 version, Security Framework

When a user creates a (private) role in em13c and the user is being deleted and recreated, the creation of the same private role that existed before fails with an internal error.
OMS log (emoms.log) reveals following error:

ERROR
-----------------------
2017-10-09 13:19:14,858 [emcli-work-manager:emcli-request] WARN rep.AdminUtil createRoleInOPSS.927 - Failed to create role <role_name> in OPSS
2017-10-09 13:19:15,067 [emcli-work-manager:emcli-request] ERROR opss.OPSSPolicyStoreUtil run.286 - Exception occurred while creating role <role_name> in opss
oracle.security.jps.service.policystore.PolicyObjectAlreadyExistsException: JPS-04100: Application Role "<role_name>" already exists.

Caused by: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseExcep
tion
Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (SYSMAN_OPSS.IDX_JPS_RDN_PDN) violated

Error Code: 1
Call: INSERT INTO JPS_DN (ENTRYID, PARENTDN, RDN) VALUES (?, ?, ?)
bind => [3 parameters bound]
Query: InsertObjectQuery(EntryId = 7792:Attribute RowId = <ROWID>
orclguid = <GUID>)



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
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.