UIM 20.3 cabi deploy fails with CABI installer failed with exit code=1

Products

• DX Infrastructure Management
• CA Unified Infrastructure Management On-Premise (Nimsoft / UIM)

Issue/Introduction

A new deploy of cabi fails right away. 

 

 

Cause

The UIM database is hosted on a MS SQL server with TLS 1.0, 1.1, & 1.2 enabled. 

This can also happen if the UIM database is hosted by MS SQL Server running on a Windows 2016 server with just TLS. 1.2 enabled. 

Environment

Release : 20.3

Component : UIM - CABI

Resolution

TSL 1.0, and 1.1 must be disabled and only TLS 1.2 enabled. 

If the UIM database is hosted by MS SQL Server running on a Windows 2016 server with just TLS. 1.2 enabled, this is not supported and there is no workaround. 

Additional Information

cabi_install_archive.log has: 

Jan 13 14:55:11:882 [Thread-1, cabi]      [exec]      [echo]   Jar or Jars found: TIsqlserver-5.14.1.jar;jasperreports-pro-7.1.0.jar 
Jan 13 14:55:18:122 [Thread-1, cabi]      [exec] [advanced-sql] Failed to connect: [TibcoSoftware][SQLServer JDBC Driver]The SQL Server login requires an SSL connection.
Jan 13 14:55:18:122 [Thread-1, cabi]      [exec]      [echo] Connection failed:
Jan 13 14:55:18:122 [Thread-1, cabi]      [exec]      [echo]   SQLState: 08001
Jan 13 14:55:18:122 [Thread-1, cabi]      [exec]      [echo]   Vendor specific error code: 0
Jan 13 14:55:18:122 [Thread-1, cabi]      [exec]      [echo]   Message: [[TibcoSoftware][SQLServer JDBC Driver]The SQL Server login requires an SSL connection.]

Jan 13 14:55:18:123 [Thread-1, cabi]      [exec] BUILD FAILED
Jan 13 14:55:18:123 [Thread-1, cabi]      [exec] D:\Program Files (x86)\Nimsoft\c\buildomatic\bin\validation.xml:495: The following error occurred while executing this line:
Jan 13 14:55:18:123 [Thread-1, cabi]      [exec] D:\Program Files (x86)\Nimsoft\c\buildomatic\bin\validation.xml:376: The following error occurred while executing this line:
Jan 13 14:55:18:123 [Thread-1, cabi]      [exec] D:\Program Files (x86)\Nimsoft\c\buildomatic\conf_source\db\sqlserver\db.xml:94: The following error occurred while executing this line:
Jan 13 14:55:18:123 [Thread-1, cabi]      [exec] D:\Program Files (x86)\Nimsoft\c\buildomatic\bin\validation.xml:447: The following error occurred while executing this line:
Jan 13 14:55:18:123 [Thread-1, cabi]      [exec] D:\Program Files (x86)\Nimsoft\c\buildomatic\bin\validation.xml:470: Generic connection failure: [[TibcoSoftware][SQLServer JDBC Driver]The SQL Server login requires an SSL connection.]. Treating problem with JDBC connection as unrecoverable

Jan 13 14:55:18:251 [main, cabi] cabi installer completed with exit code=1 [time taken=0 minute(s) 10 second(s) (10675 ms)]
Jan 13 14:55:18:252 [main, cabi] (42) , CABI installer failed with exit code=1
 at com.ca.cabi4uim.installer.CabiInstaller.runCabiInstaller(CabiInstaller.java:247)
 at com.ca.cabi4uim.Probe.doConfigAndRunCabiInstaller(Probe.java:441)
 at com.ca.cabi4uim.Probe.setupCabiInBundledMode(Probe.java:388)
 at com.ca.cabi4uim.Probe.setupcabi(Probe.java:354)
 at com.ca.cabi4uim.Probe.initOnTimer(Probe.java:700)
 at com.nimsoft.nimbus.NimProbe.doForever(NimProbe.java:418)
 at com.ca.cabi4uim.Probe.run(Probe.java:892)
 at com.ca.cabi4uim.Probe.main(Probe.java:123)

As per the UIM Compatibility Matrix

https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/unified-infrastructure-management/20-3/installing/product-compatibility/ca-uim-compatibility-matrix.html

The CABI TLS v1.2 feature is not supported for Microsoft SQL Server 2012, 2014, and 2016 when installed on Windows Server 2016.