harweb.HServlet.getHDB(): Can't get hDB from pool with SQL Server 2019

Products

• CA Harvest Software Change Manager

Issue/Introduction

The following error occurs when trying to open Harweb:

SCM 14.0.2 (Server + Client) has been installed.
It's a system with MS Windows 2019 and MS SQL Server 2019. 

 

Environment

Release : 14.0 and up

Cause

I found information about this error on the Microsoft website:

"The certificate chain was issued by an authority that is not trusted" error after upgrading SNAC applications

Cause
These errors occur if both the following conditions are true:

• The Force encryption setting for the SQL Server instance is set to No.
• The client connection string doesn't explicitly specify a value for encryption property, or the Encryption option wasn't explicitly set or updated in the DSN.

The error occurs because of a change in the default behavior of the client drivers. Older versions of client drivers are designed to assume that data encryption is OFF by default. The new drivers assume this setting to be ON by default. Because data encryption is set to ON, the driver tries to validate the server's certificate and fails.

Resolution

Recommend to add the "trustServerCertificate=true;" option to the JDBCConnectionURL in the harweb.cfg file.

Like this:

JDBCConnectionURL=jdbc:sqlserver://my.sqlserver.hostname;databaseName=harvest;integratedSecurity=false;trustServerCertificate=true;selectMethod=cursor

Then restart Tomcat and try it again.