IBM Support

Microsoft SQL JDBC driver connection error unable to find valid certification path to requested target for IBM Content Navigator Pod

Question & Answer


Question

We are installing Cloud Pak for Business Automation(CP4BA) 21.0.3 ifix012, and found IBM Content Navigator(ICN) Pod is always under not ready state, in the messages.log of ICN, we can see the following error indicating Microsoft SQL(MS SQL) JDBC driver connection failure:
0000003b SystemOut O CIWEB_SYNC Error: [ @ ] com.ibm.ecm.sync.WebAppListener.contextInitialized()
java.sql.SQLException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "com.ibm.jsse2.util.j: PKIX path building failed: com.ibm.security.cert.IBMCertPathBuilderException: unable to find valid certification path to requested target". ClientConnectionId:4c6dbd29-d603-4128-8b65-c9d6bd5e7e1d DSRA0010E: SQL State = 08S01, Error Code = 0
at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:3806)
at com.microsoft.sqlserver.jdbc.TDSChannel.enableSSL(IOBuffer.java:1906)
As confirmed with MS SQL DBA, the database server is not configured as SSL port to external application.
Please help us to fix the issue.

[{"Type":"MASTER","Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSBYVB","label":"IBM Cloud Pak for Business Automation"},"ARM Category":[{"code":"a8m0z0000001iUBAAY","label":"Use-\u003EFNCM App Usage"}],"ARM Case Number":"TS010408315","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"21.0.3"}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
29 September 2022

UID

ibm16825083