Issue Installing and Configuring PeopleSoft Plug-in

Document ID : KB000124141
Last Modified Date : 04/01/2019
Show Technical Document Details
Issue:
I am trying to configure the PeopleSoft plug-in for my DE scheduler Agent. The log contains error similar to this:
- java.sql.SQLException: No suitable driver found for jdbc:sqlserver://XXXXXXXX:1433;DatabaseName=XXXXXX
Environment:
CA Workload Automation Agent for PeopleSoft (PeopleSoft plugin)
Cause:
The Workload Automation Agent for PeopleSoft (PeopleSoft plugin) requires the JDBC driver and driver class name for the PeopleSoft database you are using.
Resolution:
Ensure that the driver JAR files are in the <agent>/jars/ext directory.
Also ensure that the jdbc.drivers property in the agentparm.txt file includes the driver or drivers you are using.
Example:
jdbc.drivers=oracle.jdbc.driver.OracleDriver:net.sourceforge.jtds.jdbc.Driver

 
Additional Information:
IMPORTANT:
The agent requires JDBC drivers for the database you are using.
Before starting the agent, obtain the necessary drivers from your database provider, and place them in the following directory: <agent>/jars/ext subdirectory.

Troubleshooting