search cancel

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

book

Article ID: 189689

calendar_today

Updated On:

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.

Cause

ODBC drivers for postgres are not present. 

Environment

Release : 12.3

Component : AUTOMATION ENGINE, UTILITIES

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.