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 you remove the K2 for SharePoint App from a SharePoint site collection, there are still remnants of that site collection left in SharePoint and in K2. These should get removed completely from both SharePoint and K2.

Symptoms

When you remove the K2 for SharePoint App from a SharePoint site collection, there are still bits and pieces of the site collection left in SharePoint and in K2. These should get removed completely from both SharePoint and K2. 

When removing the K2 for SharePoint App from a SharePoint site collection, perform the following steps:

  • Remove SharePoint Group Provider entries in K2.
  • Remove Management SmartObjects and the Service Instance in K2.
  • Remove the OAuth resources in K2.
  • Remove Receiver entries in K2.
  • Remove the Site Collection Category tree in K2.
  • Remove SharePoint Group Provider entries from the Identity.Identity, and Identity.IdentityMembers tables in K2.
  • Remove K2Pages library in SharePoint. 
  • Remove App Catalog K2 tracking list entries in SharePoint.
  • Add functionality to "brute force - retry" scenarios, where the SharePoint site has been deleted already, but the K2 artifacts remain.

Resolution

We do have a PowerShell script that does some (but not all) of the clean-up for you. If you would like the clean-up script, please log a new support ticket, reference this KB and request the clean-up script. 

No matter how small the change, always make a full backup of your K2 database(s), before making any "direct changes" to it. 
Note: http://help.k2.com/onlinehelp/k2blackpearl/devref/current/default.htm#Database_Reference.html 

We have logged an item for the development team to look at. All of the clean-up should be added to a future build of K2. (At the time of writing, there is no official date that will include this clean-up functionality.)