FDM Fails to mask table that doesn't have a primary key or unique index

Document ID : KB000117962
Last Modified Date : 22/10/2018
Show Technical Document Details
Issue:
FastDataMasker (FDM) fails to mask table that doesn't have a primary key or unique index. The following can be found in the log:
 
>2018-10-15 12:04:33.038 Table TABLE has no unique columns defined
>2018-10-15 12:04:33.054 Updating may be unreliable and take a long time
>2018-10-15 12:04:33.538 No primary key found for table "SCHEMA"."TABLE".
>2018-10-15 12:04:33.538 exit value = 1
Resolution:
FDM requires a primary key or a unique index so that an appropriate update statement can be generated with a where condition.