Error DB2 masking - DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703
search cancel

Error DB2 masking - DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703


Article ID: 205561


Updated On:


CA Test Data Manager (Data Finder / Grid Tools)


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: 
2020-12-14 10:19:59.998 Fastdatamasker build date - December 8 2020 



Release : 4.9

Component : CA Test Data Manager

Resolution resolves this error.  Please contact BC Support to get this fix or a later version of FDM that contains this fix.