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.

Using CONCAT with characters % causing attempted use of environment variable


Article ID: 237716


Updated On:


CA Test Data Manager (Data Finder / Grid Tools)


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.




Release : 4.9.1

Component : Fast Data Masker

Resolution,  fixes the issue.