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

book

Article ID: 209175

calendar_today

Updated On:

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

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.

Environment

Release : 4.9

Component : CA Test Data Manager

Resolution

Need to clean up the file and remove bad character.