When I start a DB2 masking for some reason, there is a check of the row count and there is an error with the query sent.
This query is sent : 2020-12-14 10:20:01.857 SQL For Test: select count(*) from "EADM_TEST"."CAS_036" where "de_ident_ind" is null
You can see the column de_indent_ind is between a double quote and is in lower case. In the database the column is in capital letter.
The error I get is 2020-12-14 10:20:01.857 Error returned from Database Errse:DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703, SQLERRMC=de_ident_ind, DRIVER=4.24.92
It can't find the column name because in a database the columns are case sensitive.
The query sent by FDM is wrong.
I tried on Oracle and there is no query executed.
2020-12-14 10:19:59.982 Fastdatamasker version: 184.108.40.206
2020-12-14 10:19:59.998 Fastdatamasker build date - December 8 2020
Release : 4.9
Component : CA Test Data Manager
FastDataMasker-220.127.116.11.zip resolves this error. Please contact BC Support to get this fix or a later version of FDM that contains this fix.