AutoSys Workload Automation

I have installed the DB Plugin in order to work with Store Procedure type jobs in WA AE 11.3.6 SP4

The plugin install completed succesfully but the JOB fails with the following message:

   <No suitable driver found for jdbc:oracle:thin:@jdbc:oracle:thin:@(DESCRIPTION=(FAILOVER=ON)(LOAD_BALANCE=OFF)(ADDRESS=(PROTOCOL=TCP)(HOST=***.***.***.***)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=***.***.***.***)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=dbms)))>

Hi,

Did you install the JDBC drivers, as described in documentation?

If not, please refer to:

 
Install CA WA Agent for Databases - CA Workload Automation Agents - 11.3 - CA Technologies Documentation 

The JDBC drivers install is mentioned in step 6.

Hi,

Thank you for answering.

Yes, the JDBC Drivers are installed, in fact I have already located the odjbc6.jar mentioned in the documentation.

Perhaps this could be a PATH issue?

Daniel D.

De: laule03 

Enviado el: miércoles, 23 de noviemb, re de 2016 01:28 p.m.

Para: Daniel Diaz <daniel@dmg.com.mx>

Asunto: Re:  - Re: Job fails with No suitable driver found for jdbc:oracle:thin

<https://communities.ca.com/?et=watches.email.thread> CA Communities

Re: Job fails with No suitable driver found for jdbc:oracle:thin

reply from Leandro Laurenti <https://communities.ca.com/people/laule03?et=watches.email.thread>  in CA Workload Automation - View the full discussion <https://communities.ca.com/message/241940466?commentID=241940466&et=watches.email.thread#comment-241940466>

The jdbc driver for your database should be copied to the /jars/ext directory and restart the agent.

Copied the jdbc driver to /jars/ext and it worked...

Thanks!!