Masking Issue with Null Field - “Cannot update XXXX to NULL”

Products

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

Issue/Introduction

After masking Database on FDM4.10, tables/prescript/postscript are failing with error “Cannot update XXXX to NULL”. The field in question is defined as ‘Not Nullable’ in the database.

Didn’t face this issue in FDM 4.9 version.

 

Environment

FDM 4.10.1014.0

Cause

Configuration.

Resolution

Setting options EMPTYASNULL to N and BLANKASNULL to N resolved this issue.

When BLANKASNULL is set to Y, FDM will try to insert a NULL value if that row is blank. A general rule of thumb is to have BLANKASNULL and EMPTYASNULL set the same.

Additional Information

From documentation:

BLANKSASNULLS
Set to Y. For character data types, if the column contains blanks to the column width, treat as a null for keepnulls in the masking CSV.

EMPTYASNULL
Set to Y. For character data types, if the column contains a blank or spaces, treat as a null for keepnulls in the masking CSV.