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".
Release : 4.9
Component : Web Portal - Data Masking
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.
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.