Jitterbit · Database connector (SQL Server MS JDBC)

SQL Server: PKIX path building failed

Short answer

This Jitterbit SQL Server error means the JDBC driver requested encryption and could not trace the server certificate to a certificate authority the agent trusts. In the Database connection's Optional Settings, add encrypt=false; to the Additional Connection String Parameters field, or include it in a manual connection string.

VerifiedLast verified

01Error text

Jitterbit error
PKIX path building failed: unable to find valid certification path to requested target.

02Likely causes

  • Current SQL Server MS JDBC drivers request encryption by default and validate the server certificate. The connection fails when the certificate is self-signed, internally issued or otherwise not trusted by the agent.
  • Agent 12.8 updated the bundled driver to request encryption by default, so a connection that worked before the upgrade can fail after it.

03How to fix it

  1. In the Database connection's Optional Settings, add encrypt=false; to the Additional Connection String Parameters field, or include it in a manual connection string.

iNotes

With encrypt=false, data travels unencrypted between the agent and the database, so use it only where that is acceptable.

04Official documentation

Test every fix in a non-production environment before you apply it to production. See how entries are verified.

More for Jitterbit work:Open Jitterbit jobsJitterbit rates and salaries

The iPaaS Brief

Subscribe to The iPaaS Brief.

The iPaaS newsletter for the people who run integrations. From iPaaS Group.

Free. You finish on theipaasbrief.com and confirm by email.