CA TDM Portal - BADDATESTRING option not there

Products

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

Issue/Introduction

Hi,

I have to mask some DOB columns which are in VARCHAR format. It is failing due to some bad values of 0. 

In windows version, I used to put BADDATESTRING=0 in options tab to handle such scenarios. However, I do not see this option in CA Portal due to which my database masking is on hold currently.

Note: I cannot use windows since I need to mask billions of records.

Can you please suggest some solution asap? I need to finish this DB masking by end of this week.

Cause

 

This option is hidden.
In the latest version this can be changed to visable.

Environment

 

TDM Portal  4.9.X
FDM 4.9.X

Component : CA Test Data Manager - TDM Web Portal

Resolution

 

 

Once you update to the latest version of TDM Portal and FDM

You will need to do the following:
You need to modify conf\\fdm-config.xml inside Portal installation directory (if they are using remote masking) or/and config.xml inside FastDataMasker installation directory.

Look for BADDATESTRING option and change the value inside <hidden> element to false.
Then restart the service - after that this option should be visible in the masking settings in Portal.

example:
C:\Program Files\CA\CA Test Data Manager Portal\conf\fdm-config.xml

<?xml version="1.0" encoding="UTF-8"?>
<configuration>
 <locale>
  <language>en</language>
  <country>US</country>
  <variant></variant>
  <font>Arial</font>
 </locale>

....

  <option>
   <id>10</id>
   <name>BADDATESTRING</name>
   <description>for DOB, DOD on dates stored in character fields specify the date to replace the un parsable date with - for example 19900101</description>
   <char>true</char>
   <boolean>false</boolean>
   <numeric>true</numeric>
   <hidden>true</hidden> (Change to False)
   <values></values>
  </option>

example:
C:\Program Files\Grid-Tools\FastDataMasker\config.xml

<?xml version="1.0" encoding="UTF-8"?>
<configuration>
 <locale>
  <language>en</language>
  <country>US</country>
  <variant></variant>
  <font>Arial</font>
 </locale>

......

  <option>
   <id>10</id>
   <name>BADDATESTRING</name>
   <description>for DOB, DOD on dates stored in character fields specify the date to replace the un parsable date with - for example 19900101</description>
   <char>true</char>
   <boolean>false</boolean>
   <numeric>true</numeric>
   <hidden>true</hidden> (Change to False)
   <values></values>
  </option>

Additional Information

 

 

The latest patches can be found here:
https://support.broadcom.com/external/content/release-announcements/Test-Data-Manager-TDM-Patches/16649

 

For Docker installations:

docker exec -it <name-of-container> bash 

find / -iname fdm-config.xml in container bash
(verify path to /opt/tdm/conf/fdm-config.xml)

docker cp <containerId>:/opt/tdm/conf/fdm-config.xml ./

edit the fdm-config.xml and make changes as needed.

docker cp  ./fdm-config.xml <containerId>:/opt/tdm/conf/fdm-config.xml