OL Learn

Error in SQL Server connection using JDBC in version 2022.1

Hi,

We’re just moving to new PresConnect 2022.1 and we’re having issue running a data mapper connecting to SQLServer. This is still ok running in ver 2020.

Data mapper engine is throwing back this error message below

Error while executing plugin: HTTP/1.1 500 Internal Server Error - An unspecified error occurred which was caused by LoggedApplicationException: There was an error running the data mapping process caused by ApplicationException: Error executing DM configuration: Wrapped com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: “The server selected protocol version TLS10 is not accepted by client preferences [TLS13, TLS12]”

Thanks

Hi,
This appears to be an issue with a recent update to Java 11, rather than something specific to Connect. The below link contains information on how to resolve this issue:

Best Regards

Justin Leigh

Thank Justin for response

I have followed that steps and I see this warning now in the log
[2022-08-16 13:17:55,712] WARN [IPC Input] com.microsoft.sqlserver.jdbc.internals.TDS.Channel.enableSSL(IOBuffer.java) TLSv1 was negotiated. Please update server and client to use TLSv1.2 at minimum.

But the command I’m executing with SQL is failing. I have tried to catch the error but it’s undefined
[2022-08-16 13:17:55,743] ERROR [IPC Input] com.objectiflune.scripting.engine.OLErrorReporter.processLogMessage(OLErrorReporter.java) [COMPONENT=Script logger][SOURCE=UploadGNA - line 122] Failed to upload GNA. undefined

Please note I’m calling the same stored procedure that works on older version

No worries now… Restarting the server do the trick. Thanks