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

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

A new deploy of cabi fails right away. 

 

 

Environment

Release : 20.3

Component : UIM - CABI

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. 

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.