AE DB Utility ucybdbrt is disconnecting prematurely

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

The Reporting-Tool utility ucybdbrt consistently ends with Return Code 1 following a migration from Oracle to PostgreSQL and an upgrade from AE 12.3 -> 24.4

Cause

The issue is caused by an incorrect configuration of the LD_LIBRARY_PATH environment variable, which leads the utility to load the wrong shared object libraries (.so files).

Investigation using the ldd command revealed that the reporting tool was loading libraries from the Automation Engine Server binary directory (.../server/bin/) instead of the Utility binary directory (.../utility/bin/)

For example, the incorrect output showed:

libsysapi.so => /usr/sap/ECW/UC4244/server/bin/libsysapi.so

Instead of the correct path:

libsysapi.so => /usr/sap/ECP/UC4244/utility/bin/libsysapi.so

Resolution

To resolve this issue, update the environment variables to ensure the Utility loads its own libraries.

Update LD_LIBRARY_PATH: Modify the LD_LIBRARY_PATH environment variable so that the path to the Utility's bin directory appears before the path to the Server's bin directory, or points exclusively to the correct utility location for that session.

Rerun the ldd command to make sure that the correct libraries are picked up.

Additional Information

db=9 trace showed the following db disconnect

PGSQuery:: DisconnectX(END) returned: 1.

PGSQuery:: PQclear (END) returned: 1.

PGSQuery:: PQfinish(END) returned: 1