4 Replies Latest reply on Apr 29, 2011 7:01 AM by 763506

    XML PUBLISHER/XDO ERROR  - Output file was found but is zero sized - Delete

    Peter Lowe-Oracle
      Hi XML/XDO experts,

      I am running a XLM publisher report in an internal 12.1 env (mz1dv213) and have this warning when running.

      Beginning post-processing of request 40256141 on node RWS60183REMS at
      23-JUL-2010 09:34:48.
      Post-processing of request 40256141 failed at 23-JUL-2010 09:34:54 with the
      error message:
      One or more post-processing actions failed. Consult the OPP service log for
      details.
      +--------------------------
      .
      .
      OPP log shows

      [072310_010929110][][EXCEPTION] [DEBUG] [sun.cpu.isalist]:[]
      [7/23/10 1:09:31 PM] [1925014:RT40257178] Output file was found but is zero sized - Deleted
      [7/23/10 1:09:31 PM] [UNEXPECTED] [1925014:RT40257178]
      java.lang.reflect.InvocationTargetException

      I also have the same issue at a Customer site (bug is escalated)

      Please advise
        • 1. Re: XML PUBLISHER/XDO ERROR  - Output file was found but is zero sized - Delete
          790312
          I would check the OPP log. Also, I would turn on the debug log to get more details.
          • 2. Re: XML PUBLISHER/XDO ERROR  - Output file was found but is zero sized - Delete
            839084
            Did you have any solution for this prpblema? I have a similar problem in a Report for EBS 12.1.3.

            [2/11/11 3:31:11 PM] [31329:RT475403] Completed post-processing actions for request 475403.
            [2/11/11 3:39:18 PM] [OPPServiceThread0] Post-processing request 475407.
            [2/11/11 3:39:18 PM] [31329:RT475407] Executing post-processing actions for request 475407.
            [2/11/11 3:39:18 PM] [31329:RT475407] Starting XML Publisher post-processing action.
            [2/11/11 3:39:18 PM] [31329:RT475407]
            Template code: XLAJERST
            Template app: XLA
            Language: en
            Territory: US
            Output type: RTF
            [2/11/11 3:39:18 PM] [31329:RT475407] Output file was found but is zero sized - Deleted
            [2/11/11 3:39:19 PM] [UNEXPECTED] [31329:RT475407] 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.apps.xdo.common.xml.XSLT10gR1.invokeParse(XSLT10gR1.java:570)
                 at oracle.apps.xdo.common.xml.XSLT10gR1.transform(XSLT10gR1.java:235)
                 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:5936)
                 at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3459)
                 at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3548)
                 at oracle.apps.fnd.cp.opp.XMLPublisherProcessor.process(XMLPublisherProcessor.java:302)
                 at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:176)
            Caused by: org.xml.sax.SAXParseException: <Line 6, Column 1>: 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)
                 ... 17 more

            [2/11/11 3:39:19 PM] [31329:RT475407] Completed post-processing actions for request 475407.
            • 3. Re: XML PUBLISHER/XDO ERROR  - Output file was found but is zero sized - Delete
              763506
              I'm having the same problem.

              I'm getting this error in R12.1.3. Does anyone have solution for this?

              I tried the solution given in the link - "http://forums.oracle.com/forums/thread.jspa?messageID=9552336&#9552336", but it didn't work for me.

              Thanks in advance.

              Thanks,
              Satish

              ----------LOG FILE-------------
              ---------------------------------------------------------------------------
              GF AP Custom Application: Version : 12.0.0

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

              XXGFAPBAAT_XML module: GF AP Bank Account Audit Trail Report
              ---------------------------------------------------------------------------

              Current system time is 28-APR-2011 22:47:23

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

              XDO Data Engine Version No: 5.6.3
              Resp: 50863
              Org ID : 81
              Request ID: 1427740
              All Parameters: P_CREATION_DATE_FR=:P_CREATION_DATE_TO=:P_CREATED_BY=
              Data Template Code: XXGFAPBAAT_XML
              Data Template Application Short Name: XXAP
              Debug Flag: N
              {P_CREATED_BY=, P_CREATION_DATE_TO=, P_CREATION_DATE_FR=}
              Calling XDO Data Engine...
              [042811_104733608][][STATEMENT] Start process Data
              [042811_104733751][][STATEMENT] Process Data ...
              [042811_104733752][][STATEMENT] Executing data triggers...
              [042811_104733752][][STATEMENT] BEGIN
              XXGF_AP_BAAT_XML_PKG.P_CONC_REQUEST_ID := :P_CONC_REQUEST_ID ;
              XXGF_AP_BAAT_XML_PKG.P_CREATION_DATE_FR := :P_CREATION_DATE_FR ;
              XXGF_AP_BAAT_XML_PKG.P_CREATION_DATE_TO := :P_CREATION_DATE_TO ;
              XXGF_AP_BAAT_XML_PKG.P_CREATED_BY := :P_CREATED_BY ;

              :XDO_OUT_PARAMETER := 1;
              END;

              [042811_104733752][][STATEMENT] 1:0 :
              [042811_104733752][][STATEMENT] 2: :
              [042811_104733753][][STATEMENT] 3: :
              [042811_104733753][][STATEMENT] 4: :
              [042811_104733763][][STATEMENT] Executing data triggers...
              [042811_104733763][][STATEMENT] Declare
              l_flag Boolean;
              BEGIN
              l_flag := XXGF_AP_BAAT_XML_PKG.BeforeReport() ;
              if (l_flag) then
              :XDO_OUT_PARAMETER := 1;
              end if;
              end;

              [042811_104733771][][STATEMENT] P_CONC_REQUEST_ID
              [042811_104733771][][STATEMENT] P_CREATION_DATE_FR
              [042811_104733771][][STATEMENT] P_CREATION_DATE_TO
              [042811_104733771][][STATEMENT] P_CREATED_BY
              [042811_104733771][][STATEMENT] Writing Data ...
              [042811_104733780][][STATEMENT] &srwhereclause
              [042811_104733795][][STATEMENT] &srwhereclause1
              [042811_104733797][][STATEMENT] Sql Query :Q_AUDIT_TRIAL: SELECT DECODE(abaaa.audit_transaction_type,
              'I','INSERTION',
              'U','UPDATE',
              'D','DELETION',
              NULL) activity,
              SUBSTR(abb.bank_name,1,24) bank_name,
              -- SUBSTR(abb.bank_number,1,25) bank_number, -- Commented by Bugoy 18-SEP-2003
              SUBSTR(abb.bank_branch_name,1,20) branch_name,
              SUBSTR(abb.bank_num,1,15) branch_number,
              SUBSTR(abaaa.bank_account_name,1,30) old_bank_account_name,
              SUBSTR(abaaa.bank_account_num,1,25) old_bank_account_number,
              -- SUBSTR(abaa.bank_account_name,1,30) new_bank_account_name, -- Commented by Bugoy 18-SEP-2003
              SUBSTR(abaa.bank_account_name,1,50) new_bank_account_name, -- Added by Bugoy 18-SEP-2003
              SUBSTR(abaa.bank_account_num,1,25) new_bank_account_number,
              SUBSTR(abaaa.audit_user_name,1,15) created_by,
              TO_CHAR(abaaa.audit_timestamp,
              'DD-MON-YYYY HH:MI:SS AM') creation_date
              FROM ap_bank_branches abb,
              xxgf_ap_bank_accounts_all_a abaaa,
              ap_bank_accounts_all abaa
              WHERE abaaa.bank_account_id = abaa.bank_account_id
              AND abaa.bank_branch_id = abb.bank_branch_id
              -- AND TRUNC(abaaa.audit_timestamp) BETWEEN to_date(:P_CREATION_DATE_FR,) AND :P_CREATION_DATE_TO
              -- AND abaaa.audit_user_name = NVL(:P_CREATED_BY,abaaa.audit_user_name) -- Added By Bugoy 04-SEP-2003
              AND abaa.set_of_books_id = FND_PROFILE.VALUE('GL_SET_OF_BKS_ID') -- Added By Bugoy 16-DEC-2003
              AND abaa.org_id = FND_PROFILE.VALUE('ORG_ID') -- Added By Adi 12-JUL-2010 PSR-10-4725
              and 1=1
              and 1=1
              ORDER BY SUBSTR(abaa.bank_account_name,1,50);
              --SQLException
              java.sql.SQLSyntaxErrorException: ORA-00911: invalid character

              at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
              at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
              at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
              at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
              at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
              at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
              at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)
              at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:861)
              at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1145)
              at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1267)
              at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
              at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493)
              at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
              at oracle.apps.xdo.dataengine.XMLPGEN.processQuery(XMLPGEN.java:1947)
              at oracle.apps.xdo.dataengine.XMLPGEN.processSQLDataSource(XMLPGEN.java:501)
              at oracle.apps.xdo.dataengine.XMLPGEN.writeData(XMLPGEN.java:445)
              at oracle.apps.xdo.dataengine.XMLPGEN.writeGroupStructure(XMLPGEN.java:308)
              at oracle.apps.xdo.dataengine.XMLPGEN.processData(XMLPGEN.java:273)
              at oracle.apps.xdo.dataengine.XMLPGEN.processXML(XMLPGEN.java:215)
              at oracle.apps.xdo.dataengine.XMLPGEN.writeXML(XMLPGEN.java:254)
              at oracle.apps.xdo.dataengine.DataProcessor.processDataStructre(DataProcessor.java:390)
              at oracle.apps.xdo.dataengine.DataProcessor.processData(DataProcessor.java:355)
              at oracle.apps.xdo.oa.util.DataTemplate.processData(DataTemplate.java:334)
              at oracle.apps.xdo.oa.cp.JCP4XDODataEngine.runProgram(JCP4XDODataEngine.java:294)
              at oracle.apps.fnd.cp.request.Run.main(Run.java:157)

              ---------------------------------------------------------------------------
              Start of log messages from FND_FILE
              ---------------------------------------------------------------------------
              P_CREATION_DATE_FR:
              P_CREATION_DATE_TO:
              P_CREATED_BY:
              srwwhereclause 1=1
              srwwhereclause1 1=1
              ---------------------------------------------------------------------------
              End of log messages from FND_FILE
              ---------------------------------------------------------------------------

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

              Output file size:
              230

              ------------- 1) PUBLISH -------------
              Beginning post-processing of request 1427740 on node SGPERPVMEBSDB1 at 28-APR-2011 22:47:34.
              Post-processing of request 1427740 failed at 28-APR-2011 22:47:35 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 28-APR-2011 22:47:36

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

              ---------------------CONCURRENT MANAGER LOG--------------------------
              [4/28/11 10:47:35 PM] [OPPServiceThread1] Post-processing request 1427740.
              [4/28/11 10:47:35 PM] [96895:RT1427740] Executing post-processing actions for request 1427740.
              [4/28/11 10:47:35 PM] [96895:RT1427740] Starting XML Publisher post-processing action.
              [4/28/11 10:47:35 PM] [96895:RT1427740]
              Template code: XXGFAPBAAT_XML
              Template app: XXAP
              Language: en
              Territory: 00
              Output type: null
              [4/28/11 10:47:35 PM] [96895:RT1427740] Output file was found but is zero sized - Deleted
              [4/28/11 10:47:35 PM] [UNEXPECTED] [96895:RT1427740] java.lang.reflect.InvocationTargetException
              at sun.reflect.GeneratedMethodAccessor271.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:570)
              at oracle.apps.xdo.common.xml.XSLT10gR1.transform(XSLT10gR1.java:235)
              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:5936)
              at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3459)
              at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3548)
              at oracle.apps.fnd.cp.opp.XMLPublisherProcessor.process(XMLPublisherProcessor.java:302)
              at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:176)
              Caused by: org.xml.sax.SAXParseException: <Line 6, Column 1>: 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

              [4/28/11 10:47:35 PM] [96895:RT1427740] Completed post-processing actions for request 1427740.

              Edited by: user6665827 on Apr 28, 2011 10:56 PM
              • 4. Re: XML PUBLISHER/XDO ERROR  - Output file was found but is zero sized - Delete
                763506
                Got the solution. There was semicolon in the CDATA sqlquery.