AWA: U00029120 UCUDB: Function LoadLibrary failed. Library 'UCUPGS' error 'The specified module could not be found.

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

When attempting to use the Automation Engine or Utilities pointing to a postgres DB, the processes fail with the following error:

U00029120 UCUDB: Function LoadLibrary failed. Library 'UCUPGS' error 'The specified module could not be found.

Environment

Release : 12.3

Component : AUTOMATION ENGINE, UTILITIES

Cause

ODBC drivers for postgres are not present. 

Resolution

Windows Setup

The following .dll files must be added to the bin folder of the Automation Engine and the Utilities, or must be included in the Windows path:

• libeay32.dll
• libpq.dll
• ssleay32.dll

Additionally, for PostGres versions lower than 11.0:

• libiconv-2.dll
• libintl-8.dll

These files are part of the psqlodbc package and can be downloaded from https://www.postgresql.org/ftp/odbc/versions/dll/. Make sure to use the latest version for your PostgreSQL installation.

UNIX

Make sure that a PostgreSQL​ client is installed.