FDM error while masking a large table: The MIN function requires 1 argument(s).

Products

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

Issue/Introduction

Fast Data Masker version: 4.9.174.0  :

Getting Error while masking a large table using LARGETABLESPLITENABLED=Y

2021-06-29 09:50:03.720 Using commit frequency of: 10000 
2021-06-29 09:50:03.736 Connected to jdbc:sqlserver://YYYYYY;instanceName=XXXXXX;DatabaseName=ZZZZ 
2021-06-29 09:50:03.736 Database Major Version:15 
2021-06-29 09:50:03.736 Database Minor Version:0 
2021-06-29 09:50:04.126 The MIN function requires 1 argument(s). 
2021-06-29 09:50:04.142 exit value = 1 

OPTIONS

************************* 

COMMIT=10000
EMPTYASNULL=Y
ERRORDIR=C:\Users\username\AppData\Roaming\Grid-Tools\FastDataMasker\CADefect\Directory
GETTABLEROWCOUNTS=N
LARGETABLESPLITENABLED=Y
LOGDIR=C:\Users\username\AppData\Roaming\Grid-Tools\FastDataMasker\CADefect\Directory
PARALLEL=2
TRIMVALUES=Y 

Environment

Release : 4.9

Component : CA Test Data Manager - Fast Data Masker

Cause

This issue caused due to a bug introduced while further improving performance of masking with LARGETABLESPLITENABLED option.

Resolution

FastDataMasker-4.9.176.0.zip or later

Available from: TDM Support Patches

Use FDM section of below article to apply the patch:

https://knowledge.broadcom.com/external/article?articleId=10931