TDM Portal masking fails to load custom seed list, and throws an 'ambiguous column' error.

Products

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

Issue/Introduction

We have a customized seed table 'GTSRC_REFERENCE_LOV1' under schema Scramble, and we would like to utilize the same for all the projects created. 

When running a test to mask a basic column (Varchar) that contains a company name, which we want to mask using rl_ref_value13, TDM throws the following error:

RL_REF_VALUE,RL_REF_VALUE2,RL_REF_VALUE3,RL_REF_VALUE4,RL_REF_VALUE5,RL_REF_VALUE6,RL_REF_VALUE7,RL_REF_VALUE8,RL_REF_VALUE9,RL_REF_VALUE10,
RL_REF_VALUE11,RL_REF_VALUE12,RL_REF_VALUE13,RL_REF_VALUE14,RL_REF_VALUE15,RL_REF_VALUE16,RL_REF_VALUE17,RL_REF_VALUE18,RL_REF_VALUE19,
RL_REF_VALUE20,RL_REF_VALUE21,RL_REF_VALUE22,RL_REF_VALUE23,RL_REF_VALUE24,RL_REF_VALUE25,RL_REF_VALUE26,RL_REF_VALUE27,RL_REF_VALUE28,
RL_REF_VALUE29,RL_REF_VALUE30,RL_RN,rl_rn from SCRAMBLE.GTSRC_REFERENCE_LOV1 where RL_REF_ID = <Seedlist Category Name> order by RL_RN ORA-00960: ambiguous column naming in select list Seed data category <Seedlist Category Name> has no entries

 

Portal Masking Configuration has:

• Connection profile = SCRAMBLE (oracle)
• Seedlist Table = GTSRC_REFERENCE_LOV1
• Seedlist Name Column = RL_REF_ID
• Seedlist Value Coulmns = RL_REF_VALUE through RL_REF_VALUE30
• Seedlist Index Column = RL_RN

Environment

TDM Portal  4.11.1007

FDM 4.11.159

Cause

FDM fails to load the custom seed list when running the masking job from TDM Portal, resulting in the ambiguous column name error.

Resolution

This has been resolved in FastDataMasker-4.11.176.0. Please upgrade to FDM version 4.11.176.0 or greater.

The latest TDM patches can be found at the Test Data Manager (TDM) Support Patches page.