Symptoms

When attempting to activate K2 for SharePoint 2010 on Site Collections via Central Admin, the following error is seen:

The operation has completed but with errors:
An error has occurred trying to update the Connection Settings.
An error has occurred trying to update the Environment Library entry:
Exception from HRESULT: 0x80131904
Error occurred trying to set required Sharepoint permissions for the Deployment Application Pool.
Error occurred trying to Add or Update Process Designer Settings to destination site.
An error has occurred trying to update the Process Designers Group.
An error has occurred trying to update the Process Participants Group.
An error occurred while trying to update the process approval settings:
Microsoft.SharePoint.SPException:
Exception from HRESULT: 0x80131904 --->
System.Runtime.InteropServices.COMException (0x80131904):
Exception from HRESULT: 0x80131904
at Microsoft.SharePoint.Library.SPRequestInternalClass.AddOrUpdateItem(String bstrUrl, String bstrListName, Boolean bAdd, Boolean bSystemUpdate, Boolean bPreserveItemVersion, Boolean bPreserveItemUIVersion, Boolean bUpdateNoVersion, Int32and plID, Stringand pbstrGuid, Guid pbstrNewDocId, Boolean bHasNewDocId, String bstrVersion, Objectand pvarAttachmentNames, Objectand pvarAttachmentContents, Objectand pvarProperties, Boolean bCheckOut, Boolean bCheckin, Boolean bMigration, Boolean bPublish, String bstrFileName, ISP2DSafeArrayWriter pListDataValidationCallback, ISP2DSafeArrayWriter pRestrictInsertCallback, ISP2DSafeArrayWriter pUniqueFieldCallback)
at Microsoft.SharePoint.Library.SPRequest.AddOrUpdateItem(String bstrUrl, String bstrListName, Boolean bAdd, Boolean bSystemUpdate, Boolean bPreserveItemVersion, Boolean bPreserveItemUIVersion, Boolean bUpdateNoVersion, Int32and plID, Stringand pbstrGuid, Guid pbstrNewDocId, Boolean bHasNewDocId, String bstrVersion, Objectand pvarAttachmentNames, Objectand pvarAttachmentContents, Objectand pvarProperties, Boolean bCheckOut, Boolean bCheckin, Boolean bMigration, Boolean bPublish, String bstrFileName, ISP2DSafeArrayWriter pListDataValidationCallback, ISP2DSafeArrayWriter pRestrictInsertCallback, ISP2DSafeAr
 

Diagnoses

This error is typically the result of insufficient permissions on the SharePoint Content Database. The following page from the documentation shows what permissions the Setup User needs for successful installation/activation of the K2 for SharePoint components:
http://help.k2.com/onlinehelp/K2blackpearl/ICG/current/webframe.html_K2_for_Sharepoint_-_Required_Permissions-K2_designer_for_SP.html
 

Resolution

Verify that the user attempting to run the K2 for SharePoint Configuration Wizard has the permissions specified under "Setup User" (near the top of the page).