Fill Masking Function issue in FDM

Products

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

Issue/Introduction

We have column data type as XML in one of our application table, we tried to update that entire XML column with Generic XML using FILL masking function in FDM.

After executing the masking job in FDM, the Job is getting executed successfully. However, when we checked in SQL server the column values are null.

 

Environment

Release : 4.8

Component : CA Test Data Manager
DB: SQL Server
Column Data Type: XML

Resolution

Masking function "FILL" applies to Numbers and character column types. So, we can not apply FILL function here.
Use "FIXED" masking function to resolve this issue.