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
Cause
psql does not have any resolved libraries linked to it. There is a documented known issue on CentOS with the following workaround.
https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/spectrum/21-2/release-information/Known-Issues.html#concept.dita_d281807d-9966-4a24-9bea-782c5bdd3138_2128ki
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
Environment
Release : 21.2
Component : Jaspersoft for CA Spectrum 7.1.1
Resolution
SE have confirmed that CABI 7.1.1 and Spectrum 21.2.8 are compatible and so it is not required to upgrade CABI to 7.9.1 when upgrading Spectrum to 21.2.8.
Additional Information
A new version of CABI 7.9.1.1 will be released with NetOps 21.2.10 that will contain fixes for all of these issues.
Feedback
