SQL Script can not be executed in ARA action if SQL Agent is installed on different drive than Agent

book

Article ID: 87818

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine AUTOMIC WORKLOAD AUTOMATION

Issue/Introduction

Error Message :
java.sql.SQLException at com.automic.actions.common.db.SQLRunner.executeScript(SQLRunner.java:91) ~[jdbc-tool.jar:1.0.0 20151019-1927

Unable to read SQL statements from the script file and the feature ends with the above exception.

Investigation
  1. Install the Automic Agent on drive D
  2. Put the SQL script on drive C
Results
 
Actual: You cannot execute the SQL script.
Expected:  The SQL script should be able to run.

Cause

Cause type:
Defect
Root Cause: Unable to run a SQL script located on a drive other than the drive the Agent is installed.

Environment

Release: WAASER99000-1.0-Automic Workload Automation-Services
Component:

Resolution

Update to Package Database Tool version 1.0.1 or a higher version.
 

Fix Status: Released

Fix Version(s):
Package Database Tool version 1.0.1 - Available

Additional Information

Workaround :
SQL script must be on the same drive as the Agent.