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'.

book

Article ID: 197392

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine CA Automic One Automation CA Automic Operations Manager CA Automic Oracle

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

Cause

Incorrect values in LD_LIBRARY_PATH

Environment

Release : 12.3

Component : AUTOMATION ENGINE

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.