Masking error: "supplied input function is not a supported scrambling function"

Products

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

Issue/Introduction

In one of our team's projects, they are using FormatEncrypt1 with a specific Pass Phrase, and it throws this error, "supplied input function is not a supported scrambling function". 

Environment

Release : 4.9

Component : Web Portal - Data Masking

Cause

 In the TDM Portal TDMMaskingService log, we see the following error:

fdm#: 1: schema: <hostname.domain>.EDI: launching fdm. csv: fdm_mask_CP_EDI_DEV_R_<hostname.domain>_EDI_dbo.csv

collectMetrics: fdm#: 1 metrics: {"TABLE_METRICS":"{}","jobState":"FAILED","totalRows":"0","rowsMasked":"0","errors":"supplied input function <function_name>  is not a supported scrambling function"}

The error is thrown because the CSV file fdm_mask_CP_EDI_DEV_R_<hostname.domain>_EDI_dbo.csv contains an empty function, which is why the error message does not show the function name that is causing the problem.

Looking at fdm_mask_CP_EDI_DEV_R_<hostname.domain>_EDI_dbo.csv, we see the file contains extra cells that is throwing everything off, between lines 14-27. 

Resolution

 

The CSV file is corrupt. One option would be to have FDM generate a new CSV with the correct function. Another would be to manually correct the CSV file.