In FDM, getting error for Where clause when there are characters

book

Article ID: 140612

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

We are getting error while using WHERE condition in FDM. 

ERROR:

    Mismatched types: in the 'WHERE' clause, the type of values (Number) in the specified column do not match the type of the specified comparison value. 
2019-11-19 23:08:16.419 Value to compare:'INAB090' 

For any masking functions, if we use WHERE clause like account_id= 'INAB090'  is not working.

but for numbers, if we use like, WHERE account_id=101898 conditions are working fine.

Environment

Release : 4.8

Component : CA Test Data Manager

Resolution

This issue has been identified as a defect. Please raise a support case and get the fix for defect# DE439819