ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
jdbc-tool.jar DB Execution action file path with space character not working
Article ID: 87202
Updated On:
Products
CA Automic Workload Automation - Automation Engine
Issue/Introduction
Error Message :
N/A
The JDBC-tool.jar DB Execution action does not accept a file path with a space character even if the space is enclosed in double quotes (i.e. file:/C:/automic/sql 2.sql). It behaves unpredictably when a space is encountered.
When you use a file path with a space character in the DB Execution action it is internally replaced with %20 string and then it is unable to find the actual path in the Windows environment.
N/A
The JDBC-tool.jar DB Execution action does not accept a file path with a space character even if the space is enclosed in double quotes (i.e. file:/C:/automic/sql 2.sql). It behaves unpredictably when a space is encountered.
When you use a file path with a space character in the DB Execution action it is internally replaced with %20 string and then it is unable to find the actual path in the Windows environment.
<Please see attached file for image>
Cause
Cause type:
Defect
Root Cause: Executing JDBC actions don't work with file paths that contain a space character (blanks) such as "C:\Program Files\..."
Defect
Root Cause: Executing JDBC actions don't work with file paths that contain a space character (blanks) such as "C:\Program Files\..."
Environment
OS Version: N/A
Resolution
Update to a fix version listed below or a newer version if available.
The issue was found and fixed with Package.JDBC 1.2.5 in PCK.AUTOMIC_JDBC.
The Package is available for download at the Automic-Support-Zone
Fix Status: Released
Fix Version(s):
Package JDBC 1.2.5 - Available
The issue was found and fixed with Package.JDBC 1.2.5 in PCK.AUTOMIC_JDBC.
The Package is available for download at the Automic-Support-Zone
Fix Status: Released
Fix Version(s):
Package JDBC 1.2.5 - Available
Additional Information
Workaround :
Use a path or file name that does not contain any spaces.
Use a path or file name that does not contain any spaces.
Attachments
Feedback
Yes
No
Powered by
