Process-driven applications - fast.
My Account
Login
 
Home : Hotfixes : Hotfix: Upgrading to K2 4.5 throws an error if there are orphaned entries in the database
   
 

Hotfix: Upgrading to K2 4.5 throws an error if there are orphaned entries in the database

KB Number:KB001058
Date Published:5/26/2010 6:30:31 AM
Date Modified:5/26/2010 6:30:31 AM

Introduction

A database script enhancement run on existing pre K2 4.5 databases when upgraded to K2 4.5 throws an error if orphaned entries are found.

Error Scenario

The pre K2 4.5 installation’s database is updated with an alter script which changes specific tables within the database to disallow null values. However, if there were pre - existing orphaned entries within the database already, their presence would cause an error and the alter script would be prevented from running.

Note: An orphaned entry is a database record that has no valid or verifiable process instance information to associate with it. These orphaned entries must be removed from the database before the alter script can be run.

Error Messages

Important: The error message(s) displayed below are known to occur and error messages similar to these may be expected; but may not be limited to the cited examples.

Cannot insert the value NULL into column 'ActionId', table 'K2Server.dbo._ActionActInstRights'; column does not allow nulls. UPDATE fails.

The statement has been terminated.

Error Resolution

To correct this error, any existing orphaned entries must be removed. As a precaution, a check is made to ascertain for sure that there are is process information associated with the orphaned entries and then they are deleted.

The latest K2 Update is available as an independent installation package which can be found here: https://portal.k2.com/downloads/bp/default.aspx.

Note: This is a "FAST PUBLISH" article created directly from within the K2 support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.
 
   
   
 
PRODUCT
K2 blackpearl
K2 blackpoint
APPLIES TO
K2 blackpearl 4.5 (4.10060.1.0)
K2 blackpoint 4.5 (4.10060.1.0)