Blocking error during upgrade Grant_AdminUser_Full_RightsOn_Root_ServiceType

Issue

During an upgrade (at least 5.6), you may run into the following error:

Grant_AdminUser_Full_RightsOn_Root_ServiceType

The K2:DOMAIN\DisabledUserInAD could not be found.


Cause

This is related to K2 5.6 introduction of Service Instance Security:

https://help.nintex.com/en-us/k2five/userguide/current/Content/K2-Management-Site/Integration/ServiceInstancesSecurity.htm


Where-in the Upgrade process will get users from the [Server].[ServerUser] tables to set as default administrators for Service Instances.  However, if the user is disabled in Active Directory and marked as not enabled in the K2 Identity Cache, then this step will fail.


Resolution

You can check which entries in the [Server].[ServerUser] is disabled via SQL, and remove these entries from the [Server].[ServerUser] table.  You can use the following to check:

SELECT * FROM [Server].[ServerUser] ssu 

JOIN [Identity].[Identity] ii 

ON ssu.[User] = ii.FQN 

WHERE ii.[Enabled] = 0 AND ii.[Type] = 1 AND ii.[Label] = 'K2'


Once removed, you can Recover the upgrade process.

Comments

Popular posts from this blog

Blocking Error during K2 5.6 Server migration

Client Credentials flow with K2 Cloud with Odata, Workflow REST or SCIM

Blocking error RegisterServiceInstanceObjects when upgrading to K2 5.6/5.7