(DP) Support Tip: omnidbcheck -schema_consistency Failed

(DP) Support Tip: omnidbcheck -schema_consistency Failed

Error Message
/opt/omni/sbin/omnidbcheck

Check Level Mode Status
==========================================================
Database connection -connection OK
Schema consistency -schema_consistency Failed
Datafiles consistency -verify_db_files OK
DCBF(presence and size) -bf OK
DONE!

- extracts from OMNIDBCHECK debug
[299] 2020-06-08 11:19:31.985 ("/lib/cmn/common.c $Rev: 51341 $ $Date:: 2016-01-18 08:41:19":2784)
[299] ===>> (5) CmnRunReadLine {
[299]
[199] [CmnPipeRead] pswait:1
[400] [CmnPipeRead] read:75/4095 pg_dump: symbol lookup error: pg_dump: undefined symbol: PQconnectdbParams

Cause
Another PostgreSQL version has been installed in Cell Manager system .
CM package includes PostgreSQL and it's not expected that another PostgeSQL coexists in the system .

# pg_dump --version
pg_dump (PostgreSQL) 8.4.20

# which pg_dump
/usr/bin/pg_dump

# /opt/omni/idb/bin/pg_dump --version
pg_dump (PostgreSQL) 9.1.9

# rpm -qa |grep postgres
postgresql-libs-8.4.20-5.el6_7.x86_64
postgresql-devel-8.4.20-5.el6_7.x86_64
postgresql-8.4.20-5.el6_7.x86_64

Workaround / Fix
The issue might be able to be avoided by adding /opt/omni/idb/bin to PATH with priority, but it will make another issue because PostgreSQL commands under /usr/bin won't be referred anymore .
Please consider to uninstall PostgreSQL that has been installed apart from DP installation .

Labels (1)

DISCLAIMER:

Some content on Community Tips & Information pages is not officially supported by Micro Focus. Please refer to our Terms of Use for more detail.
Top Contributors
Version history
Revision #:
1 of 1
Last update:
‎2020-06-12 09:15
Updated by:
 
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.