Wednesday, August 12, 2015

Error! SQR Failed To Process

Users ran custom SQR process from windows PSNT scheduler and it is going ERROR and POSTED.

Error from Message Log:
********************
Process Request shows status of 'INITIATED' or 'PROCESSING' but no longer running

Error from View Log Trace File:
*************************
PeopleTools 8 - PSSQR
Copyright (c) 1988-2007 PeopleSoft, Inc.
All Rights Reserved

Database Type: Oracle
Database Name: FSDEV10
Report Name: XRFWIN
Process Instance: 3457710
Run Control ID: 1
Language Code: ENG
Output Destination Type: WEB
Output Destination Format: PDF
Output Destination: E:\peoplesoft\fsdev\appserv\prcs\FSDEV10\log_output\SQR_XRFWIN_3457710
Output Directory (SQOT): E:\peoplesoft\fsdev\appserv\prcs\FSDEV10\log_output\SQR_XRFWIN_3457710
Log Directory (SQLG): E:\peoplesoft\fsdev\appserv\prcs\FSDEV10\log_output\SQR_XRFWIN_3457710
SQR Flags: -ZIFE:\peoplesoft\fsdev\SQR\PSSQRENG.INI
Log File (SQLF): E:\peoplesoft\fsdev\appserv\prcs\FSDEV10\log_output\SQR_XRFWIN_3457710\XRFWIN_3457710.out
Include File (SQIN): E:\peoplesoft\fsdev\appserv\prcs\FSDEV10\log_output\SQR_XRFWIN_3457710\;E:\peoplesoft\fsdev\uesqr\;E:\peoplesoft\fsdev\sqr\;\;\
File (FILE_1): E:\peoplesoft\fsdev\appserv\prcs\FSDEV10\log_output\SQR_XRFWIN_3457710\XRFWIN_3457710.PDF

SQR Command = E:\PeopleSoft\fsdev\bin\sqr\ORA\BINW\sqrw E:\peoplesoft\fsdev\sqr\XRFWIN.sqr */*@FSDEV10 -oE:\peoplesoft\fsdev\appserv\prcs\FSDEV10\log_output\SQR_XRFWIN_3457710\XRFWIN_3457710.out -xmb -xcb -xi -iE:\peoplesoft\fsdev\appserv\prcs\FSDEV10\log_output\SQR_XRFWIN_3457710\;E:\peoplesoft\fsdev\uesqr\;E:\peoplesoft\fsdev\sqr\;\;\ -zifE:\peoplesoft\fsdev\SQR\PSSQR.INI "-fE:\peoplesoft\fsdev\appserv\prcs\FSDEV10\log_output\SQR_XRFWIN_3457710\XRFWIN_3457710.PDF" -PRINTER:PD FSDEV10 3457710 VP1 1
Error! SQR Failed To Process



                      --  Started validating the issue by running sample SQR process from PSNT process scheduler and issue persist by going to ERROR and POSTED.
                      -- Tried running Sample process ran from PSUNX process scheduler and it went to SUCCESS and POSTED.

Solution: 
        1. Stop the process scheduler on PSNT scheduler.
        2. Clear the Cache.
        3. Re-boot the Windows server on which Process scheduler is running.
        4. Start the process scheduler on PSNT scheduler.
        5. Ran sample SQR process and it went to SUCCESS and POSTED.




No comments :

Post a Comment