Error "????" and "ORA-02292: integrity constraint (P6ADMUSER.FK_PROJECT_USERS) violated - child record found" When Attempting To Delete A User In P6 (Web Access) (Doc ID 1488662.1)

Last updated on JANUARY 12, 2017

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 8.2.0.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to delete user, the following error is logged to the P6WebAccess.html log:

ERROR
-----------------------
Aug-27-2012 09:03:20 646 [ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)' ERROR com.primavera.bo.remotable.RemoteRequest ?:? Failed updating data for web pm com.primavera.guisupport.users.data.UsersDataSaver
com.primavera.bo.remoting.RemoteDataException: ????
  at com.primavera.guisupport.users.data.UsersDataSaver.a(Unknown Source)
  at com.primavera.guisupport.users.data.UsersDataSaver.a(Unknown Source)
  at com.primavera.guisupport.users.data.UsersDataSaver.a(Unknown Source)
  at com.primavera.guisupport.users.data.UsersDataSaver.updateStore(Unknown Source)
  at com.primavera.bo.remotable.RemoteRequest.updateData(Unknown Source)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  at java.lang.reflect.Method.invoke(Method.java:597)
  at com.primavera.infr.q.AbstractQProxyObject.performAction(Unknown Source)
  at com.primavera.infr.q.AbstractQProxyObject.execute(Unknown Source)
  at com.primavera.oriweb.preshelpers.BusinessObjectServletServices.executeProxyObject(Unknown Source)
  at com.primavera.pvweb.servlet.BusinessObjectServlet.service(Unknown Source)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:821)
  at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
  at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
  at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)
  at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:27)
  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)
  at com.primavera.pvweb.XSSFilter.doFilter(Unknown Source)
  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)
  at com.primavera.pvweb.FrontFilter.doFilter(Unknown Source)
  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)
  at com.primavera.pvweb.filters.ApplicationContextInjector.doFilter(Unknown Source)
  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)
  at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)
  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)
  at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3715)
  at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3681)
  at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
  at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
  at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2277)
  at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2183)
  at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1454)
  at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)
  at weblogic.work.ExecuteThread.run(ExecuteThread.java:178)
  Caused by: com.primavera.bo.common.QueryTimeoutException: executeUpdateBatch: error occurred during batching: ORA-02292: integrity constraint (P6ADMUSER.FK_PROJECT_USERS) violated - child record found
  
  at com.primavera.bo.base.LDBEngineImpl.a(Unknown Source)
  at com.primavera.bo.base.LDBEngineImpl.commitTransaction(Unknown Source)
  at com.primavera.bo.base.DeleteEngineImpl.delete(Unknown Source)
  at com.primavera.bo.base.server.ServerDAOImpl.delete(Unknown Source)
  at com.primavera.bo.remotable.ReqMgr.deleteObjectsWithWbsContext(Unknown Source)
  at com.primavera.bo.remotable.ReqMgr.deleteObjects(Unknown Source)
  at com.primavera.bo.remotable.qproxy.ReqMgr.deleteObjects(Unknown Source)
  at com.primavera.bo.DBReqMgr.deleteObjects(Unknown Source)
  at com.primavera.bo.base.client.ClientDAOImpl.deleteWithTransactionAndOptions(Unknown Source)
  ... 36 more

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log into P6 WebAccess
2. Administer --> User Access
3. Select user --> Click on delete icon --> Save changes

Changes

 

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