The sub-errors when submitting a PeopleSoft jobs. Details state that there was a permission type issue.

book

Article ID: 49485

calendar_today

Updated On:

Products

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

Issue/Introduction

Description:

While submitting PeopleSoft job, users may experience some permission issues. The job spool may show errors similar to following:

ORA-01031: insufficient privileges

 

Cause

These errors are usually due to inadequate privileges granted to the user, executing PeopleSoft jobs, on the PeopleSoft database.

Check the agent's peoplesoft.log - it would show an SQL query that resulted in the error. For instance:

PSPlugin.ps Internal Thread.PsDbHandler.runUpdateNoReconnect[:534] -

     runUpdate: INSERT INTO PS_PRCSRUNCNTL (OPRID, RUN_CNTL_ID, LANGUAGE_CD, LANGUAGE_OPTION) 
     VALUES ('MY_PS_USER','MY_CONTROL_ID','HIN','O')       
     PSPlugin.ps Internal Thread.PsDbHandler.runUpdateNoReconnect[:554] - 
     java.sql.SQLException: ORA-01031: insufficient privileges

In this above example the user 'MY_PS_USER' did not have the INSERT privilege to the PeopleSoft database.

Environment

Release: 11.3, 12.0
Component: Workload Automation Agent for PeopleSoft

Resolution

The user used to execute the PeopleSoft jobs must have adequate privileges to the PeopleSoft database.

If the PS job failed try to run an interactive SQL query on that DB to make sure the user was able to execute one.

As per the PeopleSoft Agent's Implementation guide, the agent plug-in requires the UPDATE and the INSERT privileges to the following PeopleSoft database tables:

  • PS_CDM_AUTH

  • PS_PRCSRQSTDIST

  • PS_CDM_LIST

  • PSPRCSRQSTTEXT

  • PSPRCSPARMS

  • PSPRCSQUE

  • PSPRCSRQST

  • PS_PRCSSYSTEM

  • PS_PRCSRUNCNTL

  • PS_PRCSSEQUENCE (in PeopleTools 8.4 and higher)

  • PS_PRCSSYSTEM (in PeopleTools lower than 8.4)

The agent's plug-in requires the SELECT privilege to the Process Scheduler database tables.

It is also recommended that you allow the SELECT access to all tables prefixed by PS or PS_.