search cancel

SQL Server Table Column Name is not getting obfuscated when Column Name contains Space

book

Article ID: 201626

calendar_today

Updated On:

Products

CA Continuous Application Insight (PathFinder)

Issue/Introduction

SQL Server Table Column Name is not getting obfuscated when Column Name contains Space, example as 'Borrower Name' . We have tried in latest FDM version 4.9.104.0 

Below is the error message

2020-10-08 14:17:34.990 Thread:TABLENAME - Error executing select statement for update 
2020-10-08 14:17:34.993 Thread:TABLENAME - Invalid column name 'Borrower'. 

Environment

Release : 4.9

Component : CA Continuous Application Insight

Resolution

Support is not able to reproduce . This should work because FDM should enclose the column name into [ and ] so for example [Borrower Name]. But try to increase diagnose level, it should start to print queries into the database (if it contains [ and ]).
Development could reproduce this and it is fixed in this product version FastDataMasker-4.9.108.0.