My Oracle Support Banner

E-SQR: Error " Open Failed: No Such File Or Directory" When Running an SQR (Doc ID 2515434.1)

Last updated on MAY 22, 2023

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.56 and later
Information in this document applies to any platform.


On : 8.56 version, Upgrade

When attempting to run an SQR through the Process Scheduler or command line, the following error occurs.

----------------------- sqr: fatal: open failed: No such file or directory
PeopleTools 8 - PSSQR
Copyright (c) 1988, 2017, Oracle and/or its affiliates.
All Rights Reserved

Database Type: Oracle
Database Name: FSDMO92
Report Name: PTSQRTST
Process Instance: 143038
Run Control ID: 1
Language Code: ENG
Output Destination Type: WEB
Output Destination Format: PDF
Output Destination: /app/psoft/pscfg/FSDMO92/appserv/prcs/FSDMO92/log_output/SQR_PTSQRTST_143038
Output Directory (SQOT): /app/psoft/pscfg/FSDMO92/appserv/prcs/FSDMO92/log_output/SQR_PTSQRTST_143038
Log Directory (SQLG): /app/psoft/pscfg/FSDMO92/appserv/prcs/FSDMO92/log_output/SQR_PTSQRTST_143038
SQR Flags: -ZIF/app/psoft/pt85604/pt/ps_home8.56.04/sqr/pssqrENG.unx
Log File (SQLF): /app/psoft/pscfg/FSDMO92/appserv/prcs/FSDMO92/log_output/SQR_PTSQRTST_143038/ptsqrtst_143038.out
Include File (SQIN): /app/psoft/pscfg/FSDMO92/appserv/prcs/FSDMO92/log_output/SQR_PTSQRTST_143038/,/app/psoft/pscustom/FSDMO92/sqr/,/app/psoft/fscm92/sqr/,/app/psoft/pt85604/pt/ps_home8.56.04/sqr/,
File (FILE_1): /app/psoft/pscfg/FSDMO92/appserv/prcs/FSDMO92/log_output/SQR_PTSQRTST_143038/ptsqrtst_143038.PDF

SQR Command = /app/psoft/pt85604/pt/ps_home8.56.04/bin/sqr/ORA/bin/sqr /app/psoft/pt85604/pt/ps_home8.56.04/sqr/ptsqrtst.sqr */*@FSDMO92 "-o/app/psoft/pscfg/FSDMO92/appserv/prcs/FSDMO92/log_output/SQR_PTSQRTST_143038/ptsqrtst_143038.out" -xb -xi "-i/app/psoft/pscfg/FSDMO92/appserv/prcs/FSDMO92/log_output/SQR_PTSQRTST_143038/,/app/psoft/pscustom/FSDMO92/sqr/,/app/psoft/fscm92/sqr/,/app/psoft/pt85604/pt/ps_home8.56.04/sqr/," -zif/app/psoft/pt85604/pt/ps_home8.56.04/sqr/pssqr.unx "-f/app/psoft/pscfg/FSDMO92/appserv/prcs/FSDMO92/log_output/SQR_PTSQRTST_143038/ptsqrtst_143038.PDF" -PRINTER:PD FSDMO92 143038 VP1 1

Error! SQR Failed To Process

The issue can be reproduced at will with the following steps:
1. Install PT 8.56.
2. Run an SQR via the Process Scheduler or command line.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.