14 Replies Latest reply on Feb 7, 2011 2:09 PM by Nicolas Gasparotto

    PSUNX failed to post files to the report repository

    Nitin Joshi
      Dear All,
      i've just faced this issue. Before submitting here, this i've tried various things posted on web but not getting the solution,So posting here.
      If someone might have an idea about this...

      These are my settings

      Report Node Definition URL
      http://irshr.irs.co.id:8000/psreports/irshr

      URI Host: irshr.irs.co.id
      URI Resource:SchedulerTransfer/irshr

      Peoplesoft ligin URL :http://irshr.irs.co.id:8000/psp/irshr/EMPLOYEE/HRMS......

      and the error
           
      
             11:18:07AM      Request is reassigned from server PSNT to server PSUNX      
      10      11:18:19AM      Process request completed successfully.      
      10      11:18:33AM      Java Exception: Error while wr ite to file:java.lang.StringIn dexOutOfBoundsException: Strin g index out of range: -1  (63, 49)      
      10      11:18:33AM      SchedulerTransfer Servlet error.      
             11:18:33AM      PSUNX failed to post files to the report repository.  Server scheduled to try again on 2011-02-07-11.18.47.999881.  See log      
      10      11:18:48AM      Java Exception: Error while wr ite to file:java.lang.StringIn dexOutOfBoundsException: Strin g index out of range: -1  (63, 49)      
      10      11:18:48AM      SchedulerTransfer Servlet error.      
             11:18:48AM      PSUNX failed to post files to the report repository.  Server scheduled to try again on 2011-02-07-11.19.02.999526.  See log      
      10      11:19:03AM      Java Exception: Error while wr ite to file:java.lang.StringIn dexOutOfBoundsException: Strin g index out of range: -1  (63, 49)      
      10      11:19:03AM      SchedulerTransfer Servlet error.      
             11:19:03AM      HTTP transfer error.
      Also have the role "process sheduler admin" assigned to PS.

      Standard reports of Peoplsoft are running well but this is a customised SQR report that is giving error.

      -Regards
        • 1. Re: PSUNX failed to post files to the report repository
          617869
          What's your report repository location (in web profile or configuration.properties)? Is it too long?
          • 2. Re: PSUNX failed to post files to the report repository
            Nitin Joshi
            Thanks for the reply.
            I'm very much new to Peoplesft , PeopleTool & SQR.
            can you please tell me where i can find the location your asking in peopleSoft?

            -Regards
            • 3. Re: PSUNX failed to post files to the report repository
              Nitin Joshi
              The location on Report Repository Path is blank.
              but we've dev. environment there also we've location blank. but my reports runs there without any error.

              -Regards
              • 4. Re: PSUNX failed to post files to the report repository
                Michel
                The report repository path can be set either in the configuration.properties file or on the webprofile. You can find the webprofile online in PeopleSoft under PeopleTools > Webprofile > Webprofile configuration. Enter the name of the webprofile you're using and then you'll see a field where the report repository path can be set. You'll probably find the path here.
                • 5. Re: PSUNX failed to post files to the report repository
                  Nicolas Gasparotto
                  What's your Peopletools version and patch level ?
                  Are you able to ping the local node ? How is it defined in the Gateway ?

                  Nicolas.
                  • 6. Re: PSUNX failed to post files to the report repository
                    Nitin Joshi
                    Thanks Michel.I just posted that.
                    Nicolos,
                    PeopleTool is 8.49.27 & PeoplSoft HR9.0
                    Yes, i can ping it from my machine/laptop.
                    I didn't get understand about your gateway question(Lacking n/w knowledge).

                    -Regards
                    • 7. Re: PSUNX failed to post files to the report repository
                      Nicolas Gasparotto
                      What's your server's OS ? The node I was talking about is the Peoplesoft local node. The gateway is about Integration Broker configuration.
                      Just a question aside, has it ever worked before ?
                      According to the error you have, you may want to raise a SR.

                      Nicolas.
                      • 8. Re: PSUNX failed to post files to the report repository
                        Nicolas Gasparotto
                        Standard reports of Peoplsoft are running well but this is a customised SQR report that is giving error.
                        I missed that part... what about the name of customized SQR ? Does it contain any special charachters and/or blanks ?

                        Nicolas.
                        • 9. Re: PSUNX failed to post files to the report repository
                          Nitin Joshi
                          Thanks Nicolos.
                          Name of the SQR is irsempcn.sqr no blank spaces..8 characters long..
                          and this is log of the report...
                          PeopleTools 8 - PSSQR
                          Copyright (c) 1988-2007  PeopleSoft, Inc.
                          All Rights Reserved
                          
                          Database Type:                Oracle
                          Database Name:                IRSHR
                          Report Name:                  IRSEMPCN
                          Process Instance:             967
                          Run Control ID:               2
                          Language Code:                ENG
                          Output Destination Type:      WEB
                          Output Destination Format:    CSV
                          Output Destination:           /data10/psft/hr90/appserv/prcs/IRSHR/log_output/SQR_IRSEMPCN_967
                          Output Directory (SQOT):      /data10/psft/hr90/appserv/prcs/IRSHR/log_output/SQR_IRSEMPCN_967
                          Log Directory (SQLG):         /data10/psft/hr90/appserv/prcs/IRSHR/log_output/SQR_IRSEMPCN_967
                          SQR Flags:                    -ZIF/data10/psft/hr90/sqr/pssqrENG.unx
                          Log File (SQLF):              /data10/psft/hr90/appserv/prcs/IRSHR/log_output/SQR_IRSEMPCN_967/irsempcn_967.out
                          Include File (SQIN):          /data10/psft/hr90/appserv/prcs/IRSHR/log_output/SQR_IRSEMPCN_967/,/data10/psft/hr90/user/sqr/,/data10/psft/hr90/sqr/,/,/
                          File (FILE_1):                /data10/psft/hr90/appserv/prcs/IRSHR/log_output/SQR_IRSEMPCN_967/irsempcn_967.CSV
                          
                          SQR Command = /data10/psft/hr90/bin/sqr/ORA/bin/sqr /data10/psft/hr90/sqr/irsempcn.sqr */*@IRSHR   -o/data10/psft/hr90/appserv/prcs/IRSHR/log_output/SQR_IRSEMPCN_967/irsempcn_967.out -xb -xi  -i/data10/psft/hr90/appserv/prcs/IRSHR/log_output/SQR_IRSEMPCN_967/,/data10/psft/hr90/user/sqr/,/data10/psft/hr90/sqr/,/,/  -zif/data10/psft/hr90/sqr/pssqr.unx  "-f/data10/psft/hr90/appserv/prcs/IRSHR/log_output/SQR_IRSEMPCN_967/irsempcn_967.CSV" -PRINTER:EH -PRINTER:EH -eh_csvonly    IRSHR 967 PS 2 
                          -Regards
                          • 10. Re: PSUNX failed to post files to the report repository
                            Michel
                            I'm noticing something weird in the log. The SQR Flag which is first displayed sets -ZIF/data10/psft/hr90/sqr/pssqrENG.unx. The SQR command on the other hand sets -zif/data10/psft/hr90/sqr/pssqr.unx.

                            Are you sure you included the correct files in you SQR?
                            • 11. Re: PSUNX failed to post files to the report repository
                              Nitin Joshi
                              Michel,
                              This is the SQR code.(My first SQR report) :-)
                              !***********************************************************************
                              ! IRSEMPCN.sqr: Employee Report                                 *
                              !***********************************************************************
                              !                                                                      *
                              !  Description:  Employee Report  
                              !                                                                      *
                              !***********************************************************************
                              !                                                                      *
                              !               Confidentiality Information:                           *
                              !                                                                      *
                              ! This module contains confidential and proprietary information        *
                              ! of Oracle; it is not to be copied, reproduced, or transmitted        *
                              ! in any form, by any means, in whole or in part, nor is it to         *
                              ! be used for any purpose other than that for which it is              *
                              ! expressly provided under the applicable license agreement.           *
                              !                                                                      *
                              ! Copyright (C) 2007 Oracle. All Rights Reserved.                      *
                              !                                                                      *
                              !***********************************************************************
                              !       Creator     : ****                                    *
                              !       Date       : 29 Juni 2010                                      *          
                              !***********************************************************************
                              
                              #Include 'setenv.sqc'    !Set environment
                              #Include 'datetime.sqc'  !Routines for date and time formatting
                              #Include 'number.sqc'    !Routines to format numbers
                              #Include 'stdapi.sqc'  
                              #Include 'datetime.sqc'  !Routines for date and time formatting
                              #Include 'datemath.sqc'  !Routines for date arithmetic
                              #Include 'number.sqc'    !Routines to format numbers   
                              
                              begin-report
                                do Init-DateTime
                                do Init-Number
                                do Get-Current-DateTime
                                do Init-Report
                              !  do Reset
                                do Stdapi-Term
                              end-report
                              
                              begin-setup
                              declare-variable
                                  text      $BU
                              !    text1     $plant
                              !    text2         $empid
                              end-declare
                              end-setup
                              
                              
                              !**************************************************************************
                              ! Procedure: Init-Report
                              ! Description: Initialise header and run control variables.
                              !**************************************************************************
                              begin-procedure Init-Report
                              
                                move 'IRSEM1' to $ReportID
                                move 'IRS Employee' to $ReportTitle
                                do Stdapi-Init
                              
                                if $prcs_process_instance = ''
                                else
                                   do Select-Parameters
                                end-if
                                
                                do Report
                              
                              end-procedure
                              
                              
                              !**************************************************************************
                              ! Procedure: Select-Parameters
                              ! Description : Select the parameter values from the run control page
                              !**************************************************************************
                              begin-procedure Select-Parameters
                              
                              begin-select
                              PARA.IRS_BU
                                
                                let $BU    = &PARA.IRS_BU
                              !  let $plant = &PARA.IRS_DEPT
                              
                                 
                              FROM PS_PRCSRUNCNTL_EMP PARA
                              WHERE PARA.OPRID       = $prcs_oprid
                              AND   PARA.RUN_CNTL_ID = $prcs_run_cntl_id
                              end-select
                              
                              do Get-OPRCLASS ($prcs_oprid,$oprclass)
                              do Get-SetId($oprclass, $setid)
                              !do Process-Get-Employee-Details($emplid)
                              end-procedure
                              
                              
                              !**********************************************************************!
                              ! Procedure: Get-OPRCLASS                                              !
                              ! Descr:     Get operator class                                        !
                              !**********************************************************************!
                              BEGIN-PROCEDURE Get-OPRCLASS ($PRCS_OPRID, :$oprclass)
                              LET $OPRCLASS =''
                              
                              BEGIN-SELECT 
                              OPRCLASS    &OPRCLASS
                              
                                 move  &OPRCLASS   to $oprclass
                                 
                              FROM PSOPRDEFN
                              WHERE OPRID = $PRCS_OPRID   
                              
                              END-SELECT
                              
                              END-PROCEDURE Get-OPRCLASS
                              
                              
                              !**********************************************************************!
                              ! Procedure: Get-SetId                                                 !
                              ! Descr:     Get Set ID                                                !
                              !**********************************************************************!
                              BEGIN-PROCEDURE Get-SetId($OPRCLASS, :$setid)
                              
                              
                              LET $setid =''
                              
                              BEGIN-SELECT 
                              
                              SETID    &SETID
                              
                                 move  &SETID   to $setid
                                 
                              FROM PS_OPR_DEF_TBL_HR
                              WHERE OPRCLASS = $OPRCLASS   
                              
                              END-SELECT
                              
                              END-PROCEDURE Get-SetId
                              
                              !**************************************************************************
                              ! Procedure: Report
                              ! Description:
                              !**************************************************************************
                              begin-procedure Report
                                  !let $FileName = 'E:\psft\psdmo\sqr\' || 'IRSEM1' || to_char(#prcs_process_instance) || '.csv'
                                  let $FileName = '{FILEPREFIX}' || '\IRSEM1' || '.csv'
                                  open $FileName as 1 for-writing record=20000:VARY
                              
                                  write 1 from 'Business Unit,Department,Grade,Count'
                              
                                  do Process-Get-Employee-Details($BU)
                                
                                  close 1   
                              
                              end-procedure
                              
                              
                              
                              !**************************************************************************
                              ! Procedure: Process-Get-Employee-Name
                              ! Description: Get Employee Name
                              !**************************************************************************
                              begin-procedure Process-Get-Employee-Details($BU)
                              begin-select
                              
                              PS_BUSUNIT_HR_VW.DESCR        &BUSINESSUNIT ,
                              PS_DEPT_TBL.DESCR             &DEPARTMENT ,
                              PS_JOBCODE_TBL.DESCR          &GRADE ,
                              COUNT(PS_JOBCODE_TBL.DESCR)   &COUNT
                               
                                 move &BUSINESSUNIT  to  $BUSINESSUNIT
                                 move &DEPARTMENT    to  $DEPARTMENT
                                 move &GRADE         to  $GRADE
                                 move &COUNT         to  $COUNT 
                                 
                                 write 1 from $BUSINESSUNIT ',' $DEPARTMENT ',' $GRADE ',' $COUNT 
                                 
                              From PS_JOB,PS_JOBCODE_TBL,PS_BUSUNIT_HR_VW,PS_DEPT_TBL
                              Where PS_JOB.Jobcode=PS_JOBCODE_TBL.Jobcode
                              and PS_JOB.BUSINESS_UNIT=PS_BUSUNIT_HR_VW.BUSINESS_UNIT
                              AND PS_JOB.DEPTID=PS_DEPT_TBL.DEPTID
                              AND PS_DEPT_TBL.EFF_STATUS='A'
                              And Rownum<5
                              Group by PS_BUSUNIT_HR_VW.DESCR,PS_DEPT_TBL.DESCR,PS_JOBCODE_TBL.DESCR
                              Order by  PS_BUSUNIT_HR_VW.DESCR 
                              
                              end-select
                              end-procedure           
                                                     
                              • 12. Re: PSUNX failed to post files to the report repository
                                Michel
                                There's an error in this section:

                                begin-procedure Report
                                +!let $FileName = 'E:\psft\psdmo\sqr\' || 'IRSEM1' || to_char(#prcs_process_instance) || '.csv'+
                                +let $FileName = '{FILEPREFIX}' || '\IRSEM1' || '.csv'+
                                open $FileName as 1 for-writing record=20000:VARY

                                write 1 from 'Business Unit,Department,Grade,Count'

                                do Process-Get-Employee-Details($BU)

                                close 1

                                end-procedure

                                I'm not an SQR expert, but the filename can't contain slashes. You should create a variable for the output location and for the filename. That way you can control where the file has to be written to. Try setting the filename like this:

                                let $FileName = 'IRSEM1.csv'
                                • 13. Re: PSUNX failed to post files to the report repository
                                  Nitin Joshi
                                  Great!!!
                                  Thanks a ton Michel. It has worked. But i'm not sure how is it working in Dev?
                                  I've just copied that file(SQR) from Dev to Prod and changed the SQL. Need to see again.

                                  Thanks All for their valuable time & help.

                                  Regards.
                                  • 14. Re: PSUNX failed to post files to the report repository
                                    Nicolas Gasparotto
                                    Slash/backslash... is it possible your working DEV prcs is on NT and the not working one on *nix ?

                                    Nicolas.