Error while masking SQL DB using FDM

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Moved to the FDM latest version 4.10.71.0 from 4.9.0.0. however, our BAU scripts are getting failed with below error message 

Error message: 

2022-12-01 11:54:21.624 pool-4-thread-1 - java.lang.NullPointerException
 at com.grid_tools.products.datamasker.resolver.ResolverFunction.resolveFunction(ResolverFunction.java:703)
 at com.grid_tools.products.datamasker.resolver.ResolverFunction.resolveFunction(ResolverFunction.java:312)
 at com.grid_tools.products.datamasker.resolver.ResolverFunction.resolveFunction(ResolverFunction.java:162)
 at com.grid_tools.products.datamasker.SQLUpdate.batchPreparedMasking(SQLUpdate.java:4367)
 at com.grid_tools.products.datamasker.SQLUpdate.run(SQLUpdate.java:5605)
 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
 at java.lang.Thread.run(Thread.java:748)
 
2022-12-01 11:54:21.624 pool-4-thread-1 - exit value = 1 

Environment

Release : 4.10.54 and above

Cause

After major changed to the data validation in FDM 4.10.54, it is observed that FDM is not managing the in memory seed table properly.  The first time it works but the second access doesn't and gives null pointer exception.

 

Resolution

The fixed binaries are available at https://ftp.broadcom.com/user/downloads/pub/TDM/FDM/FastDataMasker-4.10.75.0.zip

Use below article to apply the patch build: 

How to apply patches for TDM