Oracle Analytics Cloud and Server

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

Issue with RTF template - XML Publisher

Received Response
62
Views
1
Comments

Summary

Issue with RTF template - XML Publisher

Content

Hi All,

i am working on a graphical report using RTF template. i have used variable for storing calculated value and used it for plotting line graph.

report is working fine with sample data on my system but when i upload template to bip report is coming completely blank.

PFB, code snippet used with variable:

<RowData>

<xsl:value-of select="xdoxslt:set_variable($_XDOCTX,'ctc', number(0))"/>

<xsl:for-each-group select="current-group()" group-by="MON_YY" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"><Cell>

<xsl:variable name="ct" select="(current-group()/CASHTOTL[.!='']))"/>

<xsl:value-of select="$ct+xdoxslt:get_variable($_XDOCTX,'ctc')"/>

<xsl:value-of select="xdoxslt:set_variable($_XDOCTX,'ctc', $ct+xdoxslt:get_variable($_XDOCTX,'ctc'))"/>

</Cell></xsl:for-each-group></RowData>

i checked logs too,

<Line 253, Column 156>: XML-23002: (Error) internal xpath error

@Line 253 ==> <xsl:value-of select="xdoxslt:one($ct) + xdoxslt:nOne(xdoxslt:get_variable($_XDOCTX, 'ctc'))"/>

]]

[2017-02-06T05:22:34.813-05:00] [AdminServer] [WARNING] [] [oracle.xdo] [tid: 12] [userId: <anonymous>] [ecid: aaa1e3e54fdb4a71:2515ff09:1593f3a7f0f:-8000-0000000000002af9,0] [APP: bipublisher#11.1.1] oracle.xdo.XDOException: java.lang.reflect.InvocationTargetException[[

  at oracle.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:1237)

  at oracle.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:282)

  at oracle.xdo.template.FOProcessor.createFO(FOProcessor.java:1993)

  at oracle.xdo.template.FOProcessor.generate(FOProcessor.java:1155)

  at oracle.xdo.servlet.RTFCoreProcessor.transform(RTFCoreProcessor.java:124)

  at oracle.xdo.servlet.CoreProcessor.process(CoreProcessor.java:609)

  at oracle.xdo.servlet.CoreProcessor.generateDocument(CoreProcessor.java:101)

  at oracle.xdo.servlet.ReportImpl.renderBody(ReportImpl.java:1067)

  at oracle.xdo.servlet.ReportImpl.renderReportBody(ReportImpl.java:102)

  at oracle.xdo.server.impl.DefaultReport.run(DefaultReport.java:30)

  at oracle.xdo.webservice.v2.PublicReportServiceImpl.generateReport(PublicReportServiceImpl.java:603)

  at oracle.xdo.webservice.v2.ReportService.runReport(ReportService.java:69)

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

  at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)

  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)

  at oracle.xdo.servlet.metadata.track.MostRecentFilter.doFilter(MostRecentFilter.java:64)

  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)

  at oracle.xdo.servlet.init.InitCheckingFilter.doFilter(InitCheckingFilter.java:63)

  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)

  at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)

  at java.security.AccessController.doPrivileged(Native Method)

  at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324)

  at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:460)

  at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)

  at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)

  at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)

  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)

  at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:163)

  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)

  at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)

  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)

  at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3715)

  at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3681)

  at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)

  at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)

  at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2277)

  at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2183)

  at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1454)

  at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)

  at weblogic.work.ExecuteThread.run(ExecuteThread.java:178)

Caused by: 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.xdo.common.xml.XSLT10gR1.invokeProcessXSL(XSLT10gR1.java:917)

  at oracle.xdo.common.xml.XSLT10gR1.transform(XSLT10gR1.java:609)

  at oracle.xdo.common.xml.XSLT10gR1.transform(XSLT10gR1.java:327)

  at oracle.xdo.common.xml.XSLTWrapper.transform(XSLTWrapper.java:212)

  at oracle.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:1213)

  ... 57 more

any suggestions???????

Best Regards,

Answers

  • Zshaikh
    Zshaikh Rank 4 - Community Specialist

    Issue is resolved.

    updated code snippet :

    <RowData>

    <xsl:value-of select="xdoxslt:set_variable($_XDOCTX,'gctc', 0)"/>

    <xsl:value-of select="xdoxslt:set_variable($_XDOCTX,'guct', 0)"/>

    <xsl:for-each-group select="current-group()" group-by="MON_YY" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"><Cell>

    <xsl:value-of select="current-group()/CASHTOTL[.!='']+xdoxslt:get_variable($_XDOCTX,'gctc')"/>

    <xsl:value-of select="xdoxslt:set_variable($_XDOCTX,'gctc',current-group()/CASHTOTL[.!='']+xdoxslt:get_variable($_XDOCTX,'gctc'))"/>

    </Cell></xsl:for-each-group></RowData>