Connection to SMTP fails under IPv4

book

Article ID: 145489

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine CA Automic Workload Automation - Automation Engine

Issue/Introduction

Connection to SMTP fails after upgrade to v12.1 or higher when the environment only accepts IPv4 communication and IPv6 is disabled.

When setting the FQDN of the SMTP server in UC_CLIENT_SETTINGS > SMTP_SERVER the following error appears in the logs when a mail is send:

U00050029 The SMTP client cannot connect to the SMTP server 'LOCALHOST', error code '111', error description: 'Connection refused'.


This happens after an upgrade to v12.1 or higher

Another way this has presented itself is:
System going down, WPs dropping and unable to come back up.  The messages in the log file may show something like:


20200609/110606.021 - U00011619 Processing SRVQUERY inquiry from 'FQDN.here.com'. F-Addr = 'FQDN.here.com', BTable = 'MQ1CP001', Index = '0000000005'
20200609/110606.052 - U00005118 Program error: Database access via key 'RH_AH_Idnr' with value 0 in module 'UCUREP'.
20200609/110606.099 - U00005118 Program error: Database access via key 'RH_AH_Idnr' with value 0 in module 'UCUREP'.
20200609/110606.114 - U00005118 Program error: Database access via key 'RH_AH_Idnr' with value 0 in module 'UCUREP'.
20200609/110606.161 - U00005118 Program error: Database access via key 'RH_AH_Idnr' with value 0 in module 'UCUREP'.
20200609/110606.177 - U00005118 Program error: Database access via key 'RH_AH_Idnr' with value 0 in module 'UCUREP'.

and a database=3, tcp/ip=2 trace could show:


20200609/110606.380 -         STRT UCUVAR   OPC: 0209 entry='ucuvar' user-idnr=0000000005 client=0000000000 varname='UC_CLIENT_SETTINGS' wert=' ' text=  typ='C' gb-name='FREI' gb-w='SMTP_LOGIN'
20200609/110606.380 - U00009909 TRACE: (BINDPAR:  OVW_OH_Idnr       )                                          00007FFCA9C7A36C 000004
                                00000000  24000000                             >$...<
20200609/110606.380 -                                        >36<
20200609/110606.380 - U00009909 TRACE: (BINDPAR:  OVW_VValue        )                                          00007FFCA9C7A370 000010
                                00000000  534D5450 5F4C4F47 494E               >SMTP_LOGIN<
20200609/110606.380 - select  max(datalength(case when OVW_Value1 is Null then cast('0' as varchar(1)) else OVW_Value1 end)), max(datalength(case when OVW_Value2 is Null then cast('0' as varchar(1)) else OVW_Value2 end)), max(datalength(case when OVW_Value3 is Null then cast('0' as varchar(1)) else OVW_Value3 end)), max(datalength(case when OVW_Value4 is Null then cast('0' as varchar(1)) else OVW_Value4 end)), max(datalength(case when OVW_Value5 is Null then cast('0' as varchar(1)) else OVW_Value5 end)) FROM OVW WHERE OVW_OH_Idnr = ? AND OVW_VValue = ?
20200609/110606.380 - U00009909 TRACE: (BINDPAR:  OVW_OH_Idnr       )                                          00007FFCA9C7A36C 000004
                                00000000  24000000                             >$...<
20200609/110606.380 -                                        >36<
20200609/110606.380 - U00009909 TRACE: (BINDPAR:  OVW_VValue        )                                          00007FFCA9C7A370 000010
                                00000000  534D5450 5F4C4F47 494E               >SMTP_LOGIN<
20200609/110606.380 - SELECT TOP 1 OVW_OH_IDNR,OVW_VVALUE,OVW_OH_CLIENT,OVW_VRNAME,OVW_Value1,OVW_Value2,OVW_Value3,OVW_Value4,OVW_Value5 FROM OVW WHERE OVW_OH_Idnr = ? AND OVW_VValue = ?
20200609/110606.380 - UCUDB32 SLBL RET 0000 HSTMT: 0000000000B9E210 VALUE: 0000000000000032 ALL:  0.00181 DB:  0.00129 ODBC:  0.00033 UDB:  0.00019
20200609/110606.380 - UCUDB32 READ RET 0001 HSTMT: 0000000000B9E210 VALUE: 0000000000000000 ALL:  0.00038 DB:  0.00038 ODBC:  0.00000 UDB:  0.00000
20200609/110606.380 - UCUDB32 CLST RET 0000 HSTMT: 0000000000B9E210 VALUE: 0000000000000000 ALL:  0.00032 DB:  0.00000 ODBC:  0.00031 UDB:  0.00001
20200609/110606.380 - U00009909 TRACE: (PRIMKEY:  OVW_OH_Idnr       )                                          00007FFCA9C7A36C 000004
                                00000000  24000000                             >$...<
20200609/110606.380 -                                        >36<
20200609/110606.380 - U00009909 TRACE: (PRIMKEY:  OVW_VValue        )                                          00007FFCA9C7A370 000010
                                00000000  534D5450 5F4C4F47 494E               >SMTP_LOGIN<
20200609/110606.380 - UCUDB32 CPTC RET 0000 HSTMT: 0000000000000000 VALUE: 0000000000000000 ALL:  0.00003 DB:  0.00000 ODBC:  0.00000 UDB:  0.00003
20200609/110606.380 -  
20200609/110606.380 -         EXIT UCUVAR   RET: 0000000000  TIME: 0000,00498  RETTEXT=' ' varname='UC_CLIENT_SETTINGS' wert=' ' text=' ' typ='C' gb-name='FREI' gb-w='SMTP_LOGIN''
20200609/110606.380 -       EXIT UCUECS     RET: 0000000000  TIME: 0000,00936  RETTEXT=', VALUE='
20200609/110606.380 -       STRT UCUOHC     OPC: 0204   oh-idnr=0000000000 client=1000 oh-name='' cache-size=0000000000
20200609/110606.380 -       EXIT UCUOHC     RET: 0000000001  TIME: 0000,00001  RETTEXT='' oh-idnr=0000000000 client=1000 oh-name='' cache-size=0000524288 deleteflag=00000 otype=''''
20200609/110606.380 -       STRT UCUOHC     OPC: 0204   oh-idnr=0000000000 client=0000 oh-name='' cache-size=0000000000
20200609/110606.380 -       EXIT UCUOHC     RET: 0000000001  TIME: 0000,00000  RETTEXT='' oh-idnr=0000000000 client=0000 oh-name='' cache-size=0000524288 deleteflag=00000 otype=''''
20200609/110606.380 -       STRT UCMAIL     OPC: 0003 server=smtp.FQDN.com [email protected]

Cause

This is a bug introduced when the AE was made IPv6 ready.

Environment

Release : v12.1 / v12.2 / v12.3

Component : AUTOMATION ENGINE

Resolution

Workaround:

  • It sometimes works to comment the IPv6 address in /etc/hosts
  • Another workaround is to use an IP address rather than fully qualified domain name in the STMP_SERVER setting in UC_CLIENT_SETTINGS
    • This may need to be done through a direct update to the database if the system is not running



Solution:

Update to a fix version listed below or a newer version if available.


Fix version:

Component(s): Automation Engine

Automation.Engine 12.3.1 - Available
Automation.Engine 12.1.7 - Available
Automation.Engine 12.4.0 - Planned for future release
Automation.Engine 12.2.5 - Available
Automation.Engine 12.2.3 HF3 - Available