Skip to main content
Panther Knowledge Base

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.

Resolution

To resolve this issue:

Please delete your LUT and re-create the LUT it under a new name.

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.

 

 

 

 

  • Was this article helpful?