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 22.214.171.124.0 to 126.96.36.199.0 [Release 13c]
Information in this document applies to any platform.
On Enterprise Manager Cloud Control 188.8.131.52.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:
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
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>)
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