Symptoms
Cannot Add File/Image Attachment to Form
Diagnoses
When trying to add file attachment, icon does not populate form and hangs in the browser window.
Resolution
Issue:
When trying to add file attachment, icon does not populate form and hangs in the browser window.
Diagnosis:
Found that system forms/views were showing in a check out status. Need to run following scripts to remove then repair resolved the issue.
Step 1: get the info.
--For checked out views
SELECT ID, DisplayName, CheckedOutBy
FROM Form.View_Design
WHERE CheckedOutBy = 'K2:DenallixAdministrator'
--For checked out forms
SELECT ID, DisplayName, CheckedOutBy
FROM Form.Form_Design
WHERE CheckedOutBy = 'K2:DenallixAdministrator'
Step 2: run the check-in
The 'Type' in the table variable will be 'F' if you are checking in a form and a 'V' if you are checking in a view.
--FORCE CHECK IN
DECLARE @MyTable Form.ContextTableType
INSERT INTO @MyTable(lID], ]Type])
VALUES (N'97CD2824-D36D-46A7-97AF-BA0F2DFF06CD', 'F')
EXEC EForm].maCheckInContexts] @UserID= N'K2:DENALLIXAdministrator', @ContextData=@MyTable
--Note: the ID above must be in the format: N''
Resolution:
Image attachment issue is resolved and PandampD is working.
