SQL jobs cannot use CONN object to connect to a HANA database
Issue/Introduction:
Symptom:
When creating a SQL job, by using CONN object, it's failed and could not connect to the HANA SAP database.
<Please see attached file for image>
The error message is:
The host name of the database server is missing in the SQL Job. Therefore the Job has not been executed.
However, when specified the Server and Database name directly, it works fine.
<Please see attached file for image>
Environment:
Automation Engine version 10.0.4
Resolution:
An enhancement in Automation Engine version 11.2 had fixed this issue.