Issue with Data Masking for Partitioned table
search cancel

Issue with Data Masking for Partitioned table


Article ID: 234201


Updated On:


CA Test Data Manager (Data Finder / Grid Tools)


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.


Release : 4.9

Component : Web Portal - Data Masking


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

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