CA TDM Fast Data Masker is getting an error is throwing the syntax error


Article ID: 206054


Updated On:


CA Test Data Manager (Data Finder / Grid Tools)


To overcome the issue of out of memory, I try to specify the where condition(filter condition) in the mappings, It worked for one table which has a primary key defined on it.

But I am trying the same approach for other tables, it is throwing the syntax error. 

I am not understanding what is wrong here.
As I have tried to do the same way as the first table. 


This is a problem with the JDBC Driver where it adds a WHERE clause on a query for tables that do not have a primary key defined.


TDM Portal 4.9
FDM 4.9

Component : CA Test Data Manager


Unfortunately, we found out that it's a Postgres JDBC driver issue.
( the client may want to have their DBA open a support case with the database vendor to get this corrected)

when the table doesn't have primary keys it'll create the query with a dangling WHERE keyword
(which causes syntax error when executed).

We prepared modified binaries FastDataMasker- available a:

The only change is that the masking will abort with an explanation message when such a situation is detected.

If you have any questions or concerns please let me know.