We are trying to obfuscate the DB2 data using FDM tool using CASEINSENSITIVEHASHLOV=N to maintain case sensitivity in HASHLOV obfuscation. however, while performing the obfuscation we are getting an error message.
Please note, when we set 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
Release : 4.10
Component : FDM 4.10.x
When you are inserting null entries to non null column in DB2 database, you will get such errors. If you are fetching seed data from scramble database, make sure there are no null values in the scramble database.