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

book

Article ID: 206054

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

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. 

Cause

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.

Environment

TDM Portal 4.9
FDM 4.9

Component : CA Test Data Manager

Resolution

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-4.9.136.0 available a:
https://support.broadcom.com/external/content/release-announcements/Test-Data-Manager-TDM-Patches/16649

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.