Oracle Analytics Publisher

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Publisher

Categories

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

BI Publisher Report Generation Exception

Received Response
156
Views
7
Comments
ManivasagamG
ManivasagamG Rank 2 - Community Beginner
edited Apr 10, 2024 2:36PM in Oracle Analytics Publisher

Hi,

I have used the latest bi publisher desktop version software and added as plugin to the MS-Word 2016 version for testing.

Later, I have create the template with RTF extension and then used Bi publisher→Translation→Extract Text→ download XLIFF file in local directory. But, This file creates some problem and got below error whenever the generate the reports,

Expection details: Public Report Service:: generate report failed: due to oracle.apps.xdo.XDOException[null]:

Please help me on this issue. Thanks in advance!

Tagged:

Answers

  • Mallikarjuna Kuppauru-Oracle
    Mallikarjuna Kuppauru-Oracle Rank 8 - Analytics Strategist

    Hi @User_4FA5C

    Can you confrim are you getting this Error while download the data to XLIFF file or while running rtf file?

    In general - issue with either JAVA options or BI Publisher's XSLT processor configuration.

    Check below and try again?

    setting the following property to 12c: "Use BI Publisher's XSLT processor"

    1. Edit the report and click on the report Properties and Formatting tab.
    2. Located "Use BI Publisher's XSLT processor" and set it to "12c"
    3. Save the report.

    Also check for bi publisher log file for more details.

    Regards,

    Arjun

  • ManivasagamG
    ManivasagamG Rank 2 - Community Beginner
    edited Apr 12, 2024 1:03PM

    Hi @Mallikarjuna Kuppauru-Oracle ,

    I am not able to find the 12c option in Use BI Publisher's XSLT processor configuration only true/false available. posted below screenshot,

    Capture4.PNG



    In bi publisher logs, I see the below error,

    at java.lang.Thread.run(Unknown Source)
    Caused by: oracle.xdo.parser.v2.XSLException: <Line 412, Column 193>: XML-22049: (Error) Template 'sql_73d099e6_9' invoked but not defined.
    at oracle.xdo.parser.v2.XSLStylesheet.flushErrors(XSLStylesheet.java:1534)
    at oracle.xdo.parser.v2.XSLStylesheet.endContent(XSLStylesheet.java:337)
    at oracle.xdo.parser.v2.XSLBuilder.endDocument(XSLBuilder.java:287)
    at oracle.xdo.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:313)
    at oracle.xdo.parser.v2.XMLParser.parse(XMLParser.java:320)
    at oracle.xdo.parser.v2.XSLProcessor.newXSLStylesheet(XSLProcessor.java:610)

    Thanks,

    Mani


  • Mallikarjuna Kuppauru-Oracle
    Mallikarjuna Kuppauru-Oracle Rank 8 - Analytics Strategist

    Hi @ManivasagamG

    As per Error , its an Bug in the Older version but as per your question you are using latest version .

    BI Publisher Corrupts RTF SubTemplates When Uploaded and Generates Error:
    XML-22049 When SubTemplate referenced in Report. (Doc ID 2176937.1)

    Are you using Latest JAVA version?

    Regards,

    Arjun

  • ManivasagamG
    ManivasagamG Rank 2 - Community Beginner
    edited Apr 23, 2024 2:57AM

    Hi @Mallikarjuna Kuppauru-Oracle,

    I tried with two different way,

    1. JDK Kit 11.0 in my own machine

    java version "11.0.17" 2022-10-18 LTS
    Java(TM) SE Runtime Environment 18.9 (build 11.0.17+10-LTS-269)
    Java HotSpot(TM) 64-Bit Server VM 18.9 (build 11.0.17+10-LTS-269, mixed mode)

    Her ,I have used MS-Office 2016 & 12.2.1.4 bi publisher desktop software as plugin) to generate xlf file.

    2. Similarly, via virtual machine tried with old java versions(JDK 7 & Windows 7) too,

    java version "1.7.0_80"
    Java(TM) SE Runtime Environment (1.7.0_80-b15)
    Java HotSpot(TM) 64-Bit Server VM(build 24.80-b11, mixed mode)

    Here, I have used both 2016 & 2013 version of MS -office with latest(12.2.7.0) and old bi publisher software to generate the XLF file.

    Nothing works sadly:(.

    Always i got the "Caused by: oracle.xdo.parser.v2.XSLException…: XML-22049: (Error) Template 'sql_73d099e6_9' invoked but not defined."


    Not able to access th Doc Link:  (Doc ID 2176937.1) .

    Thanks,

    Mani

  • ManivasagamG
    ManivasagamG Rank 2 - Community Beginner

    Hi @Mallikarjuna Kuppauru-Oracle ,

    I tried with JDK 8 version with latest bi publisher. It doesn't work. Any other suggestions?

    Thanks,

    Manivasagam G

  • Mallikarjuna Kuppauru-Oracle
    Mallikarjuna Kuppauru-Oracle Rank 8 - Analytics Strategist

    Hi @ManivasagamG

    What is your BIP server version? are you using same jdk and jre version?

    Regards

    Arjun

  • ManivasagamG
    ManivasagamG Rank 2 - Community Beginner

    Hi @Mallikarjuna Kuppauru-Oracle ,

    BIP Version: 12.2.7.0

    JDK 8 & Java 8 Update 202

    image.png

    Thanks,

    Mani