Error masking JSONB datatype in PostgreSQL

book

Article ID: 224049

calendar_today

Updated On:

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.

https://support.broadcom.com/external/content/release-announcements/Test-Data-Manager-TDM-Patches/16649

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

https://knowledge.broadcom.com/external/article?articleId=10931