Report Hangs In P6 EPPM Web And Log File Contains The Following Error: getAllScheduledReportHistoryInfo failure due to: DatabaseException

(Doc ID 2337824.1)

Last updated on JANUARY 03, 2018

Applies to:

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

Symptoms

When attempting to run a report from P6, after entering the parameters, the window appears hung, and the report will not run. The report runs correctly from within BI Publisher

The following error is visible in the P6 log file:

ERROR
Dez-05-2017 13:05:15 224, MEZ [ACTIVE] ExecuteThread: '42' for queue: 'weblogic.kernel.Default (self-tuning)' ERROR /rest/reports/schedule/data/load?timeZone=GMT+05:30 (User Id: XXX DB Id: X) com.primavera.rest.service.reports.helpers.JAXWSReportServiceWrapper11gr1v2LWF ?:? oracle.xdo.webservice.exception.OperationFailedException: ScheduleServiceImpl::getAllScheduledReportHistoryInfo failure due to: DatabaseException
javax.xml.ws.soap.SOAPFaultException: oracle.xdo.webservice.exception.OperationFailedException: ScheduleServiceImpl::getAllScheduledReportHistoryInfo failure due to: DatabaseException
  at com.sun.xml.ws.fault.SOAP11Fault.getProtocolException(SOAP11Fault.java:189)
  at com.sun.xml.ws.fault.SOAPFaultBuilder.createException(SOAPFaultBuilder.java:130)
  at com.sun.xml.ws.client.sei.SyncMethodHandler.invoke(SyncMethodHandler.java:119)
  at com.sun.xml.ws.client.sei.SyncMethodHandler.invoke(SyncMethodHandler.java:89)
  at com.sun.xml.ws.client.sei.SEIStub.invoke(SEIStub.java:118)
  at com.sun.proxy.$Proxy166.getAllScheduledReportInSession(Unknown Source)
  at com.primavera.rest.service.reports.helpers.JAXWSReportServiceWrapper11gr1v2LWF.loadScheduleData(JAXWSReportServiceWrapper11gr1v2LWF.java:1006)
  at com.primavera.rest.service.reports.helpers.JAXWSReportServiceWrapper11gr1v2LWF.loadScheduleData(JAXWSReportServiceWrapper11gr1v2LWF.java:991)
  at com.primavera.rest.service.reports.ReportsServiceImpl.loadScheduledData(ReportsServiceImpl.java:150)
  at com.primavera.rest.resources.reports.ReportsResource.loadScheduleData(ReportsResource.java:114)
  at sun.reflect.GeneratedMethodAccessor2785.invoke(Unknown Source)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  at java.lang.reflect.Method.invoke(Method.java:498)
  at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)
  at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$ResponseOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:205)
  at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75)
  at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302)
  at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
  at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108)
  at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
  at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84)
  at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1542)
  at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1473)
  at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1419)
  at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1409)
  at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:409)
  at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:540)
  at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:715)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:844)
  at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:280)
  at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:254)
  at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:136)
  at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:346)
  at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:25)
  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)
  at com.github.ziplet.filter.compression.CompressingFilter.doFilter(CompressingFilter.java:300)
  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)
  at com.primavera.pvweb.NoCacheNoStoreFilter.doFilter(Unknown Source)
  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)
  at com.primavera.pvweb.HeaderInserterFilter.doFilter(Unknown Source)
  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)
  at com.primavera.pvweb.XSSFilter.doFilter(Unknown Source)
  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)
  at com.primavera.pvweb.FrontFilter.doFilter(Unknown Source)
  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)
  at com.primavera.pvweb.filters.ApplicationContextInjector.doFilter(Unknown Source)
  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)
  at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)
  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)
  at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3447)
  at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3413)
  at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
  at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
  at weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:57)
  at weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2280)
  at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2196)
  at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2174)
  at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1632)
  at weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:256)
  at weblogic.work.ExecuteThread.execute(ExecuteThread.java:311)
  at weblogic.work.ExecuteThread.run(ExecuteThread.java:263)
Dez-05-2017 13:07:53 554, MEZ [ACTIVE] ExecuteThread: '30' for queue: 'weblogic.kernel.Default (self-tuning)' ERROR /rest/reports/reportRun/save (User Id: 722 DB Id: 1) com.primavera.rest.service.reports.helpers.JAXWSReportServiceWrapper11gr1v2LWF ?:? null
Dez-05-2017 13:07:53 554, MEZ [ACTIVE] ExecuteThread: '30' for queue: 'weblogic.kernel.Default (self-tuning)' ERROR /rest/reports/reportRun/save (User Id: 722 DB Id: 1) com.primavera.rest.service.reports.helpers.JAXWSReportServiceWrapper11gr1v2LWF ?:? com.primavera.guisupport.reporting.bip11gr1v2.ArrayOfString@4a986156
Dez-05-2017 13:07:53 554, MEZ [ACTIVE] ExecuteThread: '30' for queue: 'weblogic.kernel.Default (self-tuning)' ERROR /rest/reports/reportRun/save (User Id: 722 DB Id: 1) com.primavera.rest.service.reports.helpers.JAXWSReportServiceWrapper11gr1v2LWF ?:? com.primavera.guisupport.reporting.bip11gr1v2.ss.DeliveryChannels@707f06a2
Dez-05-2017 13:07:53 554, MEZ [ACTIVE] ExecuteThread: '30' for queue: 'weblogic.kernel.Default (self-tuning)' ERROR /rest/reports/reportRun/save (User Id: 722 DB Id: 1) com.primavera.rest.service.reports.helpers.JAXWSReportServiceWrapper11gr1v2LWF ?:? -- Start Date -- null
Dez-05-2017 13:07:53 554, MEZ [ACTIVE] ExecuteThread: '30' for queue: 'weblogic.kernel.Default (self-tuning)' ERROR /rest/reports/reportRun/save (User Id: 722 DB Id: 1) com.primavera.rest.service.reports.helpers.JAXWSReportServiceWrapper11gr1v2LWF ?:? -- End Date -- null
Dez-05-2017 13:24:20 652, MEZ [ACTIVE] ExecuteThread: '39' for queue: 'weblogic.kernel.Default (self-tuning)' ERROR /rest/reports/schedule/data/load?timeZone=GMT+05:30 (User Id: 722 DB Id: 1) com.primavera.rest.service.reports.helpers.JAXWSReportServiceWrapper11gr1v2LWF ?:? oracle.xdo.webservice.exception.OperationFailedException: ScheduleServiceImpl::getAllScheduledReportHistoryInfo failure due to: DatabaseException
javax.xml.ws.soap.SOAPFaultException: oracle.xdo.webservice.exception.OperationFailedException: ScheduleServiceImpl::getAllScheduledReportHistoryInfo failure due to: DatabaseException
  at com.sun.xml.ws.fault.SOAP11Fault.getProtocolException(SOAP11Fault.java:189)
  at com.sun.xml.ws.fault.SOAPFaultBuilder.createException(SOAPFaultBuilder.java:130)
  at com.sun.xml.ws.client.sei.SyncMethodHandler.invoke(SyncMethodHandler.java:119)
  at com.sun.xml.ws.client.sei.SyncMethodHandler.invoke(SyncMethodHandler.java:89)
  at com.sun.xml.ws.client.sei.SEIStub.invoke(SEIStub.java:118)
  at com.sun.proxy.$Proxy166.getAllScheduledReportInSession(Unknown Source)
  at com.primavera.rest.service.reports.helpers.JAXWSReportServiceWrapper11gr1v2LWF.loadScheduleData(JAXWSReportServiceWrapper11gr1v2LWF.java:1006)
  at com.primavera.rest.service.reports.helpers.JAXWSReportServiceWrapper11gr1v2LWF.loadScheduleData(JAXWSReportServiceWrapper11gr1v2LWF.java:991)
  at com.primavera.rest.service.reports.ReportsServiceImpl.loadScheduledData(ReportsServiceImpl.java:150)
  at com.primavera.rest.resources.reports.ReportsResource.loadScheduleData(ReportsResource.java:114)
  at sun.reflect.GeneratedMethodAccessor2785.invoke(Unknown Source)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  at java.lang.reflect.Method.invoke(Method.java:498)
  at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)
  at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$ResponseOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:205)
  at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75)
  at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302)
  at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
  at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108)
  at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
  at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84)
  at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1542)
  at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1473)
  at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1419)
  at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1409)
  at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:409)
  at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:540)
  at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:715)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:844)
  at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:280)
  at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:254)
  at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:136)
  at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:346)
  at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:25)
  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)
  at com.github.ziplet.filter.compression.CompressingFilter.doFilter(CompressingFilter.java:300)
  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)
  at com.primavera.pvweb.NoCacheNoStoreFilter.doFilter(Unknown Source)
  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)
  at com.primavera.pvweb.HeaderInserterFilter.doFilter(Unknown Source)
  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)
  at com.primavera.pvweb.XSSFilter.doFilter(Unknown Source)
  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)
  at com.primavera.pvweb.FrontFilter.doFilter(Unknown Source)
  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)
  at com.primavera.pvweb.filters.ApplicationContextInjector.doFilter(Unknown Source)
  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)
  at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)
  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)
  at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3447)
  at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3413)
  at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
  at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
  at weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:57)
  at weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2280)
  at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2196)
  at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2174)
  at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1632)
  at weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:256)
  at weblogic.work.ExecuteThread.execute(ExecuteThread.java:311)
  at weblogic.work.ExecuteThread.run(ExecuteThread.java:263)

STEPS
The issue can be reproduced at will with the following steps:

  1. Login to P6 Web
  2. Browse to the reporting tab
  3. Attempt to run the problem report from within P6
  4. Error seen in log

BUSINESS IMPACT
The issue has the following business impact:
Due to this issue, users cannot run the report in P6

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