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
This was identified as an enhancement request because JSONB data type support was not included in the FDM design implementation.
Release : 4.9.1
Component : Fast Data Masker
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