DB Maintenance fails with UCUDB: Function LoadLibrary failed. Library 'ucupgs.so' error 'libpq.so.5: cannot open shared object file: No such file or directory'.

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

When attempting to run Automic Utilities, they fail with errors similar to:

20200812/144704.437 - ----------------------------------------------------------------------------------------------------
20200812/144704.438 - U00029120 UCUDB: Function LoadLibrary failed. Library 'ucupgs.so' error 'libpq.so.5: cannot open shared object file: No such file or directory'.
20200812/144704.438 - U00029186 Please make sure that your PostgreSQL installation is configured as described in the product documentation.
20200812/144704.438 - U00003531 UCUDB: Error while checking data source (e.g. code conversion or driver problem, see log file).
20200812/144704.438 - U00031115 Program canceled due to error.
20200812/144704.438 - U00003531 UCUDB: Error while checking data source (e.g. code conversion or driver problem, see log file).
Application return code = 1

Environment

Release : 12.3

Component : AUTOMATION ENGINE

Cause

Incorrect values in LD_LIBRARY_PATH

Resolution

That error points to the path the postgres libraries not being found in the LD_LIBRARY_PATH.

Added the following (this is an example):

/opt/automic/postgresql/pgsql/lib/

And then attempt to rerun the Utilities.