Running BI Publisher Report From P6 Fails With Error: "Oracle.xdo.XDOException: Java.lang.NullPointerException"

(Doc ID 2269583.1)

Last updated on JUNE 19, 2017

Applies to:

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

Symptoms

When attempting to run a BI Publisher report from P6, the following error occurs:

ERROR

oracle.xdo.XDOException: java.lang.NullPointerException

P6WebAccess.html log shows the following:

[ACTIVE] ExecuteThread: '6' for queue: 'weblogic.kernel.Default (self-tuning)' ERROR /rest/reports/reportRun/save (User Id: 274 DB Id: 1) com.primavera.rest.service.reports.helpers.JAXWSReportServiceWrapper11gr1v2LWF ?:? oracle.xdo.webservice.exception.OperationFailedException: PublicReportService::generateReport for reportAbsolutePath [/P6Reports/Activity/Activities That Can Work.xdo] failed: due to oracle.xdo.XDOException: java.lang.NullPointerException
javax.xml.ws.soap.SOAPFaultException: oracle.xdo.webservice.exception.OperationFailedException: PublicReportService::generateReport for reportAbsolutePath [/P6Reports/Activity/Activities That Can Work.xdo] failed: due to oracle.xdo.XDOException: java.lang.NullPointerException
  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)
......

[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)' ERROR /rest/reports/parameters/load?reportId=/P6Reports/Activity/Activities That Can Work.xdo (User Id: 274 DB Id: 1) com.primavera.rest.service.reports.helpers.JAXWSReportServiceWrapper11gr1v2LWF ?:? null
java.lang.NullPointerException
  at com.primavera.rest.service.reports.helpers.JAXWSReportServiceWrapper11gr1v2LWF.getParameters(JAXWSReportServiceWrapper11gr1v2LWF.java:280)
  at com.primavera.rest.service.reports.helpers.JAXWSReportServiceWrapper11gr1v2LWF.getParameters(JAXWSReportServiceWrapper11gr1v2LWF.java:266)
  at com.primavera.rest.service.reports.ReportsServiceImpl.loadParameterData(ReportsServiceImpl.java:290)
  at com.primavera.rest.resources.reports.ReportsResource.loadParameters(ReportsResource.java:180)
......


BUSINESS IMPACT

The issue has the following business impact:
Due to this issue, users cannot run a BI Publisher report from P6.

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