FDM XML data masking not reflecting in Database

Products

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

Issue/Introduction

We are masking XML data in Fast Data Masker( 4.9.160.0). XML(Data Type is:xml) Data Masking is working fine in simulation mode but if DBUPDATES = Y , database if not getting updated.

 

Environment

Release : 4.9

Component : CA Test Data Manager - Others

Cause

Maksing rule was using FIXED function with below type of value:

<caseAudit version=2><case name=Fixed by GDPR></case></caseAudit>

Below message can be seen in the log file:

Thread:TableNameXML parsing: line 1, character 20, A string literal was expected 

Resolution

 

According to Microsoft specifications for XML data type, it's required that all attributes are enclosed in double quotes.

So you should use for example

<caseAudit version="2"><case name="Fixed by GDPR"></case></caseAudit>

instead of

<caseAudit version=2><case name=Fixed by GDPR></case></caseAudit>

It worked in simulation because the error is raised by the SQL Server so it failed only when FastDataMaker tried to update the table for real.