Datatype of File Attachement changed to memo during deployment

hello  Suni

I have provided you with a document that can help solve your issue, please advise  by giving a kudo or mark as a solution ,given that it has ressolved your issue.

http://help.k2.com/kb002261

K2 will not accept any liability for any issues arising from actions taken in respect of the information provided by any forum member.

Thanks

Thabang

Hey Suni,

The file datatype was changed to 'Memo' because the SQL column type is nvarchar(max) or another similar type. This is expected behavior regarding the SQL Service Instance becuase it is not smart enough to realize this column should be a file. The SQL broker reads the nvarchar(max) type and creates a Memo type property on the SmartObject.

We can resolve this issue by navigating to the SmartObject in K2 Designer and changing the type from 'Memo' to 'File'. However, please note, that if you regenerate SmartObjects, the type will most likely be changed back to Memo and you will have to manually change it back to 'File'.

Thanks,