Upgrading to 5.2 Issue: "Cancel Check Out Or Perform Check In"

  • 15 February 2022
  • 1 reply
  • 62 views

Userlevel 5
Badge +20
 

Upgrading to 5.2 Issue: "Cancel Check Out Or Perform Check In"

kbt156050

PRODUCT
K2 Five
BASED ON
K2 Five 5.2
TAGS
Upgrade
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

When upgrading to 5.2 from version 5.1, you discover an error that appears within the configuration analysis.

The trace logs can be found within the following directory:
Program Files (x86)  > K2 Blackpearl > Set Up > Logs > Trace logs

It seems that there was a system form/view that was checked out and could not be checked in. 
Error:
"System.Exception: Checked out by User 'K2:DomainUser''. Cancel check out or perform check in"

 

 

 

 

Symptoms

The following errors can be seen in the logs: 
"Target did not complete successfully: App Framework Core.kspx."

Troubleshooting Steps

To force the check in of the view/form you can use the following article: https://help.k2.com/support-services/kbt150389

 

Please note the steps in this article includes direct manipulation of the K2 database. You do this at your own risk. Please contact K2 Support for assistance.

After this is done you should see that the form has been checked in successfully. 

 

When running the upgrade again you should no longer see any errors once completed with the environment in a fully functional state.


1 reply

Badge +6

Hi All,


 


Additionally, the complete error message is:


 


08:51:44:>> DeployPackage.DataRecieved: Error: System.Exception: Checked out by User 'K2:DENALLIXAdministrator'. Cancel check out or perform check in
08:51:44:>> DeployPackage.DataRecieved: at SourceCode.Runtime.Services.Forms.FormsSessionData.DeployForm(Form form, Boolean checkIn, Boolean skipReferenceValidation)
08:51:44:>> DeployPackage.DataRecieved: at SourceCode.Runtime.Services.Forms.Services.BaseFormViewService`3.DeployAuthoringInstance(AuthoringType instance)
08:51:44:>> DeployPackage.DataRecieved: at SourceCode.Runtime.Services.Forms.Services.BaseFormViewService`3.Deploy(IDeploymentContext context)
08:51:45:>> DeployPackage.DataRecieved: Done!: Done!
08:51:45:>> DeployPackage.DataRecieved: Complete: Done!
08:51:45:>> DeployPackage.DataRecieved: PowerShell object state changed: Completed
08:51:45:>> DeployPackage.DataRecieved: Powershell exited. State: Completed
08:51:45:>> DeployPackage.DataRecieved: Deploy package utility done.
08:51:45:>> DeployPackage.Execute: Deployment complete: Exit code: 1
08:51:45:>> DeployPackage.Execute: End deploy Package
08:51:45:>> Target.Execute: !Completed: App Wizard.kspx, Success: False
08:51:45:>> Component.ExecuteTarget: Logged Error: Target did not complete successfully: App Wizard.kspx
08:51:45:>> Component.Execute: Logged Error: Internal error has caused the install to terminate:
08:51:45:>> Executor.ExecuteComponent: Logged Error: Blocking execution exception occurred, install cannot continue:
08:51:45:>> Store.EncryptSensitiveVariables: Start.
08:51:45:>> Store.EncryptSensitiveVariables: Done.
08:51:45:>> DefaultFolderPaths.get_InstallDir: Install dir: C:Program FilesK2
08:51:45:>> Execution.SaveInstallState: Move log to folder: C:Program FilesK2SetupUpdateLog
08:51:46:>> Executor.Execute: Logged Error: Unable to complete install, termination exception thrown:
08:51:46:>> Global.ShowAdvancedMsgBox: ==========================================
08:51:46:>> Global.ShowAdvancedMsgBox:
08:51:46:>> Global.ShowAdvancedMsgBox: Type: Failure
08:51:46:>> Global.ShowAdvancedMsgBox: Title: Blocking Error
08:51:46:>> Global.ShowAdvancedMsgBox: Content:
08:51:46:>> Global.ShowAdvancedMsgBox: Link: A blocking error has occurred and setup cannot continue. Inspect the log file for details, and select the 'Recover' option in Setup Manager, after corrective action has been taken, to finish this installation.

Click here to open the log file.

 


 


And here the script to list views and forms with issue and corresponding advise statement from the KB003346:


https://community.nintex.com/t5/How-To/Roll-back-a-View-or-Form-to-a-Previous-Version-Force-Check-In/ta-p/125870


 


SELECT Name, DisplayName,IsCheckedOut, CheckedOutBy,
CreatedBy,convert(varchar, CreatedDate, 20) as CreatedDate,
ModifiedBy, convert(varchar, ModifiedDate, 20) as ModifiedDate,
(SELECT COUNT(*) FROM [Form].[Form_Design] WHERE [Form_Design].ID=[Form].[id]) AS NbRecordInForm_Design,
'declare @return_value int' + char(13) + char(10) +
'exec @return_value = [Form].[aUndoFormsCheckOut] ' + char(13) + char(10) +
'@UserID = ''BY SQL'
+ ''', ' + char(13) + char(10) + --UserId is to used only for logs (procedure eLogMessage: table [AuditLog])
'@IDs = '''+ CAST([Form].ID AS nvarchar(max)) +''', ' + char(13) + char(10) +
'@ClientStack = null' + char(13) + char(10) + char(13) + char(10) +
'select TOP 50 * from [Form].[AuditLog] order by 1 desc '+ char(13) + char(10) + char(13) + char(10) +
'--For corresponding view :'+ char(13) + char(10) +
'select TOP 50 * from [Form].[AuditLog] WHERE Data='''+CAST([Form].ID AS nvarchar(max))+''' order by 1 desc ' AS "Advised Statement"
FROM [Form].[Form]
WHERE 1=1
AND (CreatedBy='K2SQL:System' OR ModifiedBy='K2SQL:System')
AND (IsCheckedOut=1 OR CheckedOutBy IS NOT NULL)
ORDER BY 1,2





SELECT Name, DisplayName,IsCheckedOut, CheckedOutBy,
CreatedBy,convert(varchar, CreatedDate, 20) as CreatedDate,
ModifiedBy, convert(varchar, ModifiedDate, 20) as ModifiedDate,
(SELECT COUNT(*) FROM [Form].[View_Design] WHERE [View_Design].ID=[View].[id]) AS NbRecordInView_Design,
'declare @return_value int' + char(13) + char(10) +
'exec @return_value = [Form].[aUndoViewsCheckOut] ' + char(13) + char(10) +
'@UserID = ''BY SQL'
+ ''', ' + char(13) + char(10) + --UserId is to used only for logs (procedure eLogMessage: table [AuditLog])
'@IDs = '''+ CAST([View].ID AS nvarchar(max)) +''', ' + char(13) + char(10) +
'@ClientStack = null' + char(13) + char(10) + char(13) + char(10) +
'select TOP 50 * from [Form].[AuditLog] order by 1 desc '+ char(13) + char(10) + char(13) + char(10) +
'--For corresponding view :'+ char(13) + char(10) +
'select TOP 50 * from [Form].[AuditLog] WHERE Data='''+CAST([View].ID AS nvarchar(max))+''' order by 1 desc ' AS "Advised Statement"
FROM [Form].[View]
WHERE 1=1
AND (CreatedBy='K2SQL:System' OR ModifiedBy='K2SQL:System')
AND (IsCheckedOut=1 OR CheckedOutBy IS NOT NULL)
ORDER BY 1,2

 


 

Reply