Error: "Could not get data source connection for: [DatabaseName]" When Running BI Publisher Report in P6 (Doc ID 1951585.1)

Last updated on MAY 17, 2016

Applies to:

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

Symptoms

On : 8.3.2.0 version, P6 Web / BI Publisher Reporting

When attempting to run a specific report in P6 Web, the following error occurs.


ERROR
-----------------------
Nov-23-2014 14:21:56 240 [ACTIVE] ExecuteThread: '19' for queue: 'weblogic.kernel.Default (self-tuning)' ERROR com.primavera.pvweb.BaseAction ?:? exception processing action
javax.xml.ws.soap.SOAPFaultException: oracle.xdo.webservice.exception.OperationFailedException: PublicReportService::generateReport for reportAbsolutePath [/P6Reports/User Last Active Date.xdo] failed: due to oracle.xdo.XDOException: oracle.xdo.XDOException: oracle.xdo.XDOException: Not able to find data source with name:PMDB
  Could not get data source connection for: PMDB
  at com.sun.xml.ws.fault.SOAP11Fault.getProtocolException(SOAP11Fault.java:197)
  at com.sun.xml.ws.fault.SOAPFaultBuilder.createException(SOAPFaultBuilder.java:130)
  at com.sun.xml.ws.client.sei.SyncMethodHandler.invoke(SyncMethodHandler.java:125)
  at com.sun.xml.ws.client.sei.SyncMethodHandler.invoke(SyncMethodHandler.java:95)
  at com.sun.xml.ws.client.sei.SEIStub.invoke(SEIStub.java:136)
  at com.sun.proxy.$Proxy101.runReportInSession(Unknown Source)
  at com.primavera.guisupport.reporting.JAXWSReportServiceWrapper11gr1v2.runReport(Unknown Source)
  at com.primavera.pvweb.reporting.ReportingAppletRemote.runReport(Unknown Source)
  at com.primavera.pvweb.reporting.ReportingAppletAction.a(Unknown Source)
  at com.primavera.pvweb.reporting.ReportingAppletAction.executePost(Unknown Source)
  at com.primavera.pvweb.BaseAction.execute(Unknown Source)
  at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
  at com.primavera.pvweb.FrontRequestProcessor.processActionPerform(Unknown Source)
  at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
  at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
  at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
  at com.primavera.pvweb.servlet.FrontController.doPost(Unknown Source)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
  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:60)
  at com.primavera.pvweb.GZIPFilter.doFilter(Unknown Source)
  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
  at com.primavera.pvweb.XSSFilter.doFilter(Unknown Source)
  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
  at com.primavera.pvweb.FrontFilter.doFilter(Unknown Source)
  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
  at com.primavera.pvweb.filters.ApplicationContextInjector.doFilter(Unknown Source)
  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
  at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)
  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
  at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3748)
  at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3714)
  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:2283)
  at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2182)
  at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1491)
  at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
  at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
Nov-23-2014 14:21:56 645 [ACTIVE] ExecuteThread: '11' for queue: 'weblogic.kernel.Default (self-tuning)' ERROR com.primavera.bo.remotable.RemoteLogger ?:? ReportingApplet: com.primavera.pvapplets.reporting.ReportingDataHandler @5CB2041XW3[161.186.246.95] invalid stream header: 0A0A0A0A java.io.StreamCorruptedException invalid stream header: 0A0A0A0A java.io.StreamCorruptedException: invalid stream header: 0A0A0A0A at java.io.ObjectInputStream.readStreamHeader(Unknown Source) at java.io.ObjectInputStream.(Unknown Source) at com.primavera.guisupport.util.SerializeUtil.deSerializeObjFromStream(Unknown Source) at com.primavera.guisupport.util.SerializeUtil.serializeToUrlAndUpdate(Unknown Source) at com.primavera.pvapplets.reporting.ReportingDataHandler.runReport(Unknown Source) at com.primavera.pvapplets.reporting.ReportingController.createRunRequest(Unknown Source) at com.primavera.pvapplets.reporting.ReportingController.onCustom(Unknown Source) at com.primavera.pvapplets.reporting.ReportingController.onEvent(Unknown Source) at com.primavera.pvapplets.reporting.ReportingController.onEvent(Unknown Source) at com.primavera.pvapplets.common.listeners.ListenerCollection$DefaultNotifier.onEventNotify(Unknown Source) at com.primavera.pvapplets.common.listeners.ListenerCollection.notifyListeners(Unknown Source) at com.primavera.pvapplets.common.listeners.ListenerCollection.notifyListenersNoFail(Unknown Source) at com.primavera.pvapplets.reporting.ReportingContext.notifyListeners(Unknown Source) at com.primavera.pvapplets.reporting.dialogs.ScheduleReportDialog$2$1.doInBackground(Unknown Source) at javax.swing.SwingWorker$1.call(Unknown Source) at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at javax.swing.SwingWorker.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source)
java.io.StreamCorruptedException: invalid stream header: 0A0A0A0A
  at java.io.ObjectInputStream.readStreamHeader(Unknown Source)
  at java.io.ObjectInputStream.(Unknown Source)
  at com.primavera.guisupport.util.SerializeUtil.deSerializeObjFromStream(Unknown Source)
  at com.primavera.guisupport.util.SerializeUtil.serializeToUrlAndUpdate(Unknown Source)
  at com.primavera.pvapplets.reporting.ReportingDataHandler.runReport(Unknown Source)
  at com.primavera.pvapplets.reporting.ReportingController.createRunRequest(Unknown Source)
  at com.primavera.pvapplets.reporting.ReportingController.onCustom(Unknown Source)
  at com.primavera.pvapplets.reporting.ReportingController.onEvent(Unknown Source)
  at com.primavera.pvapplets.reporting.ReportingController.onEvent(Unknown Source)
  at com.primavera.pvapplets.common.listeners.ListenerCollection$DefaultNotifier.onEventNotify(Unknown Source)
  at com.primavera.pvapplets.common.listeners.ListenerCollection.notifyListeners(Unknown Source)
  at com.primavera.pvapplets.common.listeners.ListenerCollection.notifyListenersNoFail(Unknown Source)
  at com.primavera.pvapplets.reporting.ReportingContext.notifyListeners(Unknown Source)
  at com.primavera.pvapplets.reporting.dialogs.ScheduleReportDialog$2$1.doInBackground(Unknown Source)
  at javax.swing.SwingWorker$1.call(Unknown Source)
  at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
  at java.util.concurrent.FutureTask.run(Unknown Source)
  at javax.swing.SwingWorker.run(Unknown Source)
  at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
  at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
  at java.lang.Thread.run(Unknown Source)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log into P6 Web
2. Access the Reports tab
3. Attempt to run the report

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot run a particular report.

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