The issue affects the following Delphix Releases with Masking service enabled:
Delphix Engine 188.8.131.52
Delphix Engine 184.108.40.206 and 220.127.116.11
Delphix Engine 18.104.22.168
Delphix Engine 22.214.171.124 and 126.96.36.199
Delphix Engine 188.8.131.52 and 184.108.40.206
Unmasked data will be in the database after a masking job completes without reporting an error when a numeric Segment Mapping (SM) algorithm is applied to data shorter than the algorithm’s defined length. (e.g., mask a 10 digit value with a 16 digit numeric SM algorithm).
Any input value that is shorter than the number SM algorithm’s defined lengths will escape unmasked from the algorithm and will appear in the output.
Delphix highly recommends upgrading to version 220.127.116.11 or later. If that is not possible, the below workaround can be used. For each numeric segment mapping algorithm, the Masking Engine administrator can perform all the following steps:
Create an alphanumeric SM algorithm with the same configuration as the numeric algorithm.
For each Inventory column/field where the numeric SM algorithm is assigned, replace it with the alphanumeric SM algorithm created in the previous step.
For each Domain where the alphanumeric SM algorithm is assigned, replace it with the numeric SM algorithm created in the first step.
This issue has been fully resolved in the Delphix Engine 18.104.22.168 release.