jdbc-tool.jar DB Execution Action does not accept file path with space character
Article ID: 84958
Updated On:
Products
CA Automic Workload Automation - Automation Engine
Issue/Introduction
Error Message :
N/A
When using the DB Execution action, jdbc-tool.jar, if there are space characters in the file path, even if there are double quotes(") around them, the action behaves unpredictably.
When a file path with space character is used in the DB Execution action, internally the space is replaced with the string %20 and so the actual path in the Windows environment can't be found.
N/A
When using the DB Execution action, jdbc-tool.jar, if there are space characters in the file path, even if there are double quotes(") around them, the action behaves unpredictably.
When a file path with space character is used in the DB Execution action, internally the space is replaced with the string %20 and so the actual path in the Windows environment can't be found.
<Please see attached file for image>
Environment
OS Version: N/A
Cause
Cause type:
Defect
Root Cause: When JDBC actions are executed if there are spaces in the file path (i.e. "C:\Program Files\..") the actions fail because the space is converted to the string of %20 (i.e. "C:\Program%20Files\..) and that path does not exist.
Defect
Root Cause: When JDBC actions are executed if there are spaces in the file path (i.e. "C:\Program Files\..") the actions fail because the space is converted to the string of %20 (i.e. "C:\Program%20Files\..) and that path does not exist.
Resolution
Update to a fix version listed below or a newer version if available.
Fix Status: Released
Fix Version(s):
Package JDBC 1.2.5 - Available
Fix Status: Released
Fix Version(s):
Package JDBC 1.2.5 - Available
Additional Information
Workaround :
Use file name and location path without any empty spaces.
Use file name and location path without any empty spaces.
Attachments
Feedback
Yes
No
Powered by
