Symptoms

When trying to access Group Providers node in K2 Workspace Management (K2 Workspace > Management > User Managers > SP > Group Providers) the following error is being displayed:

pageexception: "Root element is missing"
 

Diagnoses

This error caused by entry or entries in GroupProvider table with an empty Init column. Run the following SQL script against K2 data base to check this:

USE K2

SELECT *

FROM HostServer.GroupProvider

In case any of the entries in this table has empty Init column, backup K2 database and remove it using the following SQL query:

USE K2

DELETE FROM HostServer.GroupProvider

WHERE Name='%Provider_with_Empty_Init_Column%'

Resolution

Issue can be resolved by removing entries with empty Init column from GroupProvider table. Always perform backup of K2 database before attempting any changes on it.