TDM: Import of GT-EXCEL File Works but Import of Data File fails in TDM Portal, yet Import Works in Datamaker.

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

 

It's one of the generic messages here is what is interesting It loaded most of the tables except for the last few, and it works in DataMaker, so I think there is a parsing error in Portal. Again I tested in 4.9.248 and 4.9.81, and I see the same result. Below shows that last 3 table didn't get loaded using Portal and then below is the DataMaker loaded generator.

 

Using Datamaker it loaded all the tables

Environment

Release : 4.9

Component : CA Test Data Manager

Cause

The generator log shows that the file is corrupt containing non UTF characters 

com.fasterxml.jackson.core.JsonParseException: Invalid UTF-8 start byte 0xad

It is the first entry for the record I_DIST_ODPD_RECORD without data imported 

The dash character seems to be invalid.

Resolution

Need to clean up the file and remove bad character.