search cancel

TDM Portal Masking fails with Parm 2 value greater than number of seed columns error

book

Article ID: 241197

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

We are unable to run executing the masking in TDM Portal and getting an error as below

SUBSET.SYSADM: parm 2 value greater than number of seed columns

But if we download the same files and run it directly in FDM then it is working fine. We don't understand why the error is thrown since the table containing the seed data has 9 columns defined.

Cause

After reviewing the configuration, and more specifically the masking options, we noticed that the SEEDTABLECOLUMNS = rd_ref_id,rd_ref_value therefore Portal only uses these two columns and ignores all others. Thus, the error, since 4 > 2. If the column is not listed in SEEDTABLECOLUMNS option, then such column doesn't exist for Portal/FDM (and is not counted).

Environment

Release : 4.10

Component : Web Portal - Data Masking

Resolution

To correct this set the Portal masking options; SEEDTABLECOLUMNS=rd_ref_id,rd_ref_value,rd_ref_value_2,rd_ref_value_3,rd_ref_value_4,rd_ref_value_5,rd_ref_value_6,rd_ref_value_7,rd_ref_value_8,rd_ref_value_9

This should correct the issue. If there are similar issues in the future, a good troubleshooting tip is to compare the FDM Masking options, since FDM is able to successfully run the job, to the Portal Masking options to find the difference.

 

Additional Information

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