Error: "Exception Has Occurred" And "java.sql.SQLException: ORA-04030: out of process memory when trying to allocate 108528 bytes (kkoutlCreatePh,logdef* : kkoabr)" When Clicking On Project Scheduled Services Windows In P6 Web Access (Doc ID 1665255.1)

Last updated on MARCH 22, 2022

Applies to:

Symptoms

When attempting to open Project Scheduled Services window, the following error occurs.

ERROR
-----------------------
Error in P6 Web Access: Exception has occurred!

Error in P6WebAccess.html:

Apr-04-2014 06:33:15 849 [ACTIVE] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)' ERROR com.primavera.guisupport.jobservices.data.JobServicesProjectsLoader ?:? Failed to projwbs objects in JobServicesProjectsLoader.
com.primavera.bo.remoting.RemoteDataException: Unable to load data for Projwbs with parent null
  at com.primavera.guisupport.common.PickerDataLoader.load(Unknown Source)
  at com.primavera.guisupport.jobservices.data.JobServicesProjectsLoader.load(Unknown Source)
  at com.primavera.guisupport.jobservices.data.JobServicesDataLoader.b(Unknown Source)
  at com.primavera.guisupport.jobservices.data.JobServicesDataLoader.load(Unknown Source)
  at com.primavera.bo.remotable.RemoteRequest.loadData(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:301)
  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:3730)
  at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3696)
  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:2273)
  at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)
  at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1490)
  at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
  at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
  Caused by: com.primavera.PhoenixException: DBEngine.executeSelect: {SELECT projwbs.wbs_id WbsId,projwbs.parent_wbs_id ParentWbsId,projwbs.proj_node_flag ProjectFlag,projwbs.proj_id ProjectId,projwbs.wbs_name Name,projwbs.wbs_short_name ShortName,project.last_recalc_date ProjectLastRecalcDate,project.plan_start_date ProjectPlannedStart,project.project_flag ProjectProjectFlag,projwbs.status_code StatusCode,project.clndr_id ProjectCalendarId FROM project,projwbs WHERE projwbs.proj_id=project.proj_id AND (project.orig_proj_id IS NULL) AND (projwbs.status_code <> 'WS_Template') AND (projwbs.status_code <> 'WS_Requested') AND (projwbs.proj_node_flag = 'Y') AND ((((projwbs.wbs_id IN ('111300', '111301', '74491', '74490', '74496', '74497', '74498', '74499', '74489', '74487', '74488', '74486', '74484', '74482', '74479', '74474', '74476', '74470', '74471', '74472', '74473', '74455', '74453', '74452', '74451', '74450', '74459', '74458', '74457', '74456', '31432', '74464', '31431', '74463', '31434', '74466', '74465', '31430', '74462', '74461', '31439', '31436', '74468', '74467', '31438', '31437', '74469', '74433', '74432', '74431', '74430', '74437', '74436', '74435', '74434', '74439', '74438', '74440', '74442', '74441', '74444', '74443', '74446', '74445', '74448', '74447', '74449', '74418', '74419', '74416', '74417', '74414', '74415', '74412', '74413', '74409', '74427', '74428', '74429', '74423', '74424', '74425', '74426', '74420', '74421', '74422', '31448', '31446', '31440', '31441', '31444', '31445', '31442', '31443', '74403', '74404', '31450', '31453', '31454', '31455', '111343', '111362', '111361', '473000', '111435', '74595', '74596', '74597', '74598', '74592', '74594', '74558', '74556', '74555', '74559', '74553', '74567', '74566', '74569', '74568', '74560', '74565', '74564', '74579', '74578', '74577', '74574', '74573', '74571', '74570', '74589', '74588', '74587', '74586', '74581', '74580', '74583', '74513', '74511', '74512', '74517', '74518', '74516', '74509', '74508', '74520', '74524', '74527', '74528', '74529', '74519', '74532', '74530', '74539', '74537', '74538', '74535', '74533', '74543', '74549', '74545', '435056', '435057', '435058', '435059', '111779', '111772', '111771', '111774', '111773', '111776', '38193', '111775', '38194', '111778', '38191', '111777', '107216', '107215', '435069', '107214', '435068', '107213', '435067', '107212', '107211', '435066', '435065', '107210', '435064', '435063', '435062', '435061', '435060', '111744', '38180', '111745', '111742', '111743', '111740', '111741', '38189', '111748', '107208', '111749', '107209', '111746', '111747', '107207', '475508', '435079', '475507', '475505', '435076', '435075', '107220', '435078', '107223', '435077', '475509', '107222', '475500', '435072', '435071', '435074', '475504', '475503', '435070', '475502', '475501', '38172', '111753', '111754', '111755', '111756', '111750', '111751', '111752', '38177', '38176', '111757', '107217', '107218', '111758', '111759', '107219', '38173', '435087', '435086', '475517', '475516', '475519', '475518', '475513', '475512', '435080', '475514', '435085', '435084', '435083', '475511', '435082', '475510', '111722', '111723', '111720', '111721', '38160', '111726', '38162', '111727', '111724', '111725', '111728', '111729', '435098', '435097', '107203', '475529', '107202', '475528', '107205', '475527', '107204', '435090', '475526', '475525', '435092', '475524', '475523', '435091', '475522', '475521', '435093', '435096', '475520', '435095', '111730', '111731', '111732', '111733', '111734', '111735', '111736', '111737', '111738', '38158', '111739', '475551', '475550', '475545', '475546', '475547', '475548', '475542', '475543', '475544', '475549', '38142', '475540', '475536', '348379', '352225', '352226', '352223', '358999', '358998', '358997', '358996', '348360', '348361', '348364', '348365', '348362', '348363', '87841', '348368', '348369', '348366', '87840', '348367', '348359', '352219', '352217', '352215', '352213', '352211', '70548', '472290', '70549', '70556', '348399', '348398', '348397', '348396', '348395', '70550', '348394', '348393', '348392', '348391', '348390', '70559', '70567', '348389', '481799', '70566', '348388', '481798', '481797', '70568', '472298', '70563', '348385', '472299', '70562', '348384', '70565', '348387', '472297', '70564', '348386', '481792', '348381', '481791', '348380', '481790', '348383', '70560', '348382', '481796', '481795', '481794', '481793', '358970', '207467', '70576', '70575', '481787', '481786', '70579', '481789', '70578', '481788', '481783', '87813', '481785', '481784')) OR (projwbs.proj_id IN ('87817', '70572', '358969', '87816', '70571', '87815', '358967', '70570', '87814', '358968', '481780', '112409', '112408', '112407', '112406', '112401', '112400', '112405', '112404', '112403', '112402', '70585', '70584', '70587', '70586', '481779', '481778', '481777', '70588', '481776', '481775', '481774', '87800', '481773', '481772', '87801', '481771', '87804', '481770', '87803', '70580', '87806', '70583', '70593', '70591', '70592', '157786', '70590', '70599', '70597', '70598', '70595', '70596', '157798'))))) ORDER BY project.project_flag DESC, projwbs.parent_wbs_id , projwbs.seq_num , projwbs.wbs_id}
  null
  at com.primavera.bo.base.DBEngineImpl.executeSelect(Unknown Source)
  at com.primavera.bo.base.DBEngineImpl.executeSelect(Unknown Source)
  at com.primavera.bo.base.LDBEngineImpl.selectObjects(Unknown Source)
  at com.primavera.bo.base.CalculateEngineImpl.getObjects(Unknown Source)
  at com.primavera.bo.base.CalculateEngineImpl.getObjects(Unknown Source)
  at com.primavera.bo.base.CalculateEngineImpl.getObjects(Unknown Source)
  at com.primavera.bo.base.server.ServerDAOImpl.loadPrmRowSet(Unknown Source)
  at com.primavera.bo.remotable.ReqMgr.getObjects(Unknown Source)
  at com.primavera.bo.remotable.qproxy.ReqMgr.getObjects(Unknown Source)
  at com.primavera.bo.DBReqMgr.getObjects(Unknown Source)
  at com.primavera.bo.base.client.ClientDAOImpl.load(Unknown Source)
  at com.primavera.bo.base.client.ClientProjwbsDAOImpl.load(Unknown Source)
  at com.primavera.bo.base.client.ClientProjwbsDAOImpl.load(Unknown Source)
  at com.primavera.bo.base.client.ClientDAOImpl.load(Unknown Source)
  ... 36 more
  Caused by: java.sql.SQLException: ORA-04030: out of process memory when trying to allocate 108528 bytes (kkoutlCreatePh,logdef* : kkoabr)
  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
  at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
  at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
  at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:873)
  at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167)
  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1281)
  at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1909)
  at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1871)
  at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:318)
  at com.primavera.infr.db.PStatement.execute(Unknown Source)
  at com.primavera.bo.base.DBEngineImpl.executeSelect(Unknown Source)
  at com.primavera.bo.base.DBEngineImpl.executeSelect(Unknown Source)
  at com.primavera.bo.base.LDBEngineImpl.selectObjects(Unknown Source)
  at com.primavera.bo.base.CalculateEngineImpl.getObjects(Unknown Source)
  at com.primavera.bo.base.CalculateEngineImpl.getObjects(Unknown Source)
  at com.primavera.bo.base.CalculateEngineImpl.getObjects(Unknown Source)
  at com.primavera.bo.base.server.ServerDAOImpl.loadPrmRowSet(Unknown Source)
  at com.primavera.bo.remotable.ReqMgr.getObjects(Unknown Source)
  at com.primavera.bo.remotable.qproxy.ReqMgr.getObjects(Unknown Source)
  at com.primavera.bo.DBReqMgr.getObjects(Unknown Source)
  at com.primavera.bo.base.client.ClientDAOImpl.load(Unknown Source)
  at com.primavera.bo.base.client.ClientProjwbsDAOImpl.load(Unknown Source)
  at com.primavera.bo.base.client.ClientProjwbsDAOImpl.load(Unknown Source)
  at com.primavera.bo.base.client.ClientDAOImpl.load(Unknown Source)
  at com.primavera.guisupport.common.PickerDataLoader.load(Unknown Source)
  at com.primavera.guisupport.jobservices.data.JobServicesProjectsLoader.load(Unknown Source)
  at com.primavera.guisupport.jobservices.data.JobServicesDataLoader.b(Unknown Source)
  at com.primavera.guisupport.jobservices.data.JobServicesDataLoader.load(Unknown Source)
  at com.primavera.bo.remotable.RemoteRequest.loadData(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:820)
  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:301)
  at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
  at com.primavera.pvweb.XSSFilter.doFilter(Unknown Source)
  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
  at com.primavera.pvweb.FrontFilter.doFilter(Unknown Source)
  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
  at com.primavera.pvweb.filters.ApplicationContextInjector.doFilter(Unknown Source)
  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
  at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)
  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
  ... 9 more

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to P6 Web
2. Click the Projects menu and select Project Scheduled Services.

Changes

Cause

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