How do I fix "Duplicate row detected during DML action" error when uploading data to a Lookup Table in Panther?
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.
To resolve this issue:
Please delete your LUT and re-create the LUT it under a new name.
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.