search cancel

Using CONCAT with characters % causing attempted use of environment variable

book

Article ID: 237716

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

While masking data in an Oracle DB, we encountered a scenario where multiple capital letters with French accents are causing FDM to attempt to retrieve an environmental variable. The French characters are being stored as '%Ex' where x is a number 0-9. A combination of 2 or more results in a scenario where you can have 2 French accents in a field which causes FDM/Java to think it has an environmental variable. i.e. a value encapsulated by "%'s".

eg. résumé results in "r%e9sum%e9" and "%e9sum%" is treated as an environmental variable.

Cause

N/A

Environment

Release : 4.9.1

Component : Fast Data Masker

Resolution

FastDataMasker-4.10.3.0.zip,  fixes the issue.