ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
SQL jobs cannot use CONN object to connect to a HANA database
Article ID: 103066
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.
The error message is:
However, when specified the Server and Database name directly, it works fine.
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.
Attachments
Feedback
Yes
No
Powered by
