search cancel

Masking data with HASHLOV is leaving non-masked values as NULL.

book

Article ID: 42213

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Issue: 

For Name and address fields we are using the HASHLOV function to mask the data consistently. 

But when the masking is completed, the unmasked data is getting replaced with NULL values.

 

Environment:  

Fast Data Masker to mask the Oracle database

 

Cause: 

1. CSV file 
Table,Column,Function,Parm1,Parm2,Parm3,Parm4,KeepNulls,DateFormat,Cross Reference,Override SQL,Unique Columns,Xpath Element,Substr start,Substr length,Notes,Preformat,update,Use Masked Values,restart column 
DEMO_Description,,WHERE,VIIN_ID<5,,,,,,,,,,,,,,,, 
DEMO_Description,Description,HASHLOV,LASTNAME,6,,,N,,,,,,,,,,,, 
DEMO_Description,BUNDLE_ID,HASHLOV,ADDRESS1,6,,,N,,,,,,,,,,,, 

2. When masking job is run, the Lastname and Address1 are set to NULL. 

 

Resolution:

1. Reproduced the error using the supplied DLL and csv file 
2. Noted that on the DEMO_Description,Description,HASHLOV,LASTNAME,6,,,N,,,,,,,,,,,, 
Line that the number 6 indicates the column in the Seedlist to use. 
3. Noted that on the DEMO_Description,BUNDLE_ID,HASHLOV,ADDRESS1,6,,,N,,,,,,,,,,,, 
Line that the number 6 indicates the column in the Seedlist to use. 
4. In both cases, column 6 is NULL. 
5. Changing this Parameter from 6 to a 1 or leaving it blank caused the masking to work correctly. 


NOTE: 
***************************** 
Using the Parameter to point to the correct column in the seed table will resolve this issue. If it is pointed to an incorrect column, it will cause this type of error to occur.

 

Environment

Release:
Component: ITKOGT