ODI 11g Connection to MSSQL Server Through JDBC Driver Randomly Fails with Error "ODI-1228" And "Caused By: java.sql.SQLException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption" (Doc ID 2232680.1)

Last updated on FEBRUARY 16, 2017

Applies to:

Oracle Data Integrator - Version 11.1.1.9.0 to 11.1.1.9.99 [Release 11gR1]
Information in this document applies to any platform.

Symptoms

In ODI 11.1.1.9.0 version, executing a scenario which performs a connection to MSSQL Server through  JDBC driver faces random failures with the error below:

 

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms