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]”
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:
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