Dynamics Community Forum Thread Details

DocAttach - Missing Attachment_ID issue - Dynamics GP 2016

Using Dynamics GP 2016 16.00.0439, this is my test company where I'm working on doc attach reporting.

I ran into an issue where I was getting "A Save Operation on table 'coAttachMSTR' has created a duplicate key error"

I found that similar issue where attachment_id was missing on 2013/2015 r2 was causing this problem but nothing for 2016. I pulled up my CO tables and found that yes, one document has a missing attachment_id. I have no idea how it got there, I check the paths, all under the 58 character issue that was associated with other docattach issue.

So now, how do I fix this. Being that this is a test, I have remove all entry to a particular attachment before through sql. But if this happens in production, where I need the data, that is probably not an option.

Can I generate my own attachment_id and fill in all missing attachment_id ? how is the attachment_id calculated for each document?

I did find the file name is invoice5.pdf, so is the attachement_id is calcuated off that name or combination of that name ? Ill try a few other things and report back