Support Article
Duplicate Primary Keys data entry in database table
SA-100192
Summary
Duplicate Primary Keys data entry displays in the database table. Instead of updating the existing row, a new row is inserted.
Error Messages
Not Applicable
Steps to Reproduce
Run the flow that updates and saves an existing work item.
Root Cause
A defect or configuration issue in the operating environment.
The table does not have a primary key. The Save method used is Insert or Update which relies on the presence of a primary key on the table.
Resolution
Make the following change to the operating environment:
- Remove duplicate rows to only retain the current version of each work object.
- Add the missing primary key to the table.
Published February 11, 2020 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.