Using Microsoft JDBC Driver for SQL Server 10.2 or above - EcoSys - 9.0 - Installation & Upgrade - Hexagon PPM

EcoSys Installation

Language
English (United States)
Product
EcoSys
Search by Category
Installation & Upgrade
EcoSys Version
9.0

Starting with Microsoft JDBC Driver for SQL Server version 10.2, the default setting of TLS encryption must be changed from false to true. For more information, refer to Changes in 10.2.

If the EcoSys server is not configured to use TLS encryption, the following error occurs when trying to start EcoSys:

ERROR Failed to set JDBC settings. com.ecosysmgmt.framework.exception.ESSystemException: Failed to get connection.; caused by --> Cannot create PoolableConnectionFactory (The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target".

To resolve this, you can use one of the following two options:

  1. Revert to prior JDBC behavior by setting encrypt=false in the JDBC URL.

    For example, url="jdbc:sqlserver://localhost:1433;database=esfm;encrypt=false"

  2. Configure the TLS encryption by following the steps from Microsoft.