Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Save operation on syEmailDetails has created a duplicate key

Posted on by Microsoft Employee

GP2016 R2.  Get the following message when selecting an Invoice document through receivables Inquiry, click on Email info button to get to the Sales E-mail  Detail Inquiry Zoom window and hit OK and get "A save operation on table 'syEmailDetails' has created a duplicate key.'  The more info indicates that it is a violation of the Primary Key constraint 'PKSY04910' and the duplicate key value is (0,11,3, )  Since the key is made up of the following columns, (Dictionary ID, Module1, DOCTYPE, and Doc Number)  I see that it is trying to in fact duplicate a record that already exists however, I am not sure why it would be trying to put a record in with a blank doc number when the document number is clearly set on the screen, and why one would already exist is also a mystery since it is the only one with a blank doc number in the table.  I have run into this previously and simply removed the record from the SY04910 table that had a blank document, but it keeps coming back and I keep running into the duplicate key issue.  Any info on what could be causing the issue?

Keith Schimke - EIS

*This post is locked for comments

  • Syrus Profile Picture
    Syrus 4,156 on at
    RE: Save operation on syEmailDetails has created a duplicate key

    I see this error sometime when GP is acting slow and timing out but it looks that you found it a duplicate record. Though I don't see any impact on the record

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans