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

book

Article ID: 103066

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine

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>

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. 

<Please see attached file for image>

User-added image


 

Environment

Automation Engine version 10.0.4

Resolution

An enhancement in Automation Engine version 11.2 had fixed this issue.

Attachments

1558700759535000103066_sktwi1f5rjvs16k8o.jpeg get_app
1558700757465000103066_sktwi1f5rjvs16k8n.jpeg get_app
1558618329668000103066_sktwi9tkjvsehwuu.jpeg get_app
1558618327673000103066_sktwi9tkjvsehwut.jpeg get_app