After partition of table, masking is not completed

Products

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

Issue/Introduction

During data masking for one of the table, we see mismatch in 'Masked XX of XXX' which is displayed on additional information under progress section.

The job has only one table in it. The table is partitioned table with 24 partition in it.

The partition type in Oracle was HASH partition on two columns however during masking we faced error as "ORA-14402: updating partition key column would cause a partition change " .

Environment

Release : 4.9

Component : Web Portal - Data Masking

Resolution

Do not use Oracle ROWID with the partitioned tables, that is option ORACLEUSEROWID should be disabled when masking such tables. Disable this option in options file and re-run the job to resolve the issue.