ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Issue in FDM - HASHLOV1


Article ID: 186206


Updated On:


CA Test Data Manager (Data Finder / Grid Tools)


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 This used to work in FDM 4.8.126  


Release : 4.8

Component : CA Test Data Manager


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 can be used to allow FDM hashlov to use gtrep_reference_data table