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

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

book

Article ID: 117962

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

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

Environment

TDM
Test Data Manager
FDM
Fast Data Masker

Resolution

FDM requires a primary key or a unique index so that an appropriate update statement can be generated with a where condition.