Siebel BI Publisher reports are failing with an oracle.apps.xdo.XDOException (Doc ID 1401663.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

When attempting to run a Siebel BI Publisher report which contains calls to date formatting functions in the XSLFunctions.jar file the report will fail to generate and the following call stack will appear in the BI Publisher console window :

[012412_155502234][oracle.apps.xdo.common.xml.XSLTWrapper][ERROR] XSL error:

<Line 116, Column 353>: XML-22045: (Error) Extension function error: Class not found '

Missing class: com.siebel.xmlpublisher.reports.XSLFunctions

Dependent class: oracle.xdo.parser.v2.XSLExtFunctions
Loader: xmlpserver.web.xmlpserver:0.0.0
Code-Source: /C:/OracleHome1/oc4j_bi/j2ee/home/applications/xmlpserver/xmlpserver/WEB-INF/lib/xdoparser.jar
Configuration: WEB-INF/lib/ directory in C:\OracleHome1\oc4j_bi\j2ee\home\applications\xmlpserver\xmlpserver\WEB-INF\lib

This load was initiated at xmlpserver.web.xmlpserver:0.0.0 using the loadClass() method.

The missing class is not available from any code-source or loader in the system.'
@Line 116 ==> </_g><_h><fo:inline xml:space="preserve" font-size="9.0pt" white-space-collapse="false" height="9.0pt" font-family="Times New Roman"><xsl:value-of select="xdoxslt:xdo_format_date($_XDOXSLTCTX, psfn:totext(.//X:CitiLastUpd,&quot;yyyy-MM-dd'T'HH:mm:ss&quot;,&quot;MM/dd/yyyy hh:mm:ss&quot;), 'DD-MMM-YYYY')"/> </fo:inline>
[012412_155502250][oracle.apps.xdo.template.FOProcessor][EXCEPTION] java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at oracle.apps.xdo.common.xml.XSLT10gR1.invokeProcessXSL(Unknown Source)
at oracle.apps.xdo.common.xml.XSLT10gR1.transform(Unknown Source)
at oracle.apps.xdo.common.xml.XSLT10gR1.transform(Unknown Source)
at oracle.apps.xdo.common.xml.XSLTWrapper.transform(Unknown Source)
at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(Unknown Source)
at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(Unknown Source)
at oracle.apps.xdo.template.FOProcessor.createFO(Unknown Source)
at oracle.apps.xdo.template.FOProcessor.generate(Unknown Source)
at oracle.apps.xdo.servlet.RTFCoreProcessor.transform(RTFCoreProcessor.java:70)
at oracle.apps.xdo.servlet.CoreProcessor.process(CoreProcessor.java:249)
at oracle.apps.xdo.servlet.CoreProcessor.generateDocument(CoreProcessor.java:81)
at oracle.apps.xdo.servlet.ReportImpl.renderBodyHTTP(ReportImpl.java:572)
at oracle.apps.xdo.servlet.ReportImpl.renderReportBodyHTTP(ReportImpl.java:270)
at oracle.apps.xdo.servlet.XDOServlet.writeReport(XDOServlet.java:265)
at oracle.apps.xdo.servlet.XDOServlet.writeReport(XDOServlet.java:245)
at oracle.apps.xdo.servlet.XDOServlet.doGet(XDOServlet.java:140)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:743)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
at oracle.apps.xdo.servlet.security.SecurityFilter.doFilter(SecurityFilter.java:181)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:621)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:368)
at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:866)
at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:448)
at com.evermind.server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java:216)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:117)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:110)
at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
at oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(ServerSocketAcceptHandler.java:239)
at oracle.oc4j.network.ServerSocketAcceptHandler.access$700(ServerSocketAcceptHandler.java:34)
at oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSocketAcceptHandler.java:880)
at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:298)
at java.lang.Thread.run(Thread.java:619)


On the Siebel side the XMLPReportServer_xxx.log file will show evidence of HTTP 500 errors during communication with BI Publisher and a XDOException being returned :

ObjMgrLog Error 1 0000047c4f1f08f0:0 2012-01-25 04:42:30 (httptransport.cpp (1631)) SBL-EAI-04117: HTTP Request error during 'Submitting Data SendHTTP request': 'Status code - 500'

ObjMgrLog Error 1 0000047c4f1f08f0:0 2012-01-25 04:42:30 (httptransport.cpp (981)) SBL-EAI-04117: HTTP Request error during 'Submitting Data Send HTTP request': 'Status code - 500'

 

ObjMgrLog Error 1 0000047c4f1f08f0:0 2012-01-25 04:42:30 (soapbinding.cpp (610)) SBL-EAI-04304: Unknown Part ':oracle.apps.xdo.webservice.exception.OperationFailedException' for operation 'runReport' exists in SOAP message.

ObjMgrBusServiceLog Error 1 0000047c4f1f08f0:0 2012-01-25 04:42:30 (outdisp.cpp (233)) SBL-EAI-04308: Operation 'runReport' of Web Service 'http://xmlns.oracle.com/oxp/service/v11/PublicReportService.PublicReportServiceService' at port 'PublicReportService_v11' failed with the following explanation: "oracle.apps.xdo.webservice.exception.OperationFailedException: PublicReportService::generateReport failed: due to oracle.apps.xdo.XDOException".



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