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

Article Id: 87818
Status: Published
Updated On: 15-04-2018 08:01
Legacy Id: 000009008
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.