Running BI Publisher Report From P6 Fails With Error: "Oracle.xdo.XDOException: Java.lang.NullPointerException" (Doc ID 2269583.1)

Last updated on JULY 28, 2023

Applies to:

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: <ID> DB Id: <ID>) 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: <ID> DB Id: <ID>) 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.

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.