10 Replies Latest reply on Feb 11, 2011 5:06 AM by Hussein Sawwan-Oracle

    XML Publisher Error

    797277
      Hi,

      When I run an xml publisher report, the pdf output gets generated. But sometimes, the reports conpletes with ERROR and shows half of the XML as the output and displays the below message when I click the view output.

      The XML page cannot be displayed

      Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later.


      --------------------------------------------------------------------------------

      The following tags were not closed: CWPOBPOPPDF, LIST_G_INIT_INFO, G_INIT_INFO, LIST_G_HEADERS, G_HEADERS, LIST_G_HEADER_NOT...


      Can any one please help me

      Thanks,
      HC.
        • 1. Re: XML Publisher Error
          Hussein Sawwan-Oracle
          Please mention the application release, database version and OS.

          What is the version of XML Publisher you use?

          Can you find any errors in the OPP log file?
          The following tags were not closed: CWPOBPOPPDF, LIST_G_INIT_INFO, G_INIT_INFO, LIST_G_HEADERS, G_HEADERS, LIST_G_HEADER_NOT...
          Is your XML report formatted properly? Do you have those tags closed?

          Warning:The Following Tags Were Not Closed ; Packing Slip XML Report [ID 751641.1]
          Cannot Create XML Input Using XSL Style Sheet [ID 559357.1]

          Thanks,
          Hussein
          1 person found this helpful
          • 2. Re: XML Publisher Error
            797277
            Hi,

            Below is the exception I found in OPP log.

            [2/8/11 5:19:23 PM] [UNEXPECTED] [840908:RT240649707] java.lang.reflect.InvocationTargetException
                 at sun.reflect.GeneratedMethodAccessor35.invoke(Unknown Source)
                 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                 at java.lang.reflect.Method.invoke(Method.java:597)
                 at oracle.apps.xdo.common.xml.XSLT10gR1.invokeParse(XSLT10gR1.java:566)
                 at oracle.apps.xdo.common.xml.XSLT10gR1.transform(XSLT10gR1.java:231)
                 at oracle.apps.xdo.common.xml.XSLTWrapper.transform(XSLTWrapper.java:182)
                 at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:1044)
                 at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:997)
                 at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:212)
                 at oracle.apps.xdo.template.FOProcessor.createFO(FOProcessor.java:1665)
                 at oracle.apps.xdo.template.FOProcessor.generate(FOProcessor.java:975)
                 at oracle.apps.xdo.oa.schema.server.TemplateHelper.runProcessTemplate(TemplateHelper.java:5926)
                 at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3458)
                 at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3547)
                 at oracle.apps.fnd.cp.opp.XMLPublisherProcessor.process(XMLPublisherProcessor.java:290)
                 at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:157)
            Caused by: org.xml.sax.SAXParseException: <Line 207, Column 28>: XML-20210: (Fatal Error) Unexpected EOF.
                 at oracle.xdo.parser.v2.XMLError.flushErrorHandler(XMLError.java:441)
                 at oracle.xdo.parser.v2.XMLError.flushErrors1(XMLError.java:303)
                 at oracle.xdo.parser.v2.XMLReader.popXMLReader(XMLReader.java:530)
                 at oracle.xdo.parser.v2.NonValidatingParser.parseElement(NonValidatingParser.java:1312)
                 at oracle.xdo.parser.v2.NonValidatingParser.parseRootElement(NonValidatingParser.java:338)
                 at oracle.xdo.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:285)
                 at oracle.xdo.parser.v2.XMLParser.parse(XMLParser.java:289)
                 ... 16 more

            Thanks,
            HC
            • 3. Re: XML Publisher Error
              Hussein Sawwan-Oracle
              Caused by: org.xml.sax.SAXParseException: <Line 207, Column 28>: XML-20210: (Fatal Error) Unexpected EOF.
              Have you verified this line/column?

              Please also see these docs.

              Output Post Processor Fails Due To oracle.xdo.parser.v2.XMLParseException: Unexpected EOF [ID 741501.1]
              Output Post Processor (OPP) Log Contains Error "oracle.xdo.parser.v2.XMLParseException: Unexpected EOF" [ID 1273272.1]

              Thanks,
              Hussein
              1 person found this helpful
              • 4. Re: XML Publisher Error
                797277
                Hi hsawwan,

                The links are helpful. I deactivated the template and data definition and ran the report. It is basically an rdf file. The output is still showing the xml data which is incomplete. So the rdf is not able to generated the full xml data. I found the below information in the links that you provided.

                -------------------------------------------------------------------------------------------------------------------------------------------------
                In case of an invalid XML data file, one needs to determine which process is responsible for creating it:
                * a custom PL/SQL program
                * a custom Report Definition File
                * a seeded concurrent program
                * a seeded Report Definition File

                -------------------------------------------------------------------------------------------------------------------------------------------------


                In my case its custom Report Definition File. So how to fix this now? Any ideas.

                Thanks,
                HC.
                • 5. Re: XML Publisher Error
                  Hussein Sawwan-Oracle
                  Please see the tutorial in this link -- http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/bi/xmlp_ebiz/index.html

                  Thanks,
                  Hussein
                  • 6. Re: XML Publisher Error
                    797277
                    Hi,

                    This XML PUblisher report is working good for other PO's and is erroring out only for one PO. Not sure if this is the issue with the OPP or with the report.

                    Thanks,
                    HC
                    • 7. Re: XML Publisher Error
                      Hussein Sawwan-Oracle
                      This XML PUblisher report is working good for other PO's and is erroring out only for one PO. Not sure if this is the issue with the OPP or with the report.
                      If it works for all POs except one, then most probably it is something with the data (not OPP or Report issue).

                      Thanks,
                      Hussein
                      • 8. Re: XML Publisher Error
                        MAmmar
                        I was getting the same error and then i realized that there was an image type item in my data model that XML Published was not able to read when generated data file.
                        1 person found this helpful
                        • 9. Re: XML Publisher Error
                          797277
                          Hi hsawwan,

                          You are correct. Its a very rare case and finally found the problem. The program is aborting at one column where the xml is not able to parse the value. The column is of type long and it is really a long value. How many characters an xml can hold?

                          Thanks,
                          HC
                          • 10. Re: XML Publisher Error
                            Hussein Sawwan-Oracle
                            Please see your other thread -- Re: Oracle rdf file formula column long value in to XML Data

                            Thanks,
                            Hussein