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 Agent not starting

book

Article ID: 200551

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine

Issue/Introduction

Freshly installed SQL Agent doesn't start, with an error referring to hardware-software combination: 

20200929/155618.844 - U02000071 Current directory: C:\Automic\Agents\SQL\bin
20200929/155618.844 - U02000066 Host information: Host name='<HOSTNAME', IP address='<xxx.xxx.xxx.xxx>'
20200929/155618.922 - U02000153 The JVM Option HeapDumpOnOutOfMemoryError is enabled.
20200929/155619.047 - U02000072 Connection to system '<AUTOMIC>' initiated.
20200929/155619.047 - U02000011 Connection to Server '/<xxx.xxx.xxx.xxx>:<port>' initiated.
20200929/155619.063 - U02000004 Connection to Server '<AUTOMIC#CP001' successfully created.
20200929/155619.063 - U02000075 CP Server '<AUTOMIC#CP001' has '1' client connections.
20200929/155619.172 - U02000020 Environment: Hardware = '&01'.
20200929/155619.172 - U02000021 Environment: Software = '&01'.
20200929/155619.172 - U02000022 Environment: SW version = '1.0'.
20200929/155619.219 - U00011605 The combination of hardware '' and software '                                ' version '1.0' ('0000000001') is not supported.
20200929/155619.219 - U02000041 Shutdown Agent 'SQL'.
20200929/155619.219 - U02003012 An unknown message from partner '<AUTOMIC#CP001' could not be processed.
20200929/155619.219 - U0009909 TRACE: (Received 317 bytes from <AUTOMIC#CP001)
                               00000000 01085543 45585F52 2020FE30 01515549  >..UCEX_R  þ0.QUI<
                               00000010 54542020 20303100 00000000 004E4B00  >TT   01......NK.<
                               00000020 00455853 54415254 32000000 00000000  >.EXSTART2.......<
                               00000030 00552D00 00000000 00000000 00000000  >.U-.............<
                               00000040 00000000 00000000 00000000 00000000  >................<
                               00000050 00000000 007C0000 00000000 00000000  >.....|..........<
                               00000060 00000000 00000000 00000000 00000000  >................<
                               00000070 00000000 00007C31 2E307C30 30303030  >......|1.0|00000<
                               00000080 30303030 317C2020 20202020 20202020  >00001|          <
                               00000090 20202020 20202020 20202020 20202020  >                <
                               000000A0 20202020 20202020 20202020 20202020  >                <
                               000000B0 20202020 20202020 20202020 20202020  >                <
                               000000C0 20202020 20202020 20202020 20202020  >                <
                               000000D0 20202020 20202020 20202020 20202020  >                <
                               000000E0 20202020 20202020 20202020 20202020  >                <
                               000000F0 20202020 20202020 20202020 20202020  >                <
                               00000100 20202020 20202020 20202020 20202020  >                <
                               00000110 20202020 20202020 20202020 20202020  >                <
                               00000120 20202020 20202020 20202020 20202020  >                <
                               00000130 20202020 20000000 00000000 00        >     ........   <
20200929/155619.250 - U02000002 Agent 'SQL' version '12.3.3+build.1591976926407' ended abnormally.

Cause

The parameter type in the Agent's ini-file has a typo

For instance:

MQSQL, ORACLE, MYSLQ, HAHA or POTSGRESQL

Environment

Release : 12.3

Component : AUTOMATION ENGINE

Resolution

Parameter type has to be a valid entry

; type: Database type.
; MSSQL - Microsoft SQL Server
; ORACLE - Oracle
; DB2 - IBM DB2
; MYSQL - My SQL
; HANA - SAP HANA
; POSTGRESQL - PostgreSQL
; EXASOL - EXASOL
; GENERICJDBC - Generic JDBC Driver for any DB