Error In DRM Common User Provisioning: ORA-00001: unique constraint (EPM_DRM.PKRMACCESSGROUPUSER) violated (Doc ID 2739626.1)

Last updated on SEPTEMBER 22, 2022

Applies to:

Symptoms

The following error is being seen:

Cannot synchronize single user '<user>'; exception thrown:

System.Exception: Cannot synchronize single user '<user>'; exception thrown: ---> Oracle.ManagedDataAccess.Client.OracleException: ORA-00001: unique constraint (EPM_DRM.PKRMACCESSGROUPUSER) violated
  at OracleInternal.ServiceObjects.OracleConnectionImpl.VerifyExecution(Int32& cursorId, Boolean bThrowArrayBindRelatedErrors, SqlStatementType sqlStatementType, Int32 arrayBindCount, OracleException& exceptionForArrayBindDML, Boolean& hasMoreRowsInDB, Boolean bFirstIterationDone)
  at OracleInternal.ServiceObjects.OracleCommandImpl.ExecuteNonQuery(String commandText, OracleParameterCollection paramColl, CommandType commandType, OracleConnectionImpl connectionImpl, Int32 longFetchSize, Int64 clientInitialLOBFS, OracleDependencyImpl orclDependencyImpl, Int64[]& scnFromExecution, OracleParameterCollection& bindByPositionParamColl, Boolean& bBindParamPresent, OracleException& exceptionForArrayBindDML, OracleConnection connection, OracleLogicalTransaction& oracleLogicalTransaction, Boolean isFromEF)
  at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteNonQuery()
  at Oracle.Drm.DalFramework.AdoCommandWrapper.<>c__DisplayClass15_0`2.b__0()
  at Oracle.Drm.DalFramework.DalMonitor.Check(DalContext context, Action codeblock)
  at Oracle.Drm.DalFramework.AdoCommandWrapper.Executor[T,T1](Func`1 func)
  at Oracle.Drm.DalFramework.DalCommand.Execute()
  at Oracle.Drm.DalFramework.BaseWriteCommand.Execute()
  at Oracle.Drm.DalFramework.DalRecord.Insert()
  at Oracle.Drm.Engine.Core.SecurityManagerImmutable.UpdateNodeAccessGroupUsers(NodeAccessGroup group, IEnumerable`1 members)
  at Oracle.Drm.Engine.Core.NodeAccessGroupMgrShell.<>c__DisplayClass18_0.b__0()
  at Oracle.Drm.Engine.Core.LogManager.<>c__DisplayClass2_0.b__0()
  at Oracle.Drm.DalFramework.DalContext.ExecuteTransaction(Action codeBlock, Action afterCommit, Action afterRollback)
  at Oracle.Drm.DalFramework.DataAccessLayer.ExecuteUpdateTransaction(Action codeBlock, Action afterCommit, Action afterRollback)
  at Oracle.Drm.Engine.Core.NodeAccessGroupMgrShell.UpdateNodeAccessMembers(Int32 groupID, IEnumerable`1 members, Boolean internalCaller)
  at Oracle.Drm.Engine.Core.CssSynchronizer.SynchronizeSingleUser(String userName)
  --- End of inner exception stack trace ---

Cause

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