PSSQR problem on HP-UX, PeopleTools 8.16, Oracle 8x

[reclspeak]

Hi!

I'm testing a pssqr routine that is intended to be executed from a Korn shell script (driven my an opsMVS job). However I've run into what looked like a relatively simple environment variable problem, but one I can't solve.

I'm running the test PSSQR routine as this;


pssqr -CT ORACLE -CS PSUNX -CD T00EM10D -CA <an Oracle account> -CAP <the Oracle account password> -RP /apps/psoft/pf816m/sqr/tmm-mod/tmpf013.sqr -I 2785 -R UK_PNV_CONV -CO INFOPUMP -OT
6 -OP /logs/ps/tmem/prcs_logs/t00em10d/SQR_TMPF013_2785 -OF 2


PeopleTools 8 - PSSQR
Copyright (c) 1988-2001 PeopleSoft, Inc.
All Rights Reserved

Database Type: Oracle
Database Name: T00EM10D
Report Name: /apps/psoft/pf816m/sqr/tmm-mod/tmpf013.sqr
Process Instance: 2785
Run Control ID: UK_PNV_CONV
Output Destination Type: WEB
Output Destination Format: PDF
Output Destination: /logs/ps/tmem/prcs_logs/t00em10d/SQR_TMPF013_85
Output Directory(SQOT): /SQR_/apps/psoft/pf816m/sqr/tmmmod/tmpf013.sqr_2785
Log Directory (SQLG): /SQR_/apps/psoft/pf816m/sqr/tmmmod/tmpf013.sqr_2785


Error: SQR bin not set

Running the script with the sqr binary, but not submitting it to the Process Scheduler works fine. i.e;

/apps/sqr/8.16/ora/bin/sqr /apps/psoft/pf816m/sqr/tmm-mod/tmpf013.sqr <Oracle account>/<password>@<oracle instance> -XB @/tmp/input.file INFOPUMP UK_PNV_CONV

(INFOPUMP and UK_PNV_CONV being the OPID and RUN_CNTL_ID respectively)

Below are the relevant SQR shell variables, and current values;

SQRDIR=/apps/sqr/8.16/ora/bin
TM_SQR=/apps/psoft/pf816m/sqr/tmm-mod
SQRFLAGS=-i/apps/psoft/pf816m/sqr/tmm-mod/;/apps/psoft/pf816m/sqr/ -zif/apps/psoft /pf816m/sqr/pssqr.unx
SQR_HOME=/apps/sqr/8.16
PS_SQR=/apps/psoft/pf816m/sqr

(and added by myself, but not successful);

SQRBIN=/apps/sqr/8.16/ora/bin/

Initially I thought that it was a case of defining &quot;SQRBIN&quot; (literally setting &quot;SQR bin&quot;, but that hasn't done the trick. I still suspect an environment variable or configuration problem, but any clues what I should be pursuing?


Thanks in anticipation.


Recl

 

[jbarril]

run the SQR with the -ZIF parm and point it to an .ini file that contains the SQRDIR setting. There is probably a pssqr.ini delivered file in your /apps/psoft/pf816m/sqr/ directory.