Attachment Control and SQL SmartObject stops working after a day
kbt181863
PRODUCTIssue
A form contains an attachment control and this attachment control is connected to a SmartObject which points to a SQL table or stored procedure. The Attachment Control will stop working after a day or so. A restart of the K2 Server resolves the issue, but then it will show up again.
Symptoms
Unable to upload or download attachments in the Attachment control after a day of it working as expected.
Resolution
This is a known issue that occurs because the SQL Column is a varchar which K2 interprets as a Memo type.
However, since this column is used for storing files, it should actually be a File type on the SmartObject. See the screenshot below.
Changing the SmartObject Property type that uses the Attachment Control from Memo to File will resolve the issue.