12 Replies Latest reply on Sep 29, 2010 1:53 PM by Martin Fritz - Oracle-Oracle

    Bursting NoSuchElement  and ZIP errors

    622254
      If some one could give me some direction on these errors that would be great.

      [072508_090722286][][EXCEPTION] java.util.NoSuchElementException
           at java.util.Vector.lastElement(Vector.java:518)
           at oracle.apps.xdo.batch.BurstingProcessorEngine.removeEndPath(BurstingProcessorEngine.java:2012)
           at oracle.apps.xdo.batch.BurstingProcessorEngine.globalDataEndElement(BurstingProcessorEngine.java:1965)
           at oracle.apps.xdo.batch.BurstingProcessorEngine.endElement(BurstingProcessorEngine.java:1133)
           at oracle.xml.parser.v2.XMLContentHandler.endElement(XMLContentHandler.java:210)
           at oracle.xml.parser.v2.NonValidatingParser.parseElement(NonValidatingParser.java:1310)
           at oracle.xml.parser.v2.NonValidatingParser.parseRootElement(NonValidatingParser.java:328)
           at oracle.xml.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:295)
           at oracle.xml.parser.v2.XMLParser.parse(XMLParser.java:258)
           at oracle.apps.xdo.batch.BurstingProcessorEngine.burstingRequest(BurstingProcessorEngine.java:2167)
           at oracle.apps.xdo.batch.BurstingProcessorEngine.burstingEndElement(BurstingProcessorEngine.java:1800)
           at oracle.apps.xdo.batch.BurstingProcessorEngine.endElement(BurstingProcessorEngine.java:1136)
           at oracle.xml.parser.v2.XMLContentHandler.endElement(XMLContentHandler.java:210)
           at oracle.xml.parser.v2.NonValidatingParser.parseElement(NonValidatingParser.java:1310)
           at oracle.xml.parser.v2.NonValidatingParser.parseRootElement(NonValidatingParser.java:328)
           at oracle.xml.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:295)
           at oracle.xml.parser.v2.XMLParser.parse(XMLParser.java:287)
           at oracle.apps.xdo.batch.BurstingProcessorEngine.burstingConfigParser(BurstingProcessorEngine.java:968)
           at oracle.apps.xdo.batch.BurstingProcessorEngine.process(BurstingProcessorEngine.java:912)
           at oracle.apps.xdo.oa.cp.JCP4XDOBurstingEngine.runProgram(JCP4XDOBurstingEngine.java:278)
           at oracle.apps.fnd.cp.request.Run.main(Run.java:157)

      Bursting process complete..
      Generating Bursting Status Report..
      --Exception
      ZIP file must have at least one entry
      java.util.zip.ZipException: ZIP file must have at least one entry
           at java.util.zip.ZipOutputStream.finish(ZipOutputStream.java:316)
           at oracle.apps.xdo.oa.cp.JCP4XDOBurstingEngine.zipOutputFiles(JCP4XDOBurstingEngine.java:526)
           at oracle.apps.xdo.oa.cp.JCP4XDOBurstingEngine.runProgram(JCP4XDOBurstingEngine.java:284)
           at oracle.apps.fnd.cp.request.Run.main(Run.java:157)
        • 1. Re: Bursting NoSuchElement  and ZIP errors
          Tim Dexter-Oracle
          Hi

          Not w/o some more information.

          Version and flavor of Publisher
          The bursting criteria
          The XML whee not run in bursting mode
          Template - you can not post this but I thik the problem is further back in the data.

          Regards

          Tim

          http://blogs.oracle.com/xmlpublisher
          • 2. Re: Bursting NoSuchElement  and ZIP errors
            622254
            <?xml version="1.0" encoding="UTF-8"?>
            <xapi:requestset xmlns:xapi="http://xmlns.oracle.com/oxp/xapi">
            <xapi:request select="/<level>"><!-- This sets the bursting
            element i.e., EMPLOYEE -->
            <xapi:delivery>
            <xapi:email server="<server address>" port="<port>" from="<name>@<company>.com" reply-to ="<name>@<company>.com">
            <xapi:message id="123" to="harold.dost@kettering.edu" cc="" attachment="true" subject="Bursting Test">
            Mr....., Please review the attached document
            </xapi:message>
            <!-- This assigns a delivery id of '123'. It also sets the e-mail address of the employee and a cc copy to a parameter value EMAIL_ALL; this might be a manager's e-mail. The employee's name (ENAME) can also be used in the subject/body of the email. -->
            </xapi:email>
            </xapi:delivery>
            <xapi:document output-type="pdf" delivery="123">
            <xapi:template type="rtf" location="<location>"/> << THIS may be the problem what would be a good example of what to have here
            <!-- Employees with the name SMITH will have the empDet template applied -->
            </xapi:document>
            </xapi:request>
            </xapi:requestset>



            This is placed in the after_report trigger

            FUNCTION submit_request_burst( p_code IN VARCHAR2, p_request_id IN NUMBER) RETURN NUMBER
            IS
            l_req_id number := 0;
            BEGIN
            IF p_code = 'XXBURSTTEST' THEN
            l_req_id := FND_REQUEST.SUBMIT_REQUEST('XDO','XDOBURSTREP',NULL,NULL,FALSE,FND_GLOBAL.CONC_REQUEST_ID,FND_GLOBAL.CONC_REQUEST_ID);
            END IF;

            RETURN l_req_id;
            END submit_request_burst;
            • 3. Re: Bursting NoSuchElement  and ZIP errors
              197431
              I am running into the same issue. I am on 11i with 5.6.3. This happens when attempting to run something similar to the following:

              fnd_request.submit_request('XDO'
              ,'XDOBURSTREP'
              ,NULL
              ,NULL
              ,FALSE
              ,p_request_id
              ,'Y'
              );





              More info: Opp error output:

              [8/29/08 4:58:59 PM] [OPPServiceThread1] Post-processing request 27624726.
              [8/29/08 4:58:59 PM] [STATEMENT] [OPPServiceThread1] 1 threads running
              [8/29/08 4:58:59 PM] [48417:RT27624726] Executing post-processing actions for request 27624726.
              [8/29/08 4:58:59 PM] [STATEMENT] [48417:RT27624726] Now running XMLPublisher
              [8/29/08 4:58:59 PM] [48417:RT27624726] Starting XML Publisher post-processing action.
              [8/29/08 4:58:59 PM] [48417:RT27624726]
              Template code: BURST_STATUS_REPORT
              Template app: XDO
              Language: en
              Territory: US
              Output type: PDF
              [8/29/08 4:58:59 PM] [STATEMENT] [48417:RT27624726] Get Output Type
              [8/29/08 4:58:59 PM] [STATEMENT] [48417:RT27624726] XML file name: /DEV1/code/applmgr/11.5.9/dev1comn/admin/out/DEV1_oradev1/o27624726.out
              [8/29/08 4:58:59 PM] [STATEMENT] [48417:RT27624726] XML file is on node: ORADEV1
              [8/29/08 4:58:59 PM] [STATEMENT] [48417:RT27624726] Local node is: ORADEV1
              [8/29/08 4:58:59 PM] [STATEMENT] [48417:RT27624726] Retrieving Template properties
              [8/29/08 4:58:59 PM] [STATEMENT] [48417:RT27624726] Adding Property : xslt.ReportRequestID Value : 27624709
              [8/29/08 4:58:59 PM] [STATEMENT] [48417:RT27624726] Adding Property : xslt.DebugFlag Value : Y
              [8/29/08 4:58:59 PM] [STATEMENT] [48417:RT27624726] Using local XML file
              [8/29/08 4:58:59 PM] [STATEMENT] [48417:RT27624726] New output file is: /DEV1/code/applmgr/11.5.9/dev1comn/admin/out/DEV1_oradev1/XDOBURSTREP_27624726_1.PDF
              [8/29/08 4:58:59 PM] [STATEMENT] [48417:RT27624726] BEGIN XMLPublisher
              [8/29/08 4:59:00 PM] [STATEMENT] [48417:RT27624726] Failed to process the template
              [8/29/08 4:59:00 PM] [UNEXPECTED] [48417:RT27624726] java.lang.reflect.InvocationTargetException: oracle.xdo.parser.v2.XMLParseException: Start of root element expected.
              at oracle.xdo.parser.v2.XMLError.flushErrors1(XMLError.java:324)
              at oracle.xdo.parser.v2.NonValidatingParser.parseRootElement(NonValidatingParser.java:319)
              at oracle.xdo.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:281)
              at oracle.xdo.parser.v2.XMLParser.parse(XMLParser.java:266)
              at java.lang.reflect.Method.invoke(Native Method)
              at oracle.apps.xdo.common.xml.XSLT10gR1.invokeParse(XSLT10gR1.java:517)
              at oracle.apps.xdo.common.xml.XSLT10gR1.transform(XSLT10gR1.java:224)
              at oracle.apps.xdo.common.xml.XSLTWrapper.transform(XSLTWrapper.java:177)
              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:1657)
              at oracle.apps.xdo.template.FOProcessor.generate(FOProcessor.java:967)
              at oracle.apps.xdo.oa.schema.server.TemplateHelper.runProcessTemplate(TemplateHelper.java:5888)
              at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3438)
              at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3527)
              at oracle.apps.fnd.cp.opp.XMLPublisherProcessor.process(XMLPublisherProcessor.java:247)
              at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:153)

              [8/29/08 4:59:00 PM] [48417:RT27624726] Completed post-processing actions for request 27624726.




              Request Log:

              XML/BI Publisher Version : 5.6.3
              Request ID: 27624726
              All Parameters: ReportRequestID=27624709:DebugFlag=Y
              Report Req ID: 27624709
              Debug Flag: Y
              Updating request description
              Updated description
              Retrieving XML request information
              Node Name:ORADEV1
              Preparing parameters
              null output =/DEV1/code/applmgr/11.5.9/dev1comn/admin/out/DEV1_oradev1/o27624726.out
              inputfilename =/DEV1/code/applmgr/11.5.9/dev1comn/admin/out/DEV1_oradev1/o27624709.out
              Data XML File:/DEV1/code/applmgr/11.5.9/dev1comn/admin/out/DEV1_oradev1/o27624709.out
              Set Bursting parameters..
              Temp. Directory:/usr/tmp
              [082908_045858537][][STATEMENT] Oracle XML Parser version ::: Oracle XDK Java 9.0.4.0.0 Production
              [082908_045858540][][STATEMENT] setOAProperties called..
              Bursting propertes.....
              {user-variable:cp:reportdescription=Datacard HR Employee Interface Error Report, user-variable:cp:territory=US
              , user-variable:cp:language=en, user-variable.OA_MEDIA=http://oradev1.*****.com:8008/OA_MEDIA, user-variabl
              e:cp:responsibility=20420, burstng-source=EBS, user-variable:cp:application_short_name=XDO, user-variable:cp:r
              equest_id=27624726, user-variable:cp:user=*****, user-variable:cp:locale=en-US, user-variable:cp:parent_requ
              est_id=27624709, user-variable:cp:DebugFlag=Y, user-variable:cp:ReportRequestID=27624709, user-variable:cp:org
              _id=84}
              Start bursting process..
              Bursting process complete..
              Generating Bursting Status Report..
              --Exception
              ZIP file must have at least one entry
              java.util.zip.ZipException: ZIP file must have at least one entry
              at java.util.zip.ZipOutputStream.finish(ZipOutputStream.java:288)
              at oracle.apps.xdo.oa.cp.JCP4XDOBurstingEngine.zipOutputFiles(JCP4XDOBurstingEngine.java:534)
              at oracle.apps.xdo.oa.cp.JCP4XDOBurstingEngine.runProgram(JCP4XDOBurstingEngine.java:292)
              at oracle.apps.fnd.cp.request.Run.main(Run.java:161)

              ---------------------------------------------------------------------------
              Start of log messages from FND_FILE
              ---------------------------------------------------------------------------
              ---------------------------------------------------------------------------
              End of log messages from FND_FILE
              ---------------------------------------------------------------------------


              ---------------------------------------------------------------------------
              Executing request completion options...

              ------------- 1) PUBLISH -------------
              Beginning post-processing of request 27624726 on node ORADEV1 at 29-AUG-2008 16:58:59.
              Post-processing of request 27624726 failed at 29-AUG-2008 16:58:59 with the error message:
              One or more post-processing actions failed. Consult the OPP service log for details.
              --------------------------------------
              • 4. Re: Bursting NoSuchElement  and ZIP errors
                gubbalas
                Hi Guys,

                I am having the same problem...

                Can anybody please update ...

                Thanks
                srini
                • 5. Re: Bursting NoSuchElement  and ZIP errors
                  524753
                  Was the temp folder set ??

                  Bursting uses the temp folder..
                  • 6. Re: Bursting NoSuchElement  and ZIP errors
                    gubbalas
                    Hi srini,

                    Yes Temp folder is set .. Here is the log file

                    XML Publisher: Version : 11.5.0

                    Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

                    XDOBURSTREP module: XML Publisher Report Bursting Program
                    ---------------------------------------------------------------------------

                    Current system time is 22-OCT-2008 13:26:23

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

                    XML/BI Publisher Version : 5.6.3
                    Request ID: 6755675
                    All Parameters: ReportRequestID=6755673:DebugFlag=Y
                    Report Req ID: 6755673
                    Debug Flag: Y
                    Updating request description
                    Updated description
                    Retrieving XML request information
                    Node Name:MT6
                    Preparing parameters
                    null output =/u01/oracle/dev4comn/admin/out/dev4_mt6/o6755675.out
                    inputfilename =/u01/oracle/dev4comn/admin/out/dev4_mt6/o6755673.out
                    Data XML File:/u01/oracle/dev4comn/admin/out/dev4_mt6/o6755673.out
                    Set Bursting parameters..
                    Temp. Directory:/usr/tmp
                    [102208_012626792][][STATEMENT] Oracle XML Parser version ::: Oracle XDK Java 9.0.4.0.0 Production
                    [102208_012626796][][STATEMENT] setOAProperties called..
                    Bursting propertes.....
                    {user-variable:cp:territory=US, user-variable:cp:ReportRequestID=6755673, user-variable:cp:language=en, user-variable:cp:responsibility=24195, user-variable.OA_MEDIA=http://mt6.simfoods.com:8005/OA_MEDIA, burstng-source=EBS, user-variable:cp:DebugFlag=Y, user-variable:cp:parent_request_id=6755673, user-variable:cp:locale=en-US, user-variable:cp:user=SGUBBALA, user-variable:cp:application_short_name=XDO, user-variable:cp:request_id=6755675, user-variable:cp:org_id=101, user-variable:cp:reportdescription=SIMMONS EMAIL INVOICE REPORT}
                    Start bursting process..
                    Bursting process complete..
                    Generating Bursting Status Report..
                    --Exception
                    ZIP file must have at least one entry
                    java.util.zip.ZipException: ZIP file must have at least one entry
                         at java.util.zip.ZipOutputStream.finish(ZipOutputStream.java:292)
                         at oracle.apps.xdo.oa.cp.JCP4XDOBurstingEngine.zipOutputFiles(JCP4XDOBurstingEngine.java:534)
                         at oracle.apps.xdo.oa.cp.JCP4XDOBurstingEngine.runProgram(JCP4XDOBurstingEngine.java:292)
                         at oracle.apps.fnd.cp.request.Run.main(Run.java:161)

                    ---------------------------------------------------------------------------
                    Start of log messages from FND_FILE
                    ---------------------------------------------------------------------------
                    ---------------------------------------------------------------------------
                    End of log messages from FND_FILE
                    ---------------------------------------------------------------------------


                    ---------------------------------------------------------------------------
                    Executing request completion options...

                    ------------- 1) PUBLISH -------------
                    Beginning post-processing of request 6755675 on node MT6 at 22-OCT-2008 13:26:27.
                    Post-processing of request 6755675 failed at 22-OCT-2008 13:26:27 with the error message:
                    One or more post-processing actions failed. Consult the OPP service log for details.
                    --------------------------------------


                    Finished executing request completion options.

                    ---------------------------------------------------------------------------
                    Concurrent request completed
                    Current system time is 22-OCT-2008 13:26:27

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


                    Thanks
                    srini
                    • 7. Re: Bursting NoSuchElement  and ZIP errors
                      617279
                      Hello Srini,

                      Did you find the solution for this problem.

                      Thanks,
                      Anil.
                      • 8. Re: Bursting NoSuchElement  and ZIP errors
                        524753
                        Try getting latest patch .
                        • 9. Re: Bursting NoSuchElement  and ZIP errors
                          680183
                          Hello,

                          We're on 5.6.3 (with the latest patch) and also getting similar error. However, it's happening only if our bursting control file is referencing +1-level xml+ on its select attribute( request element).

                          Not sure if it's a bug/ limitation or anything from the BURSTING Control file but I found similar issue here Re: Bursting Fails with java.util.NoSuchElementException after 5.6.3 upgrade , but found no solution from Oracle team.

                          Any ideas? It would be helpful in bursting non-RDF reports such as FSG.



                          Start bursting process..
                          *[032309_032311003][][EXCEPTION] java.util.NoSuchElementException*
                               at java.util.Vector.lastElement(Vector.java:449)
                               at oracle.apps.xdo.batch.BurstingProcessorEngine.removeEndPath(BurstingProcessorEngine.java:1999)
                               at oracle.apps.xdo.batch.BurstingProcessorEngine.globalDataEndElement(BurstingProcessorEngine.java:1944)
                               at oracle.apps.xdo.batch.BurstingProcessorEngine.endElement(BurstingProcessorEngine.java:1124)
                               at oracle.xml.parser.v2.XMLContentHandler.endElement(XMLContentHandler.java:196)
                               at oracle.xml.parser.v2.NonValidatingParser.parseElement(NonValidatingParser.java:1212)
                               at oracle.xml.parser.v2.NonValidatingParser.parseRootElement(NonValidatingParser.java:301)
                               at oracle.xml.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:268)
                               at oracle.xml.parser.v2.XMLParser.parse(XMLParser.java:201)
                               at oracle.apps.xdo.batch.BurstingProcessorEngine.burstingRequest(BurstingProcessorEngine.java:2153)
                               at oracle.apps.xdo.batch.BurstingProcessorEngine.burstingEndElement(BurstingProcessorEngine.java:1802)
                               at oracle.apps.xdo.batch.BurstingProcessorEngine.endElement(BurstingProcessorEngine.java:1127)
                               at oracle.xml.parser.v2.XMLContentHandler.endElement(XMLContentHandler.java:196)
                               at oracle.xml.parser.v2.NonValidatingParser.parseElement(NonValidatingParser.java:1212)
                               at oracle.xml.parser.v2.NonValidatingParser.parseRootElement(NonValidatingParser.java:301)
                               at oracle.xml.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:268)
                               at oracle.xml.parser.v2.XMLParser.parse(XMLParser.java:227)
                               at oracle.apps.xdo.batch.BurstingProcessorEngine.burstingConfigParser(BurstingProcessorEngine.java:959)
                               at oracle.apps.xdo.batch.BurstingProcessorEngine.process(BurstingProcessorEngine.java:903)
                               at oracle.apps.xdo.oa.cp.JCP4XDOBurstingEngine.runProgram(JCP4XDOBurstingEngine.java:269)
                               at oracle.apps.fnd.cp.request.Run.main(Run.java:161)

                          Thanks,
                          Rownald
                          • 10. Re: Bursting NoSuchElement  and ZIP errors
                            Jay K
                            Hello ,

                            Even i get the same error. Any updates/suggestions on the work around?

                            Thanks,
                            Jay
                            • 11. Re: Bursting NoSuchElement  and ZIP errors
                              774864
                              Hi

                              Is there any solution for this error. Even I'm facing the same problem

                              Thanks
                              • 12. Re: Bursting NoSuchElement  and ZIP errors
                                Martin Fritz - Oracle-Oracle
                                The fix is included in the following files:

                                11i: JCP4XDOBurstingEngine.java 115.5 or higher
                                R12: JCP4XDOBurstingEngine.java 120.0.12000000.6 or higher


                                For release 11i :
                                apply Patch 8594771: BURSTING DOES NOT SUPPORT ESCAPE CHARACTERS LIKE "FIRST LAST <XXX@YYY.ZZ>"

                                For release 12.0 :
                                apply Patch 8594771:R12.XDO.A : BURSTING DOES NOT SUPPORT ESCAPE CHARACTERS LIKE "FIRST LAST <XXX@YYY.ZZ>"