Upgrade Spectrum CABI to 7.9.1 fails on PostGres with GUI and silent methods

Products

• CA Spectrum

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.