Failed to create a connection to the database ('com.uc4.ex.sql.ConnectionException:java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver').

book

Article ID: 195345

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine CA Automic Workload Automation - Automation Engine

Issue/Introduction

About 50 % of the time, an SQL VARA or SEC_SQL VARA given error upon execution:

1. When clicking on Preview in side the VARA object:

Failed to create a connection to the database
('com.uc4.ex.sql.ConnectionException:java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver').

2. Or when executed in a script in the WP log:

 U02012053 RunID: '198443971/1': Failed to create a connection to the database.

No message is found in the log of the DB Service Agent

Cause

This is due to a second badly configure DB

Environment

Release : 12.2

Component : DB Service Agent for SQL Varas

Resolution

Remove or correctly configure the second DB Service Agent