Solved

Sharepoint Integration failed after new Sharepointmigration

  • 8 April 2020
  • 2 replies
  • 216 views

Hello,

our Sharepoint admins replaced the Develop and Test Sharepoint with a new installation. So we have to reinstall the K2 App for Sharepoint as well.

By running the K2 registration wizard from the App catalog we get this error:

Unable to retrieve realm for SharePoint site
The described solutions in
https://help.k2.com/support-services/kbt148364
https://help.k2.com/support-services/kbt137790
do not work.


The SP-URL ist the same but I think we have now some problems with the exisiting SP-configuration on K2 site, because the old server was connected to K2. Could this be the issue?

 

Andi

icon

Best answer by AndreasG 9 April 2020, 20:50

Hi,

we were able to solve the problem with the help of K2 support
The solution in our cas was the following:

 

SYMPTOMS
After replacement/rebuild of SharePoint farm and re-deploying K2 for SharePoint app registration wizard fails on SharePoint Service Broker step with the following error:

Unable to retrieve realm for SharePoint site: https://%APP_ID%.domain.com/sites/appcatalog/K2forSharePoint

APP_ID in error message refers to the APP_ID relevant for old/decommissioned SharePoint farm and does not match one you will see in address bar.

 

DIAGNOSIS
References to the old app ID have are not removed from K2 database.

 

RESOLUTION
References to the old app ID have to be removed from K2 database. To resolve this you need to delete them from [Integration].[ProcessSharePointGeneralSetting] table as explained below:

  1. Backup your K2 database
  2. Execute the following SQL query against K2 database: 
    DELETE FROM [Integration].[ProcessSharePointGeneralSetting] WHERE SiteURL = -- Type in url from error message in single quotes below'https://%APP_ID%.domain.com/sites/appcatalog/K2forSharePoint'
  3. Restart K2 service and run K2 for SharePoint app registration wizard against

Thanks

Andi

View original

2 replies

Hello,


 


Please try checking the K2 Settings hidden list on the App Catalog site. You can hit this list by going to the following URL.


[SHAREPOINT SITE URL]/lists/k2 settings


 


Make sure this is confgiured to point to the correct K2 Server. 

Hi,

we were able to solve the problem with the help of K2 support
The solution in our cas was the following:

 

SYMPTOMS
After replacement/rebuild of SharePoint farm and re-deploying K2 for SharePoint app registration wizard fails on SharePoint Service Broker step with the following error:

Unable to retrieve realm for SharePoint site: https://%APP_ID%.domain.com/sites/appcatalog/K2forSharePoint

APP_ID in error message refers to the APP_ID relevant for old/decommissioned SharePoint farm and does not match one you will see in address bar.

 

DIAGNOSIS
References to the old app ID have are not removed from K2 database.

 

RESOLUTION
References to the old app ID have to be removed from K2 database. To resolve this you need to delete them from [Integration].[ProcessSharePointGeneralSetting] table as explained below:

  1. Backup your K2 database
  2. Execute the following SQL query against K2 database: 
    DELETE FROM [Integration].[ProcessSharePointGeneralSetting] WHERE SiteURL = -- Type in url from error message in single quotes below'https://%APP_ID%.domain.com/sites/appcatalog/K2forSharePoint'
  3. Restart K2 service and run K2 for SharePoint app registration wizard against

Thanks

Andi

Reply