"SQL command not properly ended" error while trying to retrieve PeopleSoft job spool file

Document ID : KB000022564
Last Modified Date : 14/02/2018
Show Technical Document Details

Issue/Problem/Symptoms: 

I am getting following error at the Monitor perspective of the CA Desktop Client each time when I try to retrieve the spool file for the PS job: "Request failed, "ORA-00933: SQL command not properly ended"

Resolution/Workaround:

The version 2.1 of the Agent for PeopleSoft has the default value for the following parameter:

ps.runIndependent= true

  You would need to change it to:

ps.runIndependent=false

  1. Stop the Agent
  2. Open the agentparm.txt file and find the section of data for the PeopleSoft parameters, e.g.:
    Figure 1
  3. Change the value of the ps.runIndependent= parameter from 'true' to 'false'
  4. Save and close the agentparm.txt file
  5. Start the Agent.