ODBC error U00003592 during secondary node upgrade - Automic Automation Engine

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

When upgrading a secondary Automation Engine (AE) node to version 24.4.x using the ONE Installer, the installation fails with an ODBC connection error:

U00003592 UCUDB - Status: '08001' Native error: '53' Msg: 'A network-related or instance-specific error has occurred while establishing a connection..."

The installer may attempt to connect to a legacy database instance (e.g., sqlAutomic21) even after the ODBC DSN is updated or removed from the Windows ODBC Data Source Administrator.

Environment

• Automic Automation Engine 24.4.x
• Multi-node (Cluster) Deployment
• Windows Server
• ONE Installer

Cause

The ONE Installer is designed primarily for single-box installations (Proof of Concept or non-production). When run on a secondary node, it attempts to load the database again. Because the Utility/*.ini files on the secondary server often contain legacy connection strings from previous versions, the installer uses these cached settings instead of the active system DSN.

Resolution

Do not use the ONE Installer to upgrade secondary nodes in a multi-node AE environment. The installer's database-loading function is only required on the primary node (####).

Follow these steps to upgrade secondary nodes manually:

1. Abandon the ONE Installer on the secondary server (####).
2. Manually deploy the binaries for the Automation Engine to the secondary node.
3. Update the .ini files (ucsrv.ini and utility .ini files) on the secondary node to match the connection strings used on the primary node.
4. Start the services via the Service Manager.

Refer to the official documentation for detailed manual steps:

• Upgrading an Automation Engine System Manually
• Upgrade Installation

For more information on the ONE Installer limitations, see: ONE Installer - Single-Box Installation