Why are scheduled Siebel BI Publisher Reports not generating after applying the Siebel 8.1.1.5 FixPack ? (Doc ID 1382647.1)

Last updated on JULY 20, 2016

Applies to:

Siebel Reports - Version 8.1.1.5 SIA [21229] and later
Information in this document applies to any platform.

Symptoms

Having applied the Siebel 8.1.1.5 FixPack whenever a Scheduled Report is run the report returns "No Data Found".

The standard report generation from the Siebel UI results in correct report generation and is not impacted.

In order to confirm that this behaviour is being encountered a review of the <report_name>.xdo file from the %ORACLE_HOME%\xmlp\XMLP\Reports\SiebelCRMReports\<report_name> folder should be made. This file will include a section for GetReportData_Input which should appear as follows :

  <ns1:GetReportData_Input>
     <ns1:NamedSearchSpec>%LABEL_1%</ns1:NamedSearchSpec>
     <ns1:LoginID>%LABEL_2%</ns1:LoginID>
     <ns1:TimeZone>%LABEL_3%</ns1:TimeZone>
     <ns1:OutputIntObjectName>%LABEL_4%</ns1:OutputIntObjectName>
     <ns1:Language>%LABEL_5%</ns1:Language>
     <ns1:Locale>%LABEL_6%</ns1:Locale>
     <ns1:PositionId>%LABEL_7%</ns1:PositionId>
     <ns1:SearchSpec>%LABEL_8%</ns1:SearchSpec>
     <ns1:CurrencyCode>%LABEL_9%</ns1:CurrencyCode>
     <ns1:ViewMode>%LABEL_10%</ns1:ViewMode>
   </ns1:GetReportData_Input>


If the .xdo file does not show this format and shows a format such as that shown below :

  <ns1:GetReportData_Input>
    <ns1:NamedSearchSpec>%LABEL_1%</ns1:NamedSearchSpec>
    <ns1:LoginID>%LABEL_2%</ns1:LoginID>
    <ns1:OutputIntObjectName>%LABEL_3%</ns1:OutputIntObjectName>
    <ns1:SearchSpec>%LABEL_4%</ns1:SearchSpec>
    <ns1:ViewMode>%LABEL_5%</ns1:ViewMode>
  </ns1:GetReportData_Input>


then the scheduled report will most likely return no data and the following error messages may be seen :

In the EAIObjMgr_xxx.log file :

WebSvcInbound WSInboundTrace 3 0000b0964ed80b1c:0 2011-12-02 12:17:50 Executing web service operation 'GetReportData' by calling method 'GetReportData' of business service 'XMLP Data Service'
Executing Operation '&1' by calling method '&2' of business service '&3'

ObjMgrBusServiceLog InvokeMethod 4 0000b0964ed80b1c:0 2011-12-02 12:17:50 Begin: Business Service 'XMLP Data Service' invoke method: 'GetReportData' at 2195d3a8

ObjMgrBusServiceLog Warning 2 0000b0964ed80b1c:0 2011-12-02 12:17:50 (service.cpp (1110)) SBL-DAT-00125: Required in argument 'TimeZone' not supplied for 'GetReportData' method in Business Service 'XMLP Data Service'

ObjMgrBusServiceLog InvokeMethod 4 0000b0964ed80b1c:0 2011-12-02 12:17:50 End: Business Service 'XMLP Data Service' invoke method: 'GetReportData' at 2195d3a8


In the BI Publishers xdo.log file immediately following the scheduled report request :

</soap:Envelope>, XPATH = [/GetReportData_Output/_XmlData/text()]
[120211_122454750][][EXCEPTION] java.lang.NullPointerException
at oracle.apps.xdo.webservice.wsclient.WSClient.findNodeByXPath(WSClient.java:1169)
at oracle.apps.xdo.webservice.wsclient.WSClient.sendMessage(WSClient.java:1109)
at oracle.apps.xdo.webservice.wsclient.WSClient.invokeWebServiceWithRequest(WSClient.java:1061)
at oracle.apps.xdo.servlet.data.server.WebServiceCall.callComplexClient(WebServiceCall.java:182)
at oracle.apps.xdo.servlet.data.server.WebServiceCall.doFetch(WebServiceCall.java:63)
at oracle.apps.xdo.servlet.data.server.AbstractDataCall.execute(AbstractDataCall.java:63)
at oracle.apps.xdo.servlet.data.bind.WebServiceBoundValue11.getValue(WebServiceBoundValue11.java:147)
at oracle.apps.xdo.servlet.ReportContextImplV11.getReportXMLData(ReportContextImplV11.java:412)
at oracle.apps.xdo.servlet.CoreProcessor.processScheduledRequest(CoreProcessor.java:420)
at oracle.apps.xdo.servlet.CoreProcessor.generateScheduledDocument(CoreProcessor.java:115)
at oracle.apps.xdo.servlet.ReportImpl.renderScheduledJob(ReportImpl.java:337)
at oracle.apps.xdo.servlet.scheduler.XDOJob.generateReport(XDOJob.java:953)
at oracle.apps.xdo.servlet.scheduler.XDOJob.execute(XDOJob.java:404)
at org.quartz.core.JobRunShell.run(JobRunShell.java:195)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)

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