For some reason our sqr processes are failing to run. The problem is the database name is not being filled in.
Sample command is
pssqr -CT ORACLE -CS %SERVER% -CD %DBNAME% -CA %ACCESSID% -CAP %ACCESSPSWD%
-RP ECOUT001 -I 302581 -R ECOUT001 -CO PRODUSER -OT 6 -OP %LOG/OUTPUT
DIRECTORY% -OF 2 -LG ENG
The %DBNAME% is not being filled in so it sees it as -CA
(SQR 5716) Unknown flag on command line: -CA
SQR for PeopleSoft: Program Aborting.
PeopleTools 8 - PSSQR
Copyright (c) 1988-2007 PeopleSoft, Inc.
All Rights Reserved
In peoplesoft_log.txt it shows that the query below didn't return value:
SELECT DBNAME FROM PSDBOWNER
This Peoplesoft database was missing a link for the dbowner table. It is not in the sysadm schema. This needs to be fixed.