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

Products

• CA Automic Workload Automation - Automation Engine
• AUTOMIC WORKLOAD AUTOMATION

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.