Where do the files go?

  • 25 January 2017
  • 2 replies
  • 2 views

Badge +5

 

Just a quickie:

When the user saves a attachment into a smartobject where does the physical file reside on the server?

 

Cheers,

Martin


2 replies

Userlevel 5
Badge +18

If you are are later version on K2, K2 will keep this file temporarily in Isolated Storage (https://msdn.microsoft.com/en-us/library/3ak841sy(v=vs.110).aspx) when interacting with it, but ultimately it will be written to whichever back-end system that the SmartObject interacts with:


 


If SmartBox/SQL Service Instance; it will usually be Base64 encode in an nvarchar(max) SQL field


If Sharepoint, then it will be stored in Sharepoint Library or List Attachment

Badge +5

Thanks for reply.

It appears the table has grown to large and I need to move the data to a different server. Sadly Package and Deployment tool doesn't seem to work with large data packages.

 

Is there any method to move the data into a new DB without causing issues. Using a generate scripts method (inside SQL) seems to be unreadable by the smartobject.

Reply