Upgrade Spectrum CABI to 7.9.1 fails on PostGres with GUI and silent methods
Article ID: 238739
Updated On:
Products
Issue/Introduction
CABusinessIntelligence_install_2022_03_29_14_00_01.log
2022-03-29 14:07:48 INFO CABIProcessBuilder.cabiProcess():56 - cabiProcess method invoked with arguments- command and process path
2022-03-29 14:07:48 INFO CABIProcessBuilder.createProcessArgList():98 - createProcessArgList method is invoked with arguments- command string array
2022-03-29 14:07:48 INFO CABIProcessBuilder.createProcessArgList():111 - Adding /bin/shto arraylist
2022-03-29 14:07:48 INFO CABIProcessBuilder.createProcessArgList():111 - Adding -cto arraylist
2022-03-29 14:07:48 INFO CABIProcessBuilder.createProcessArgList():108 - Adding export LD_LIBRARY_PATH="/opt/CA/SharedComponents/CABusinessIntelligence/postgresql/lib" && sleep 100 && su postgres -s /bin/sh -c "./bin/psql -U postgres -p 5432 -h 127.0.0.1 -c \"ALTER USER postgres PASSWORDxxxxxto arraylist
2022-03-29 14:07:48 INFO CABIProcessBuilder.createProcessArgList():119 - Process Argument List returned: [/bin/sh, -c, export LD_LIBRARY_PATH="/opt/CA/SharedComponents/CABusinessIntelligence/postgresql/lib" && sleep 100 && su postgres -s /bin/sh -c "./bin/psql -U postgres -p 5432 -h 127.0.0.1 -c \"ALTER USER postgres xxxxx
2022-03-29 14:07:48 INFO CABIProcessBuilder.cabiProcess():65 - Command ArrayList: [/bin/sh, -c, export LD_LIBRARY_PATH="/opt/CA/SharedComponents/CABusinessIntelligence/postgresql/lib" && sleep 100 && su postgres -s /bin/sh -c "./bin/psql -U postgres -p 5432 -h 127.0.0.1 -c \"ALTER USER postgres PASSWORDxxxxx
2022-03-29 14:07:48 DEBUG CABIProcessBuilder.cabiProcess():70 - Creting the processbuilder object
2022-03-29 14:07:48 DEBUG CABIProcessBuilder.cabiProcess():74 - Setting the processbuilder directory to /opt/CA/SharedComponents/CABusinessIntelligence/postgresql
2022-03-29 14:07:48 DEBUG CABIProcessBuilder.cabiProcess():78 - Starting the process
2022-03-29 14:07:48 DEBUG CABIProcessBuilder.cabiProcess():80 - Waiting for the process to finish
2022-03-29 14:09:28 DEBUG CABIProcessBuilder.cabiProcess():82 - Process exit value is 127
2022-03-29 14:09:28 INFO CABIProcessBuilder.cabiProcess():86 - cabiProcess method returned with value-127
2022-03-29 14:09:28 ERROR ConfigurePostgresql.changePwd():184 - Error in configuring the postgresql database user127
2022-03-29 14:09:28 ERROR ComponentInstall.startPostgresql():510 - Error in starting postgresql database
2022-03-29 14:09:28 ERROR CABIUtil.printCABIException():109 - ErrorCode : 19032 ErrorMessage :
2022-03-29 14:09:28 ERROR CABIUtil.printCABIException():109 - ErrorCode : 19033 ErrorMessage :
2022-03-29 14:09:29 DEBUG ProgressThread.run():88 - Error code from component install is: 1
Environment
Release : 21.2
Component : Jaspersoft for CA Spectrum 7.1.1.x & 7.9.1.x
Cause
psql does not have any resolved libraries linked to it. There is a documented known issue on CentOS with the following workaround.
Workaround:
From a command line, create a link to the libreadline.so.6 library that points to the CentOs 8.4 libreadline.so.7 library by issuing the following command:
# ln -s /lib64/libreadline.so.7.0 /lib64/libreadline.so.6
Verify the result by issuing the following command:
# ldd psql Output: libreadline.so.6 => /lib64/libreadline.so.6 (0x00007f2f781f0000)
The shared libraries should list as resolved, including the libreadline.so.6 library.
This does not work here as the ldd psql command returns no resolved libraries only the following:
not a dynamic executable
Resolution
DX NetOps Spectrum 21.2.8 supports only CABI 7.9.1.
CABI 7.1.1.1 and Spectrum 21.2.8 should work. But still, according to the Interoperability Matrix, we'll not be fixing any CABI issues for such configuration and recommend upgrading to supported CABI version to get such coverage.
Additional Information
CABI 7.9.1.1 already released with NetOps 21.2.10 that will contain fixes for all of these issues.
Feedback
