TurboIntegrator process connection to ODBC source fails in Planning Analytics on Red Hat Enterprise Linux 8 or 9
In Planning Analytics installed on Red Hat Enterprise Linux 8 or 9, a process that uses an ODBC data source fails with the error message SQLState: 01000 SQLMsg: [unixODBC][Driver Manager]Can't open lib '/usr/lib64/psqlodbc.so' : file not found.
To resolve this issue, add the line
LD_PRELOAD=/lib64/libssl.so.1.1:/lib64/libcrypto.so.1.1
to the
.profile or .bashrc file in your Linux environment, then
restart the Planning Analytics service.