SQL Script can not be executed in ARA action if SQL Agent is installed on different drive than Agent
Article ID: 87818
CA Automic Workload Automation - Automation Engine
AUTOMIC WORKLOAD AUTOMATION
Error Message :
java.sql.SQLException at com.automic.actions.common.db.SQLRunner.executeScript(SQLRunner.java:91) ~[jdbc-tool.jar:1.0.0 20151019-1927Unable to read SQL statements from the script file and the feature ends with the above exception.
- Install the Automic Agent on drive D
- Put the SQL script on drive C
Actual: You cannot execute the SQL script.
Expected: The SQL script should be able to run.
Root Cause: Unable to run a SQL script located on a drive other than the drive the Agent is installed.
Release: WAASER99000-1.0-Automic Workload Automation-Services
Update to Package Database Tool version 1.0.1 or a higher version.
Fix Status: Released
Package Database Tool version 1.0.1 - Available
SQL script must be on the same drive as the Agent.