SQL jobs cannot use CONN object to connect to a HANA database

Document ID : KB000103066
Last Modified Date : 22/06/2018
Show Technical Document Details
Issue:
Symptom: 
When creating a SQL job, by using CONN object, it's failed and could not connect to the HANA SAP database.

User-added 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. 

User-added image


 
Environment:
Automation Engine version 10.0.4
Resolution:
An enhancement in Automation Engine version 11.2 had fixed this issue.