sqr processes are failing to run. The problem is the database name is not being filled in.

Products

• CA Workload Automation AE - Business Agents (AutoSys)
• CA Workload Automation AE - Scheduler (AutoSys)
• Workload Automation Agent

Issue/Introduction

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.

Environment

Release:
Component: ATSYS