This article was created in response to a support issue logged with K2. The content may include typographical errors and may be revised at any time without notice This article is not considered official documentation for K2 software and is provided “as is” with no warranties.

Issue

I have a SQL SmartObject that has a File Property on it. I refreshed the Service Instance and regenerated the SmartObject. Now the records are being saved to the DB as a <collection>  instead of a <file>  type.

The SmartObject property has changed to be a Memo type, not a File type. 

Symptoms

When looking at the DB, you will see the column is filled with <collection> typed items.

Resolution

Edit the SmartObject and change the property to be a File type. This will change how the record is saved and save it as a <file>  type.