Error masking JSONB datatype in PostgreSQL

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Trying to mask table in PostgreSQL database. The cloumn being masked is a JSONB datatype, and FDM  fails to mask this information with jsonb data type.

This issue happens only with DBUPATES = Y when it tries to update the DB and fails with below error

Error message:

>202?-09-03 18:12:57.173 Thread:TestTableBatch entry 0 update "public"."TestTable" SET "TestColumn" = '{"Attr1":"XXXXX","Attr2":"XXXXX","Attr3":"XXXXX","Attr4":"XXXXX"}' WHERE "Attr5" = 'XXXXX'::uuid was aborted: ERROR: column "TestColumn" is of type jsonb but expression is of type character varying
>  Hint: You will need to rewrite or cast the expression.
>  Position: 48  Call getNextException to see other errors in the batch. 
>202?-09-03 18:12:57.173 Thread:TestTableERROR: column "TestCloumn" is of type jsonb but expression is of type character varying
>  Hint: You will need to rewrite or cast the expression.
>  Position: 48 
>202?-09-03 18:12:57.173 Thread:TestTable - Table causing error:TestTable

Cause

This was identified as an enhancement request because JSONB data type support was not included in the FDM design implementation. 

Environment

Release : 4.9.1

Component : Fast Data Masker

Resolution

The Patch build FDM 4.9.197 is available at below page with a fix to the reported issue.

TDM Support Patches

Follow below article's FDM section to apply the patch build.

How to apply patches for TDM and ARD components