Symptoms
I am trying to check in my forms and views and I get the error "One or more items used are not checked in"
The issue is I cannot check in Forms A, due to Form B being checked out.
However, I cannot check in Form B, due to From A being checked out.
Diagnoses
Two-way dependency on two forms.
Resolution
We where able to resolve it by using the [Form].[aCheckInContexts] stored proc and specifying both forms in the parameter table 'ContextData'.
In the instructions below, I used two INSERT statement (one for each form) before running the EXEC.
How to use the stored proc:
- Please take a full backup prior to doing this.
- I'm using an example user and ID below. Please change as necessary.
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([ID], [Type])
VALUES (N'97CD2824-D36D-46A7-97AF-BA0F2DFF06CD', 'F')
EXEC [Form].[aCheckInContexts] @UserID= N'K2:DENALLIXAdministrator', @ContextData=@MyTable
--Note: the ID above must be in the format: N''
That will check in the formsviews you need.