Dynamics Community Forum Thread Details

Save operation on syEmailDetails has created a duplicate key

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

Quick Links