Group Collaboration
Undo Checkout of smartforms with Stored Procedure

Challenge: A smartform is checked out by the current user and the user does not have the option to check the form back in. This issue can be caused when using different authentication authorities, such as NTLM or ADDS. The following can be performed to clear the issue:

  • Open SQL Management Studio and expand the K2 database.
  • Execute the following query:

SELECT * FROM [K2].[Form].[Form_Design]

  • If there are too many items checked out, filter by the user who has the form checked out.

SELECT * FROM [K2].[Form].[Form_Design]


  • Copy the ID for the form you want to perform the action on, it will look similar to this:

XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXX OR 12345678-1234-1234-1234-12345678901

  • To Undo the checkout of the form, expand Programmability and Stored Procedures and locate:


  • Right click on the stored procedure and select “Execute Stored Procedure…”
  • Note the UserID is the fully qualified name (FQN) for the user that has the form checked out, the inputs for the procedure are as follows:

@UserID = K2:DENALLIX\Administrator

@ID = 12345678-1234-1234-1234-12345678901

  • The @ClientStack is not required and can be left blank.
  • After executing the stored procedure, execute the original SELECT query on the Form_Design table to ensure the entry has been cleared from the table.