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
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- Install the Automic Agent on drive D
- Put the SQL script on drive C
Results Actual: You cannot execute the SQL script.
Expected: The SQL script should be able to run.
Environment
Release: WAASER99000-1.0-Automic Workload Automation-Services
Component:
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.
Feedback
thumb_up
Yes
thumb_down
No