Incorrect failure of masking job

Products

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

Issue/Introduction

Getting below error for masking job failure whereas there are no NULL records for the used seed columns.

2023-06-29 13:00:13.260 pool-4-thread-1 -  Message: Cannot insert the value NULL into column 'ComparisonValue', table 'RiskFactor_Common.dbo.W_CO_Watchlist_Criteria_Definition'; column does not allow nulls. UPDATE fails. 
2023-06-29 13:00:13.260 pool-4-thread-1 -  SQLSTATE: 23000 
2023-06-29 13:00:13.260 pool-4-thread-1 -  Error code: 515 

Environment

Release : 4.10

Resolution

The issue was with data in the specific seed list. After reloading the seed list data into Scramble DB, the masking started to work fine.