GTEDI:Exception occurred while exporting edi message

Products

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

Issue/Introduction

When exporting EDI files from GTEDI tool, it gives the following error:

"Export Setup started at: 2020-04-27 16_03_27

GT EDI App Version: 4.8.100.2

GT EDI App Build Date: Tuesday, July 9, 2019

Element Seperator: *

Segment Seperator: ~

Line Seperator: 

Connection to database...

Connected to database...

Export started...

Exception occurred while exporting edi message

Exception message: An item with the same key has already been added.

Export Setup completed at: 2020-04-27 16_03_28 in 280.3632 ms"

So every time this shows, we delete all the values from the tables and republish it again. So we keep losing our old data before publishing a new set of files.

Environment

Release : 4.8

Component : CA Test Data Manager

Resolution

Although each individual table doesn't have duplicate keys(BUNDL_ID), when combining them, they do.

For example, if you import table1, and then try importing table2, the import for table2 will see the key already exists due to table1,and fail. This is why you are seeing this error.

Engineering said they can provide an option to GTEDI, so that it will skip over any duplicates and carry on with the import of non-duplicate keys.
This will be an Enhancement Request, which can be tracked by US667922.