TDM Portal encounters an error "load authentication DLL mssql-jdbc_auth-12.6.1.x64" error when attempting to execute data masking in preview mode.
Article ID: 395859
Updated On:
Products
Issue/Introduction
After upgrading our main server, FDM was updated to version 4.11.163.0 and TDM Web to version 4.10.268.0. However, we are encountering an error when attempting to run masking jobs in preview mode. Testing with the backend FDM shows that it operates correctly.
In contrast, our test server, which runs the same versions and includes identical DLLs, is functioning without issues.
Environment
TDM Portal 4.10.268.0
FastDataMasker (FDM) 4.11.163.0
Cause
TDM Portal 4.10.268.0 uses an older version of the mssql-jdbc_auth driver (mssql-jdbc_auth-12.2.0.x64.dll), and FDM 4.11.163.0 uses a newer release of the driver (mssql-jdbc_auth-12.6.1.x64.dll) When executing the masking job from TDM Portal, the JRE instance is unable to locate the mssql-jdbc_auth-12.6.1.x64.dll file. Therefore, we see the following error in the TDMMaskingService log:
c.c.t.f.c.JobEngine: sendStatus: jobId: <JobID>: sending to job engine: status: FAILED info: (1) <hostname>_<database>_dbo: Connection error
java.sql.SQLException: Error during opening connection: null
...
...
Caused by: java.security.PrivilegedActionException: com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication.
...
...
Caused by: java.lang.UnsatisfiedLinkError: Unable to load authentication DLL mssql-jdbc_auth-12.6.1.x64
Resolution
To troubleshoot the issue, use Microsoft's SysInternal's ProcessMonitor (ProcMon) utility to determine where the system is looking to find the missing driver.
In most cases, the following steps will help resolve this issue:
- Open a file explorer and go to the C:\Program Files\Grid-Tools\FastDataMasker\SQLSERVER_DLLs\x64 directory.
- Make a copy of the mssql-jdbc_auth-12.6.1.x64.dll file.
- Place the copy of the mssql-jdbc_auth-12.6.1.x64.dll inside the C:\Program Files\Grid-Tools\FastDataMasker\jre\bin directory
- Test to see if this corrects your issue.
If the problem persists, then use the ProcMon utility to determine the path your system is wanting to use.
As an alternative solution, place a copy of the mssql-jdbc_auth-12.6.1.x64.dll file in a location known by the System PATH environment variable.
Additional Information
As a reminder, anytime TDM Portal is upgraded, the CA Test Data Manager Portal service and the OrientDB service are deleted and recreated. Therefore, the CA Test Data Manager Portal service must be reconfigured to start up under the Windows account used for integrated security.
Feedback
