Error while obfuscating the DB2 data using FDM
search cancel

Error while obfuscating the DB2 data using FDM

book

Article ID: 242879

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Trying to obfuscate the DB2 data using FDM tool using CASEINSENSITIVEHASHLOV=N to maintain case sensitivity in HASHLOV obfuscation. however, while performing the obfuscation,  getting an error message.

Please note, when setting default value (YES) in HASHLOV sensitivity, no error occurred.

Below the error message 

Use getNextException() to retrieve the exceptions for specific batched elements. ERRORCODE=-4229, SQLSTATE=null 
2022-05-11 13:37:19.854 Thread:Tablename -  SQLSTATE: null 
2022-05-11 13:37:19.854 Thread:Tablename -  Error code: -4229 
2022-05-11 13:37:19.854 Thread:Tablename - Next Message: Error for batch element #531: DB2 SQL Error: SQLCODE=-407, SQLSTATE=23502, SQLERRMC=*N;*N;Tablename;Schema;Fieldname   ;1;*N, DRIVER=4.18.60 
 

 

Environment

Release : 4.10

Component : FDM 4.10.x

Cause

N/A

Resolution

When inserting null entries to non null column in DB2 database, will get such errors. If fetching seed data from scramble database, make sure there are no null values in the scramble database.