search cancel

Masking job stuck, getting Access Denied in the logs

book

Article ID: 239110

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

when I try to run a masking job, it gets stuck and doesn't write anything. Database is a SQL server and the TDM user is db owner.

here is the error logs we see 

2022-04-08 16:47:20.688 SQLSERVERJDBC.LOG (Access is denied) 
java.io.FileNotFoundException: SQLSERVERJDBC.LOG (Access is denied)
 at java.io.FileOutputStream.open0(Native Method)
 at java.io.FileOutputStream.open(FileOutputStream.java:270)
 at java.io.FileOutputStream.<init>(FileOutputStream.java:213)
 at java.io.FileOutputStream.<init>(FileOutputStream.java:101)
 at java.io.PrintWriter.<init>(PrintWriter.java:184)
 at com.grid_tools.products.datamasker.db.connection.SQLServerDriverConnectionProcessor.getConnection(SQLServerDriverConnectionProcessor.java:41)
 at com.grid_tools.products.datamasker.DBUtils.performLogon(DBUtils.java:169)
 at com.grid_tools.products.datamasker.DBUtils.<init>(DBUtils.java:144)
 at com.grid_tools.products.datamasker.DBUtils.<init>(DBUtils.java:104)
 at com.grid_tools.products.datamasker.masking.dbmasking.DBMasker.doDBMasking(DBMasker.java:1156)
 at com.grid_tools.products.datamasker.Datamasker.main(Datamasker.java:1304)

Cause

 user access privileges for file creation or writing to a specific location. 

Environment

Release : 4.9

Component :

Resolution

This issue might be caused by user access privileges for file creation or writing to a specific location.  please check permissions for the following location

C:\Program Files\Grid-Tools\FastDataMasker\SQLSERVERJDBC.LOG   or the location where FDM is installed.