Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

BIP report fails

Received Response
33
Views
4
Comments

Summary

BIP report fails

Content

Getting the following error while generating a report from Siebel,

[050917_120852237][java.lang.String][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.invokeNewXSLStylesheet(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:585)

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:763)

at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:351)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:711)

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:303)

at java.lang.Thread.run(Thread.java:595)

Caused by: oracle.xdo.parser.v2.XSLException: <Line 840, Column 215>: XML-22049: (Error) Template 'sql8939' invoked but not defined.

at oracle.xdo.parser.v2.XSLStylesh

Any help would be appreciated

Answers

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    Looks like it's from calling a sub-template ... take a look through this thread - they got it to work.

  • Rajesh123
    Rajesh123 Rank 6 - Analytics Lead

    hi where is sql8939 in your template file?

    Caused by: oracle.xdo.parser.v2.XSLException: <Line 840, Column 215>: XML-22049: (Error) Template 'sql8939' invoked but not defined.

  • Brajesh Shukla-95078
    Brajesh Shukla-95078 Rank 7 - Analytics Coach

    From the Validate Template please locate sql8939  in which field you are using please take corrective action to fix this unknown tag

  • Venkat Thota - BIP
    Venkat Thota - BIP Rank 7 - Analytics Coach

    Validate Template , looks like its parameter issue ,without defining variable or parameter , you are using directly , please validate your template ,

    still face problem ,upload your template, thanks