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.
This option is hidden.
In the latest version this can be changed to visable.
TDM Portal 4.9.X
FDM 4.9.X
Component : CA Test Data Manager - TDM Web Portal
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>
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