FORMATDECRYPT1 Masking function is not working expected

Products

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

Issue/Introduction

TDM Portal version: 4.10.56

Fields masked in one of the previous versions of Portal using FORMATENCRYPT with a key can not be reverted to the previous state using FORMATDECRYPT1 and the same key.

Our database backup file got corrupted, and we were trying to bring original copy of database from masked copy and end result is not matching actual unmasked value.

Environment

Release : 4.10

Component : TDM Web Portal

Resolution

FORMATDECRYPT1

Decrypts a string encrypted using the FORMATENCRYPT1 masking function and the respective parameters used during encryption. The values of Parm1 to Parm4 must be the same as the values that were used for encryption with FORMATENCRYPT1.

 

See https://techdocs.broadcom.com/us/en/ca-enterprise-software/devops/test-data-management/4-10/reference/masking-functions-and-parameters.html

TDM does not provide a decrypt function that works with the FORMATENCRYPT masking function. Therefore, if the fields were originally masked using FORMATENCRYPT, this is why they are seeing a discrepancy when using FORMATDECRYPT1 to decrypt the values.