Issue in FDM - HASHLOV1

book

Article ID: 186206

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

FDM is throwing below error for HASHLOV1 masking function.

"Error preparing select statement for cross reference select 

"RD_INDEX": invalid identifier"

Attached is the db scripts, masking csv, options file and log file.

FDM version is 4.8.162.0. This used to work in FDM 4.8.126  

Environment

Release : 4.8

Component : CA Test Data Manager

Resolution

You should create a column of type number and for each rd_ref_id category the index starts from 1 and increments.

if you create an index on that column that would improve performance.

it would easier if the column is called RD_INDEX

Since this is the GTREP database, this required a change to FDM: Content: patch FastDataMasker-4.9.50.0.zip can be used to allow FDM hashlov to use gtrep_reference_data table