Masking integer datatype with FORMATENCRYPT in Postgres database fails with NULL values

Products

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

Issue/Introduction

We are unable to mask column integer datatype with FORMATENCRYPT. 

This is an AWS hosted PostgreSQL database. When running the FDM 4.11.71.0 script, we get this error:

Message: Batch entry 0 update <schema>.<table> SET <column> = (NULL),de_ident_ind = ('S') WHERE "id" = ('1'::int8) AND de_ident_ind IS NULL was aborted: ERROR: column <column> is of type integer but expression is of type character varying
  Hint: You will need to rewrite or cast the expression.
  Position: 59  Call getNextException to see other errors in the batch. 

Environment

FDM 4.10.x through FDM 4.11.76.0

Resolution

A fix is provided in FastDataMasker-4.11.77.0 or greater.