How do I fix "Duplicate row detected during DML action" error when uploading data to a Lookup Table in Panther?
Issue
When trying to upload data for my Lookup Table (LUT), I am getting a lookup update failed...duplicate row detected during DML action
error when there are no duplicate rows.
Cause
If you happen to create a Lookup Table with a duplicate entry and then fix it, this issue will arise when uploading the fixed data again. The reason for this is that Panther stores the original Lookup Table data with the initial name. To create a completely new table in the database, you need to ensure that the name of your Lookup Table is different.