Error: General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server] Cannot insert duplicate key row in object - when adding an attachment to a Vendor record

 When dragging and dropping an attachment onto a Vendor record in Accounts Payable in Database view, the error, Error: General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server] Cannot insert duplicate key row in object 'dbo.AP7VENDORMEDIA' with unique index 'IX_AP7VENDORMEDIA_IMPORTID_U'. The duplicate key value is (<NULL.). Native error: 2601 [Microsoft][ODBC SQL Server Driver][SQL Server] The statement has been terminated. Native error: 3621

When working in in FE NXT, the error may appear as:

Failed to save attachment. 

Cannot insert duplicate key row in object 'dbo.AP7VENDORMEDIA' with unique index 'IX_AP7VENDORMEDIA_IMPORTID_U'. The duplicate key value is (<NULL>). Cannot insert the value NULL into column 'MediaID, table
'FE_21061.dbo.NXT_AP7VENDORMEDIA_EXT'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated.
[OK]
We are currently evaluating this issue and will update this article when we have more information.

Steps to Duplicate

In FE NXT

1. Payables > Vendors > Open a Vendor
2. In the Attachments panel, click Attach a file
3. Open the folder with the receipt on the desktop > Drag the file over to the box > Select the attachment type and hit save.
4. Receive Error

In Database View:

1. Accounts Payable > Records > Vendors > Open a Vendor
2. Media Tab > New Media > Mark to create from file
3. Browse to the file and click Ok
4. Receive Error

Environment

 Financial Edge
 7.87

Was this article helpful?