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

Document ID : KB000087818
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
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.
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.