2 Replies Latest reply on Sep 4, 2013 4:35 PM by RahulB

    App Engine XMLP Report with PeopleTools 8.5

      Hi All,

      I have an issue with creating an XMLP report in App Engine using PeopleTools 8.5 / PSFT HCM 9.1. As Rowsets, XMLDoc objects are now depreciated as a datasource, I am using XML File as the datasource type.

      In my code, I create an XMLDoc object populate an XML file I put on the app server to be used as the datasource. I have taken this XML file output and loaded it into the template builder within Word without any problem, so by that I trust that the XML is well-formed. I have also created the appropriate datasource, report definition for the report within the PIA.

      My problem comes up when I try to run the report through System Process Requests. I run it as an XML Publisher process type and it gives me the following output. The error makes it appear like my XML is not formed correctly, but if that was the case, would it load into the template builder? If anyone can provide any insight into this problem, would be greatly appreciated. Below is snippets.

      XML output file I use for the datasource:
      <?xml version="1.0"?>
      Stdout file:
      [081710_155732658][oracle.apps.xdo.common.xml.XSLT10gR1][UNEXPECTED] <Line 1, Column 1>: XML-20108: (Fatal Error) Start of root element expected.
      [081710_155732659][oracle.apps.xdo.template.FOProcessor][EXCEPTION] java.lang.reflect.InvocationTargetException
              at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
              at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
              at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
              at java.lang.reflect.Method.invoke(Unknown Source)
              at oracle.apps.xdo.common.xml.XSLT10gR1.invokeParse(Unknown Source)
              at oracle.apps.xdo.common.xml.XSLT10gR1.transform(Unknown Source)
              at oracle.apps.xdo.common.xml.XSLTWrapper.transform(Unknown Source)
              at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(Unknown Source)
              at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(Unknown Source)
              at oracle.apps.xdo.template.FOProcessor.createFO(Unknown Source)
              at oracle.apps.xdo.template.FOProcessor.generate(Unknown Source)
              at com.peoplesoft.pt.xmlpublisher.PTFOProcessor.generateOutput(PTFOProcessor.java:88)
      Caused by: org.xml.sax.SAXParseException: <Line 1, Column 1>: XML-20108: (Fatal Error) Start of root element expected.
              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.NonValidatingParser.parseRootElement(NonValidatingParser.java:343)
              at oracle.xdo.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:285)
              at oracle.xdo.parser.v2.XMLParser.parse(XMLParser.java:289)
              ... 12 more
      081710_172859989][oracle.apps.xdo.template.FOProcessor][ERROR] End Memory: max=63MB, total=13MB, free=2MB
      Error generating report output:  (235,2309) PSXP_RPTDEFNMANAGER.ReportDefn.OnExecute  Name:ProcessReport  PCPC:59808  Statement:1291
      Called from:TEST83.MAIN.GBL.default.1900-01-01.Gen_Rpt.OnExecute  Statement:193
      Process 5805 ABENDED at Step TEST83.MAIN.Gen_Rpt (PeopleCode) -- RC = 24 (108,524)
      Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s
      PSAESRV completed service request at 17.29.00 2010-08-17
      PeopleTools(8.50.11) AE SQL/PeopleCode Trace - 2010-08-17
      Trace file:
      Line     Time       Elapsed Trace Data...
      -------- --------   ------- ------------->
      161      17.28.59  5487.402000                   PCodeWTL(3/3): xdo.cfg path: D:\Apps\psoft\DEV1NAM\appserv\xdo.cfg
      162      17.28.59     0.008000           PCodeWTL(3/3): Using Output Directory:D:\apps\psoft\DEV1NAM\appserv\prcs\DEV1NAM\files\XMLP\73148205-aa46-11df-8375-a29d367ea3a0\RptInst
      163      17.28.59     0.000000           PCodeWTL(3/3): XML Publisher ProcessReport Job Start: 2010-08-17-
      164      17.28.59     0.000000           PCodeWTL(3/3): Report Definition Name: TEST83
      165      17.28.59     0.000000           PCodeWTL(3/3): Template ID: 
      166      17.28.59     0.000000           PCodeWTL(3/3): Language CD: ENG
      167      17.28.59     0.000000           PCodeWTL(3/3): As of date: 2010-08-17
      168      17.28.59     0.000000           PCodeWTL(3/3): Output format: PDF
      169      17.28.59     0.000000           PCodeWTL(3/3): Actual output format: 2
      170      17.28.59     0.006000           PCodeWTL(3/3): Actual template ID: TEST83_1
      171      17.28.59     0.000000           PCodeWTL(3/3): Actual template date: 2010-08-11
      172      17.28.59     0.001000           PCodeWTL(3/3): Actual Language Code: ENG
      173      17.28.59     0.001000               PCodeWTL(3/3): TMPLFILE: D:\apps\psoft\DEV1NAM\appserv\prcs\DEV1NAM\files\XMLP\73148205-aa46-11df-8375-a29d367ea3a0\TEST83_1.xsl
      174      17.28.59     0.000000               PCodeWTL(3/3): RTFFILE: D:\apps\psoft\DEV1NAM\appserv\prcs\DEV1NAM\files\XMLP\73148205-aa46-11df-8375-a29d367ea3a0\TEST83.rtf
      175      17.28.59     0.014000           PCodeWTL(3/3): XSL template: D:\apps\psoft\DEV1NAM\appserv\prcs\DEV1NAM\files\XMLP\73148205-aa46-11df-8375-a29d367ea3a0\TEST83_1.xsl
      176      17.28.59     0.000000           PCodeWTL(3/3): Xliff File: 
      177      17.28.59     0.008000                   PCodeWTL(1/3): xmlpublisher PTFOProcessor.generateOutput error.  XSL file:D:\apps\psoft\DEV1NAM\appserv\prcs\DEV1NAM\files\XMLP\73148205-aa46-11df-8375-a29d367ea3a0\TEST83_1.xsl  Data file:D:\Temp\xmlOut.xml  Xliff file:  Output file:D:\apps\psoft\DEV1NAM\appserv\prcs\DEV1NAM\files\XMLP\73148205-aa46-11df-8375-a29d367ea3a0\RptInst\TEST83.pdf  Format:2
      If anyone could provide any help, would be greatly appreciated. Thanks!

        • 1. Re: App Engine XMLP Report with PeopleTools 8.5



          I'm facing EXACTLY the same issue as you have posted above.

          The issue is at the statement (in PeopleCode) : &ReportDef.ProcessReport(&sTemplateId, %Language_User, %Date, &sOutputFormat);


          And the trace is exactly the same as you have posted above. Were you able to resolve this issue?

          Any help would be appreciated!




          Saad Umair

          • 2. Re: App Engine XMLP Report with PeopleTools 8.5

            Hi Jared,


            I have a question. Probably you answered it already but i was not able to understand.

            Are you able to preview through the the template builder on your local machine using the same XML?


            Also, can you please paste the peoplecode you used to generate the XMLP report.