Post Deployment error: "Checked out by another user [USERNAME]. Cancel check out or perform check in" 

  • 16 February 2021
  • 0 replies
  • 16 views

Userlevel 5
Badge +20
 

Post deployment error: "Checked out by another user [USERNAME]. Cancel check out or perform check in"

KBS100081

PRODUCT
K2 Five
K2 blackpearl 4.6.11 to 4.7
BASED ON
K2 blackpearl 4.7
TAGS
Deployment
Microsoft SQL
Package and Deploy
SmartForms
This article was created in response to a support issue logged with K2. The content may include typographical errors and may be revised at any time without notice. This article is not considered official documentation for K2 software and is provided "as is" with no warranties.

Issue

The following error is displayed when trying to deploy a K2 Package from Source to Target:

 

Image

 

The form is checked in, in K2 Designer.

Symptoms

This could be caused by a record in the database "thinking" it is checked out, even though the Form is checked in.

Please run the following SQL Query to verify:

 

SELECT * FROM [Form].[Form]
WHERE [Name] like '%FORM_NAME%'


SELECT * FROM [Form].[Form_Design]
WHERE [Name] like '%FORM_NAME%'

 

One of the columns in the Form.Form table's 'IsCheckedOut' might be set to '0' and the 'CheckedOutBy' might be set to 'NULL'.

An entry in the Form_Design table will also exist.

 

Please Note: The same error can occur for Views, the query will just change from 'Form.Form' to Form.View' and 'Form.Form_Design' to 'Form.View_Design'

 

Resolution

If the query performed above returns a record and the Form is checked in, but a record is also returned in the Form_Design table, then there might be a clash in the information in the K2 database.

Please log a K2 Support Ticket for futher assistance.


0 replies

Be the first to reply!

Reply