FDM SQLFUNCTION incorrect results


Article ID: 102446


Updated On:


CA Test Data Manager (Data Finder / Grid Tools)


The FDM rule SQLFUNCTION seems to add some random spaces when USEMASKEDVALUES is checked. 
in the Function SQL, If there is a REGEXP_REPLACE and USEDMASKEDVALUES is checked then FDM seems to add spaces in the function resulting in incorrect results. 

Eg: If the function is "CONCAT(CONCAT(substr(REGEXP_REPLACE('3106839366', '[^0-9]', ''),1,3),'555'),substr(REGEXP_REPLACE('3106839366', '[^0-9]', ''),7,4) )" AND USEDMASKEDVALUES = "Y" then the result obtained in FDM is "9555". 
This is Equivalent of "CONCAT(CONCAT(substr(REGEXP_REPLACE('3106839366', '[^ 0 - 9] ', ''),1,3),'555'),substr(REGEXP_REPLACE('3106839366', '[^ 0 - 9 ]', ''),7,4) )" 
[ Note: Extra spaces in the squared brackets ] 

If the function is "CONCAT(CONCAT(substr(REGEXP_REPLACE('3106839366', '[^0-9]', ''),1,3),'555'),substr(REGEXP_REPLACE('3106839366', '[^0-9]', ''),7,4) )" AND USEDMASKEDVALUES = "N" then the result obtained in FDM is "3105559366". 

As per docops - USEMASKEDVALUES: If Use Masked Values=Y (default=N), then columns specified in SQLFUNCTION are tested to see whether they have been masked earlier in the mapping. If so, the masked value is used. 

But the output doesn't seem to match the documentation. In this FDM run the column is masked only once and the output obtained doesn't seem to be used again within the function. Upon some deep analysis we can see that FDM is adding spaces to the REGEX_REPLACE within the squared brackets.


TDM 4.5


The version FastDataMasker-4.7.434.0.zip resolves this issue.  Please contact CA Support for this or a later version.  If you are installing a GA version after June 15, 2018, please contact CA Support to make sure that this fix has been incorporated into your GA.

Additional Information

Video URL on how to open a Support Case - https://communities.ca.com/videos/5898-demo-how-to-open-a-support-case

You can download the latest version of TDM by following the directions in this document: https://support.ca.com/us/knowledge-base-articles.TEC1903942.html.   

To contact support, go to https://www.ca.com/us/services-support/ca-support/contact-support.html