FDM (Fast Data Masker) - MSSQL : connection error

Document ID : KB000006790
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

We are having an issue of connection when we are masking with MSSQL  The problem happens from time to time. We have not found a consistent pattern of when the issue occurs.  This morning we ran the process, and it worked. An hour later we got this issue (as described in the following log snippet).  We have the issue in both of our DEV and PROD systems.   We are running FDM version : 4.6.300.11R.

<<Scrubbed log>>
Fastdatamasker version: 4.6.300.11R 
Fastdatamasker build date - 10 FEBRUARY 2017 
PID:<<NUMBER>>@<<ID>> 
Java version 1.8.0_91 
OPERATING SYSTEM USER: <<USER_NAME>> 
************************ 
Checking license 
Valid license key found 
LICENSE DETAILS 
License Type: FULL 
Company Name: <<COMPANY_NAME>> 
Site Id: <<SITE_ID>> 
Product Id: TDMMAS990 
Valid to: 06-29-2019 
************************ 
attempting to connect 
Using URL:jdbc:sqlserver://<<FULLY_QUALIFIED_COMPUTER_NAME>>;instanceName=<<INST_NAME>>;DatabaseName=<<DB_NAME>> 
connecting with driver:com.microsoft.sqlserver.jdbc.SQLServerDriver 
Using URL:jdbc:sqlserver://<<FULLY_QUALIFIED_COMPUTER_NAME>>;instanceName=<<INST_NAME>>;DatabaseName=<<DB_NAME>>;integratedSecurity=true; 
Connected to jdbc:sqlserver://<<FULLY_QUALIFIED_COMPUTER_NAME>>;instanceName=<<INST_NAME>>;DatabaseName=<<DB_NAME>>;integratedSecurity=true; 
readfile start 
loadProfile start 
attempting to connect 
Using URL:jdbc:oracle:thin:@(DESCRIPTION= (ADDRESS=(PROTOCOL=TCP)(HOST=<<LB_SQL_SVR_FULLY_QUALIFIED_NAME>>) (PORT=1521)) (LOAD_BALANCE=yes)(CONNECT_DATA=(SERVER = DEDICATED)(SERVICE_NAME=<<SERVICE_NAME>>)(FAILOVER_MODE = (TYPE = SELECT)(METHOD = BASIC)(RETRIES = <<LOTS>>)(DELAY = <<NUMBER>>)))) 
connecting with driver:oracle.jdbc.driver.OracleDriver 
Using URL:jdbc:oracle:thin:@(DESCRIPTION= (ADDRESS=(PROTOCOL=TCP)(HOST=<<LB_SQL_SVR_FULLY_QUALIFIED_NAME>>) (PORT=1521)) (LOAD_BALANCE=yes)(CONNECT_DATA=(SERVER = DEDICATED)(SERVICE_NAME=<<SERVICE_NAME>>)(FAILOVER_MODE = (TYPE = SELECT)(METHOD = BASIC)(RETRIES = <<LOTS>>)(DELAY = <<NUMBER>>)))) 
Connected to jdbc:oracle:thin:@(DESCRIPTION= (ADDRESS=(PROTOCOL=TCP)(HOST=<<LB_SQL_SVR_FULLY_QUALIFIED_NAME>>) (PORT=1521)) (LOAD_BALANCE=yes)(CONNECT_DATA=(SERVER = DEDICATED)(SERVICE_NAME=<<SERVICE_NAME>>)(FAILOVER_MODE = (TYPE = SELECT)(METHOD = BASIC)(RETRIES = <<LOTS>>)(DELAY = <<NUMBER>>)))) username:scramble 
OPTIONS 
Using commit frequency of: 100000 
Populating connection pool.. 
connecting with driver:com.microsoft.sqlserver.jdbc.SQLServerDriver 
Using URL:jdbc:sqlserver://<<FULLY_QUALIFIED_COMPUTER_NAME>>;instanceName=<<INST_NAME>>;DatabaseName=<<DB_NAME>>;integratedSecurity=true;;integratedSecurity=true; 
Connection Error:The driver could not establish a secure connection to the SQL Server upon using SSL (Secure Sockets Layer) encryption. Error: "the SQL Server has returned an incomplete answer. The con ».

Environment:
MS SQLTDM 4.0
Cause:

sqljdbc_auth.dll is not in the same folder as the .bat file was located.

Resolution:

Put (copy) sqljdbc_auth.dll in your windows/system32 folder.  This will allow it to be found by the system regardless of where your .bat file is located.