Issue with Data Masking for Partitioned table

Products

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

Issue/Introduction

During data masking of partitioned table, we see that TDM portal is trying to mask more data than actual count of the table.

Here we have one table which is having total volume of 675578170 (675 millions) which is split across 24 partitions and we just have one column to mask for this table.

Now initially during masking we faced error as "ORA-14402: updating partition key column would cause a partition change". Following which the DBA allowed value dispersal across partitions and we re-ran the masking.

Environment

Release : 4.9

Component : Web Portal - Data Masking

Resolution

 Patch for this issue is created for FDM. Please download latest FDM installer from below link

https://support.broadcom.com/web/ecx/support-content-notification/-/external/content/release-announcements/Test-Data-Manager-TDM-Patches/16649

In this patch, options RESTART and UNIQUERESTARTCOLUMNS must be enabled to properly avoid masking one row multiple times and possible duplicates.