Hello guys,
There was a requirement for asking me to change the data type of the existing SmartObject from type TEXT to type MEMO. So as in the normal case I did edit the SmartObject from the K2 designer and changed the property data type from existing TEXT to MEMO and deployed the SmartObject, now here is the tricky thing, if you try executing the CREATE SmartObject method with more than 100 characters input, it still throw you an error of string truncated.
And if you go back to designer and open the SmartObject and take a look at the changed property, it appears as MEMO. This was due to no update of the SQL table column from type text to MEMO(MAX). Even changing the SQL table column directly from the SQL management studio and refreshing the service doesn’t help you in fixing this issue.
The only way of fixing this issues is, open the K2 Studio, browse to the SmartObject need to update the data type from the K2 Object browser, right click on it and select save to local, now SmartObject appears on the Solutions explorer, open it, go to the property and change the data type from TEXT to MEMO and then deploy it from K2 studio, this time it will work without any issue.
Prajwal Shambhu 