Support
Support articles and FAQ's.
cancel
Showing results for 
Search instead for 
Did you mean: 
Sort by:
Symptoms Hi I have a smartobject which stores file attachment on a field and saves fine in the db. But whenever I re-publish the smartobject using existing GUID , the datatype of that field changes to be memo. Due to which few attachments have been saved as memo in db. Please advise how I can recover these files saved as memo because I am not able to download this attachment. Diagnoses I was able to reproduce the issue what i did to resolve the issue was to copy the contents of the SQL table to a new SQL table , then remove all the rows that contained "andltfileandgtandltnameandgt" in the "Community Med Evidence" column OR EMPTY , then changed the field type in SMO to memo again, then run the smartform that shows the list of the SQL table in order to DOWNLOAD THE ATTACHED documents. after i made sure that all the DOCUMENTS WERE DOWNLOADED i changed the SMO field type to file again, then made a THIRD copy of the SQL table. I moved the contents of the second SQL table to the original table then ran the smartform to open the list, then edit the rows that has the wrong attachemnt values and ATTACH the DOWNLOADED DOCUMENT to the correct row. The FilePath property in the XML refers to a temporary location of Window's Isolated Storage https://msdn.microsoft.com/en-us/library/3ak841sy(v=vs.110).aspx . The current Files location is a temporary cache (it?s cleared every few minutes) and it is used to stream files temporarily while interacting with the Smartforms attachment control. Resolution customer ordered this ticket to be closed with the following reply: " I will just inform the customers and ask them to re-upload the attachments. " My Input was: " I was able to reproduce the issue what i did to resolve the issue was to copy the contents of the SQL table to a new SQL table , then remove all the rows that contained "andltfileandgtandltnameandgt" in the "Community Med Evidence" column OR EMPTY , then changed the field type in SMO to memo again, then run the smartform that shows the list of the SQL table in order to DOWNLOAD THE ATTACHED documents. after i made sure that all the DOCUMENTS WERE DOWNLOADED i changed the SMO field type to file again, then made a THIRD copy of the SQL table. I moved the contents of the second SQL table to the original table then ran the smartform to open the list, then edit the rows that has the wrong attachemnt values and ATTACH the DOWNLOADED DOCUMENT to the correct row. The FilePath property in the XML refers to a temporary location of Window's Isolated Storage https://msdn.microsoft.com/en-us/library/3ak841sy(v=vs.110).aspx . The current Files location is a temporary cache (it?s cleared every few minutes) and it is used to stream files temporarily while interacting with the Smartforms attachment control. To store the file in the database, you need to call a "Create/Update" Smartobject method and pass the control into the Smartobject call. The following datatype flow below is applicable: Nvarchar(max) datatype (SQL backend) andlt--andgt File/Image type (Smartobject Property) andlt--andgt Calling a Create/Update method and passing the Attachment Control into this Smartobject's File/Image type property When passing the attachment control into the Create/Update method, the Smartobject will access the temporary file (in the isolated storage location via the control's XML properties), then convert that file into a Base64 encoded string and write this string to the database. The table the smartobject is created off of has the attchment column set to a "memo" datatype (nvarcharmax). The smartobject for this table currently has that attachment property set to a "file" datatype so that we can store documents in that column in SQL and hook the smartobject to the attachment control in the first place. This has to be a manual change for the dataype on the attachment property, as the underlying table structure is not storing that information as a File type. Refreshing the UserManagement SQL Service Instance or the SQL smartobject might have been what changed the property in the smartobject back to "memo" from "file" causing the files uploaded while attachment was set to "memo" to be stored in an imporoper format in the backend.
View full article
Symptoms when I create a copy from runtime folder for Arabic (RTL) and trying to run it I have the following error: ID3206: A SignInResponse message may only redirect within the current web application: '/Arabic/' is not allowed. I need it to create different url for Arabic (RTL) form. Diagnoses Issue resolved after a session with customer where we made a copy of the smartforms folder and created Web app based on it then modified the Web. Config to reflect the changes Resolution The issue is that the user had created the new web application within the same site although the realm was set to true, for some reason, realm wasn’t picking at correct audience URI. so we have created a different site and the port also is changed, so the audience URI goes through separate site ports. I'm not still 100 % sure why the audience URI isn’t picking up with in the same site as it should work. however , a separate site is always good practice in terms of the network traffic loading.
View full article
Symptoms Issue with File Attachment saving to network Diagnoses We are trying to allow our staff to attach files to a smartForm. I need to save this file to another location. The only way I could find to do this that didn't involve a database was to write a webservice. I've created a webservice that takes in a byte[]. I create a Service Broker to the web service and then created a SmartObject. So far that all went smoothly. I went into the SmartObject and change the byte[] data type to the data type of File and then saved. From there I created a new SmartForm with a File Attachment and a button on it. I added a rule that when the button is clicked the SmartObject is called with the FileAttachment as input to the SmartObject. Every time I run the SmartForm I get the following error: "SmartObject property f is a required property for selected method Read. Value must be set." In an effort to troubleshoot I did all the same steps, but with a SmartObject that sat on top of a database and that worked. I need some help determining what data type the webservice inbound parameter needs to be to make this work. Resolution Loaded the file attachment control from the market place, of which allowed for saving out to a network drive. We were unable to load the attachment from the network, however it does return the relative path to the save of which could be used in a clickable URL control.
View full article
Symptoms We get an intermittent Async_ExceptionOccured error on the K2 Viewflow when the viewflow is left open for a while. It does not happen immediately after the Viewflow is opened but usually after some minutes. If you then reload the viewflow, everything is ok again. Diagnoses As far as I know it happens in IE and in Chrome. So far mostly on the QA Environment. QA is a load balanced two node environment. Runs under SSL. Please see the attached screenshots. Resolution I've found two things that might help you with this problem: ------------------------- Uninstalling Re-installing Silverlight - http://support.microsoft.com/kb/2608523 Or installing a developer version of Silverlight with the same functionality but more capability. You can find that here - http://go.microsoft.com/fwlink/?linkid=150228 --------------------------------- There is a known issue using ViewFlow through a load balancer that uses SSL but the K2 server does not use SSL (it's called SSL Offloading). We are working to resolve this in a future build. ---------------------------------
View full article