Description:
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
Solution:
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.