Problem Integrating BI Publisher with Weblogic (Doc ID 1363456.1)

Last updated on APRIL 25, 2016

Applies to:

Siebel Reports - Version 8.1.1 SIA [21111] to 8.1.1.5 SIA [21229] [Release V8]
Information in this document applies to any platform.
***Checked for relevance on 28-Jul-2014***

Symptoms

The reports can be uploaded without problems but an error message is received when try to run the OOTB reports:

XMLPReportServer Log

ObjMgrBusServiceLog Error 1 000003774e6f39c3:0 2011-09-14 14:39:14 (xmlpdriversvc.cpp (567)) SBL-RPT-50524: BI Publisher engine failed to generate report.
ObjMgrBusServiceLog InvokeMethod 4 000003774e6f39c3:0 2011-09-14 14:39:14 Business Service 'XMLP Driver Service' invoke method 'GenerateReport' Execute Time: 3.446 seconds.
ObjMgrBusServiceLog InvokeMethod 4 000003774e6f39c3:0 2011-09-14 14:39:14 End: Business Service 'XMLP Driver Service' invoke method: 'GenerateReport' at 76e1898
GenericLog GenericError 1 000003774e6f39c3:0 2011-09-14 14:39:14 Object manager error: ([0] BI Publisher engine failed to generate report.(SBL-RPT-50524) (0x95c55c))
GenericLog GenericError 1 000003774e6f39c3:0 2011-09-14 14:39:14 ( (0) err=2818155 sys=9815388) SBL-OMS-00107: Object manager error: ([0] BI Publisher engine failed to generate report.(SBL-RPT-50524) (0x95c55c))
GenericLog GenericError 1 000003774e6f39c3:0 2011-09-14 14:39:14 (bsvcmgr.cpp (1384) err=2818251 sys=0) SBL-OMS-00203: Error 9815388 invoking method "GenerateReport" for Business Service "XMLP Driver Service"
ObjMgrBusServiceLog Delete 4 000003774e6f39c3:0 2011-09-14 14:39:14 Business Service 'XMLP Driver Service' (address: '76e1898')was unregsitered at model 'e60380' for session ''
ObjMgrBusServiceLog Delete 4 000003774e6f39c3:0 2011-09-14 14:39:14 Business Service 'XMLP Driver Service' was deleted at 76e1898
GenericLog GenericError 1 000003774e6f39c3:0 2011-09-14 14:39:14 (bsvcmgr.cpp (1227) err=2818251 sys=0) SBL-OMS-00203: Error 9815388 invoking method "GenerateReport" for Business Service "XMLP Driver Service"


BI Publisher Log (xdo.log)

[091311_063357999][oracle.apps.xdo.common.xml.XSLTWrapper][ERROR] XSL error:

<Line 51, Column 154>: XML-22045: (Error) Extension function error: Class not found 'com.siebel.xmlpublisher.reports.XSLFunctions'

[091311_063358000][oracle.apps.xdo.template.FOProcessor][STATEMENT] clearInputs(Object) is called.
[091311_063358001][oracle.apps.xdo.template.FOProcessor][STATEMENT] clearInputs(Object) done. All inputs are cleared.
[091311_063358002][oracle.apps.xdo.template.FOProcessor][ERROR] End Memory: max=910MB, total=241MB, free=55MB
[091311_063358006][][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:91)
at oracle.apps.xdo.servlet.CoreProcessor.process(CoreProcessor.java:384)
at oracle.apps.xdo.servlet.CoreProcessor.generateDocument(CoreProcessor.java:98)
at oracle.apps.xdo.servlet.ReportImpl.renderBody(ReportImpl.java:502)
at oracle.apps.xdo.servlet.ReportImpl.renderReportBody(ReportImpl.java:81)
at oracle.apps.xdo.server.impl.DefaultReport.run(DefaultReport.java:44)
at oracle.apps.xdo.webservice.v11.PublicReportServiceImpl.generateReport(PublicReportServiceImpl.java:286)
at oracle.apps.xdo.webservice.v11.PublicReportService.runReport(PublicReportService.java:229)
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 org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397)
at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186)
at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323)
at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)
at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)
at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:454)
at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281)
at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:351)
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:292)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:175)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3591)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2202)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2108)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1432)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)
Caused by: oracle.xdo.parser.v2.XPathException: Extension function error: Class not found 'com.siebel.xmlpublisher.reports.XSLFunctions'
at oracle.xdo.parser.v2.XSLStylesheet.flushErrors(XSLStylesheet.java:1534)
at oracle.xdo.parser.v2.XSLStylesheet.execute(XSLStylesheet.java:521)
at oracle.xdo.parser.v2.XSLStylesheet.execute(XSLStylesheet.java:489)
at oracle.xdo.parser.v2.XSLProcessor.processXSL(XSLProcessor.java:271)
at oracle.xdo.parser.v2.XSLProcessor.processXSL(XSLProcessor.java:155)
at oracle.xdo.parser.v2.XSLProcessor.processXSL(XSLProcessor.java:192)
... 48 more
This is also observed with Oracle Application Server:

[100711_151645601][oracle.apps.xdo.common.xml.XSLTWrapper][ERROR] XSL error:

<Line 53, Column 170>: 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: /apps/bip/OracleAS_1/j2ee/home/applications/xmlpserver/xmlpserver/WEB-INF/lib/xdoparser.jar
             Configuration: WEB-INF/lib directory in /apps/bip/OracleAS_1/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 53 ==> </_A><_B><xsl:value-of select="psfn:phoneFormat(.//ssMainPhoneNumber)" xdofo:field-name="psfn:phoneFormat (ssMainPhoneNumber)"/>

[100711_151645615][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:585)
          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)

=================

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