SOIToolbox utility does not work with SQL 2016

book

Article ID: 208325

calendar_today

Updated On:

Products

CA Service Operations Insight (SOI)

Issue/Introduction

SOIToolbox utility is returning the following error

D:\CA\SOI\Tools>soitoolbox.exe -x --getStatisticalData

Started 26/01/2021 at 15:06:40

-> Parsing configuration file soitoolbox.cfg ... Done, 64 lines processed

-> Initializing DB connection to [email protected]:1433 (timeouts=20/30)... -> Initializing DB connection to [email protected]:1433 (timeouts=20/30)...

-> Going to access 'SAMStore' database on machine 'xxxx'

   Provide password for user 'user':

 -> Initializing DB connection to [email protected]:5533 (timeouts=20/30)... ERROR: ('Exception:', Error('08001', '[08001] [Microsoft][ODBC SQL Server Driver][DBNETLIB]SSL Security error (18) (SQLDriverConnect); [01000] [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (SECDoClientHandshake()). (817)'))

Cause

ODBC driver not compatible with SQL 2016

Environment

Release : 4.2

Component : Service Operations Insight (SOI) Manager

Resolution

Using SQL 2016 without encrypted SQL Server connections.

 

2 things are needed to resolve issue.

1) Apply SOI patch SO15850

https://support.broadcom.com/external/content/release-announcements/CA-Service-Operations-Insight-Solutions--Patches/6500

If you don't have this patch, the SOIToolbox utility will not use additional ODBC driver.

 

2) Install the latest ODBC driver from Microsoft on the SOI Manager server where soitoolbox.exe is being executed from.

 

 

 

Additional Information

The result is the soitoolbox utility will use the default ODBC driver first, when that failed, it will use the new driver.