4 Replies Latest reply on Dec 26, 2017 9:28 PM by ManiS

    BI Publisher Reports error out in PIA, but works in Desktop

    3592008

      Hi,

       

      We are on PeopleTools 8.55 and I am running a Connected Query based BIP report in PeopleSoft.

      I am using RTF template and out in XL format.

       

      I am running the BIP report through Query Report Scheduler. I am getting the below error.

      I was able to run connected query and generate the XML. I uploaded the XML to RTF. If I preview the out put, I did not get any error. IF run the report thru PS Process Scheduler, I am getting the below error.

       

      Please advice.

       

      Error generating report output: (235,2309) PSXP_RPTDEFNMANAGER.ReportDefn.OnExecute Name:ProcessReport PCPC:82440 Statement:1648

       

      Called from:PSXPQRYRPT.MAIN.GBL.default.1900-01-01.ExecRpt.OnExecute Name:ExecXmlpQryReport Statement:47

       

      Called from:PSXPQRYRPT.MAIN.GBL.default.1900-01-01.ExecRpt.OnExecute Statement:85

       

      Process 633778 ABENDED at Step PSXPQRYRPT.MAIN.ExecRpt (PeopleCode) -- RC = 20 (108,524)

       

      Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s

       

      PSAESRV completed service request at 13.21.19 2017-12-20

       

      Thanks,

      Laksman

        • 1. Re: BI Publisher Reports error out in PIA, but works in Desktop
          ManiS

          Hi,

          Can you post your AE code please? Also, does your connected query have any prompt?

          • 2. Re: BI Publisher Reports error out in PIA, but works in Desktop
            3295714

            Yes, Connected query has 2 prompts. I am running the report through the Query Report Scheduler.

            • 3. Re: BI Publisher Reports error out in PIA, but works in Desktop
              3295714

              This is the trace file.

               

               

              Total documents processed : 43 Total rows processed : 715

              54603    11:23:54.577     2.089130                       PCodeWTL(1/3): xmlpublisher PTFOProcessor.generateOutput error.  XSL file:/PS_HOME/appserv/prcs/x/Proc/X_XX_FFFR1NEW_1.xsl

              Data file:/PS_HOMER/appserv/prcs/C/files/CQ/AE_X_CS_2510_03_CQ_633828/X_CS_2510_03_CQ.xml

              Xliff file:  Output file:/PS_HOME/files/XMLP/26749160-ea59-11e7-aca7-bc3287232070/X_XX_FFFR1NEW_1.xsl

              Format:5 XDOException:java.lang.reflect.InvocationTargetException

              54604    11:23:54.582     0.004891           PCodeWTL(1/3): Error generating report output:  (235,2309) PSXP_RPTDEFNMANAGER.ReportDefn.OnExecute  Name:ProcessReport  PCPC:85408  Statement:1690

              Called from:PSXPQRYRPT.MAIN.GBL.default.1900-01-01.ExecRpt.OnExecute  Name:ExecXmlpQryReport  Statement:47

              Called from:PSXPQRYRPT.MAIN.GBL.default.1900-01-01.ExecRpt.OnExecute  Statement:85

               

              Looks like format issue right?

              Same XML file working fine in pre-view mode (on Desktop), error out when run it thru Query Report Scheduler.

              • 4. Re: BI Publisher Reports error out in PIA, but works in Desktop
                ManiS

                Yes, could be a format issue.

                 

                Does your XML have any special characters - I've seen issues where the XML has special characters, and the report cannot be generated unless the XML is encoded in UTF-8 format.

                 

                You can troubleshoot by limiting the number of rows, from your connected query's result.

                 

                Try generating the report with just one row of data - if the issue still persists, then it appears to be a formatting issue.