Suni
Novice

Datatype of File Attachement changed to memo during deployment

Hi 

 

While delploying the file datatype changed to memo. Now the customer is unable to download the files. How do I fix the problem?

Where can I find the attached files?

 

Please let me know your suggestions.

 

Thanks,

Suni

0 Kudos
Reply
2 Replies
Thabang
Novice

Re: 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

0 Kudos
Reply
FromKtoZ1
Novice

Re: Datatype of File Attachement changed to memo during deployment

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,

0 Kudos
Reply