FDM XML data masking not reflecting in Database
search cancel

FDM XML data masking not reflecting in Database


Article ID: 216175


Updated On:


CA Test Data Manager (Data Finder / Grid Tools)


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



Release : 4.9

Component : CA Test Data Manager - Others


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 



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.