Infor CRM 8.2 Web Client Fails to Delete Attachment

When attempting to delete an attachment using the Infor CRM 8.2 Web Client, you may get an error that the “requested value ‘Modified’ was not found.”  This occurs when values for the field RemoteAttachments.Status in the underlying database are not correct.

The only allowed values for the field RemoteAttachment.Status are Available, Requested, and Delivered.  You can determine if there are any disallowed values by running the SQL query:

SELECT * FROM sysdba.REMOTEATTACHMENTS group by Status

If you do have any incorrect values, you will want your database administrator or CRM business partner to determine how best to correct them.