search cancel

Fill Masking Function issue in FDM

book

Article ID: 188414

calendar_today

Updated On:

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.