FDM throws an eError when masking a 8+ digit float before decimal on SQL Server
search cancel

FDM throws an eError when masking a 8+ digit float before decimal on SQL Server

book

Article ID: 259688

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

We're getting the following error when trying to mask a 8+ digit before decimal FLOAT field using FPE1EXT

Message: Error converting data type varchar to float.

The float value is '81725710'.

This issue doesn't happen when masking float values with 7 or fewer digits before the decimal. Adding or removing decimal values does not impact the masking attempt's success (E.G. masking 1234567.11111 will work. 12345678.1 will not)

 

Environment

Release : 4.10

Cause

The problem is how FDM handles the usage of exponents (E), which we mask as part of the input.

Resolution

 This is resolved in FastDataMasker-4.10.82.0.