SharePointTechnicalSupport

Troubleshooting Steps SharePoint Online Support, SharePoint Training & SharePoint Help

Tag Archives: InstallationConfiguration

Installing Workflow Manager Offline

Posted on by
Reply

Microsoft has introduced new Workflow engine and concept with SharePoint 2013 called Workflow Manager.

The SharePoint 2013 Workflow platform uses the new Workflow Manager service. Workflow Manager is built on top of Windows Workflow Foundation. Windows Workflow Foundation is part of the .NET Framework 4.5.

Workflow Manager is a separate download and must be configured to communicate with the SharePoint Server 2013 farm.

In several cases your environment is secured and not accessing the internet and you want to install the workflow manager so in the following steps I am going to explain how to do that so you can install Workflow Manager offline to server(s) not connected to the internet.

  • Download the web platform installer

http://download.microsoft.com/download/C/F/F/CFF3A0B8-99D4-41A2-AE1A-496C08BEB904/WebPlatformInstaller_amd64_en-US.msi and install it on a machine with internet access

  • Run the following commands as administrator from command prompt on the machine with internet access to download Service Bus, Workflow Client and Workflow Manager Refresh for offline

Webpicmd /offline /Products:ServiceBus /Path:E:ServiceBus

Webpicmd /offline /Products:WorkflowClient /Path:E:WorkflowClient

Webpicmd /offline /Products:WorkflowManagerRefresh /Path:E:WorkflowManagerRefresh

 

Note: modify E: with the path you would like to download to

  • On the machine with internet access, download the Cumulative Update for Service Bus 1.0 from:

http://www.microsoft.com/en-us/download/details.aspx?id=36794

  • Copy the downloaded file from Step 1, 2 and 3 to the server(s) where you will install the Workflow Manager.
  • On each server where you will install workflow manager run and install the following
  • Open command prompt as administrator and run the following:

WebpiCmd.exe /Install /Products:ServiceBus /XML:E:ServiceBusfeedslatestwebproductlist.xml

  • Manually install the file you downloaded from step 3
  • Open command prompt as administrator and run the following:

WebpiCmd.exe /Install /Products:WorkflowClient /XML:E:WorkflowClientfeedslatestwebproductlist.xml

  • Open command prompt as administrator and run the following:

WebpiCmd.exe /Install /Products:WorkflowManagerRefresh /XML:E:WorkflowManagerRefreshfeedslatestwebproductlist.xml

Note: modify E: with the path where files you copied from previous steps exist.

The next step is to configure the Workflow Manager Farm and connect it with SharePoint to do so check the following article from MSDN

https://msdn.microsoft.com/en-us/library/jj193510(v=azure.10).aspx

The license state for the current server doesn’t match the farm’s license state

Posted on by
Reply
[siteorigin_widget class=”WordAds_Sidebar_Widget”][/siteorigin_widget]
[siteorigin_widget class=”WordAds_Sidebar_Widget”][/siteorigin_widget]

The license state for the current server doesn’t match the farm’s license state

Recently I have involved in an interesting troubleshooting issue. There are many blog posts and TechNet discussions about this error “The license state for the current server doesn’t match the farm’s license state”. Thought that to post it here about my experience.

Here is the scenario. Customer has two Windows 2008 R2 Std machines (lets call it as srvsp1 & srvsp2) installed and configured with the following products.

  1. SharePoint Server 2010 Enterprise Edition
  2. Office Web Apps

Recently we have patched those two servers , for some troubleshooting one of the servers (srvsp2) was disconnected from the farm. After completing the installation while trying to add the server back to the farm by running the PSConfig we got the below error,

The license state for the current server doesn’t match the farm’s license state.
System.InvalidOperationException: The current server cannot be joined to this farm because the set of installed products does not match the products installed in the farm.

The license state for the current server doesn’t match the farm’s license state.
at Microsoft.SharePoint.Administration.SPFarm.Join()
at Microsoft.SharePoint.PostSetupConfiguration.ConfigurationDatabaseTask.CreateOrConnectConfigDb()
at Microsoft.SharePoint.PostSetupConfiguration.ConfigurationDatabaseTask.Run()
at Microsoft.SharePoint.PostSetupConfiguration.TaskThread.ExecuteTask()

Here are the troubleshooting steps.

# Step 1

Verify the configuration database has correct entries of all installed products. For that , we ran the following query against the “Objects” table of SharePoint configuration database.

Select * from Objects with (nolock) where properties like ‘%icrosoft.SharePoint.Administration.SPInstallState%’

From the result copy the “Properties” column value to notepad or any xml editor tool, in my case I have used Visual Studio.

2577.image_3AD92119

Values that we are interested the ones highlighted in the below screenshot. Same is given below.

beed1f75-c398-4447-aef1-e66e1f0df91e
d5595f62-449b-4061-b0b2-0cbad410bb51

4774.image_1834E29E

# Step 2

Once we get those GUIDs, next step is make sure that any difference in the actual Physical SharePoint server’s installed products and configuration database.

To do that, check the below registry location in both the SharePoint Servers (srvsp1 & srvsp2).

HKEY_LOCAL_MACHINESOFTWAREMicrosoftShared ToolsWeb Server Extensions14.0WSSInstalledProducts

6837.image_75FCD717

{90140000-1014-0000-1000-0000000FF1CE} REG_SZ BEED1F75-C398-4447-AEF1-E66E1F0DF91E
{90140000-110D-0000-1000-0000000FF1CE} REG_SZ D5595F62-449B-4061-B0B2-0CBAD410BB51
{90140000-112D-0000-1000-0000000FF1CE} REG_SZ 926E4E17-087B-47D1-8BD7-91A394BC6196

Here we can clearly see that the physical box has 3 entries whereas the configuration database has only 2 of them.

More details of the GUIDs are given below.

BEED1F75-C398-4447-AEF1-E66E1F0DF91E is for “SharePoint Foundation 2010”,

D5595F62-449B-4061-B0B2-0CBAD410BB51 is for “SharePoint Server 2010 Enterprise”

926E4E17-087B-47D1-8BD7-91A394BC6196 is for “Office Web Companions 2010″ (Office Web Apps)

(Just FYI, for more information all different product SKUs and it’s GUIDs please refer this article http://msdn.microsoft.com/en-us/library/ff721969.aspx )

In our case, the Configuration database should have had 3 entries to match the registry in a normal farm. For some reason it was not updated with the office web apps production installation , it may caused by an installation issue.

Resolution:

Run the following Power Shell commandlet on any working server in the farm. In our case it was srvsp1, the reason we would need to run from this server is because the problem server – srvsp2 is still not in the farm.

Set-SPFarmConfig –InstalledProductsRefresh

This will pick the entries from the server and reset the entries in the Config DB. 

To double-check, you can run the same SQL query mentioned above and confirm the values.

Hope this will helpful while troubleshooting this specific issue related to SharePoint. There are different scenarios as well, eg: configuration database may have the values but it was not there in the physical server’s registry. To fix that you may end up with uninstall and install the product to update it correctly.

[siteorigin_widget class=”WordAds_Sidebar_Widget”][/siteorigin_widget]
[siteorigin_widget class=”WordAds_Sidebar_Widget”][/siteorigin_widget]

“The license state for the current server doesn’t match the farm’s license state”– SharePoint PSConfig Error

Posted on by
Reply

Recently I have involved in an interesting troubleshooting issue. There are many blog posts and TechNet discussions about this error. Thought that to post it here about my experience.

Here is the scenario. Customer has two Windows 2008 R2 Std machines (lets call it as srvsp1 & srvsp2) installed and configured with the following products.

  1. SharePoint Server 2010 Enterprise Edition
  2. Office Web Apps

Recently we have patched those two servers , for some troubleshooting one of the servers (srvsp2) was disconnected from the farm. After completing the installation while trying to add the server back to the farm by running the PSConfig we got the below error,

The license state for the current server doesn’t match the farm’s license state.
System.InvalidOperationException: The current server cannot be joined to this farm because the set of installed products does not match the products installed in the farm.

The license state for the current server doesn’t match the farm’s license state.
at Microsoft.SharePoint.Administration.SPFarm.Join()
at Microsoft.SharePoint.PostSetupConfiguration.ConfigurationDatabaseTask.CreateOrConnectConfigDb()
at Microsoft.SharePoint.PostSetupConfiguration.ConfigurationDatabaseTask.Run()
at Microsoft.SharePoint.PostSetupConfiguration.TaskThread.ExecuteTask()

Here are the troubleshooting steps.

# Step 1

Verify the configuration database has correct entries of all installed products. For that , we ran the following query against the “Objects” table of SharePoint configuration database.

Select * from Objects with (nolock) where properties like ‘%icrosoft.SharePoint.Administration.SPInstallState%’

From the result copy the “Properties” column value to notepad or any xml editor tool, in my case I have used Visual Studio.

2577.image_3AD92119

Values that we are interested the ones highlighted in the below screenshot. Same is given below.

beed1f75-c398-4447-aef1-e66e1f0df91e
d5595f62-449b-4061-b0b2-0cbad410bb51

4774.image_1834E29E

# Step 2

Once we get those GUIDs, next step is make sure that any difference in the actual Physical SharePoint server’s installed products and configuration database.

To do that, check the below registry location in both the SharePoint Servers (srvsp1 & srvsp2).

HKEY_LOCAL_MACHINESOFTWAREMicrosoftShared ToolsWeb Server Extensions14.0WSSInstalledProducts

6837.image_75FCD717

{90140000-1014-0000-1000-0000000FF1CE} REG_SZ BEED1F75-C398-4447-AEF1-E66E1F0DF91E
{90140000-110D-0000-1000-0000000FF1CE} REG_SZ D5595F62-449B-4061-B0B2-0CBAD410BB51
{90140000-112D-0000-1000-0000000FF1CE} REG_SZ 926E4E17-087B-47D1-8BD7-91A394BC6196

Here we can clearly see that the physical box has 3 entries whereas the configuration database has only 2 of them.

More details of the GUIDs are given below.

BEED1F75-C398-4447-AEF1-E66E1F0DF91E is for “SharePoint Foundation 2010”,

D5595F62-449B-4061-B0B2-0CBAD410BB51 is for “SharePoint Server 2010 Enterprise”

926E4E17-087B-47D1-8BD7-91A394BC6196 is for “Office Web Companions 2010″ (Office Web Apps)

(Just FYI, for more information all different product SKUs and it’s GUIDs please refer this article http://msdn.microsoft.com/en-us/library/ff721969.aspx )

In our case, the Configuration database should have had 3 entries to match the registry in a normal farm. For some reason it was not updated with the office web apps production installation , it may caused by an installation issue.

Resolution:

Run the following Power Shell commandlet on any working server in the farm. In our case it was srvsp1, the reason we would need to run from this server is because the problem server – srvsp2 is still not in the farm.

Set-SPFarmConfig –InstalledProductsRefresh

This will pick the entries from the server and reset the entries in the Config DB. 

To double-check, you can run the same SQL query mentioned above and confirm the values.

Hope this will helpful while troubleshooting this specific issue related to SharePoint. There are different scenarios as well, eg: configuration database may have the values but it was not there in the physical server’s registry. To fix that you may end up with uninstall and install the product to update it correctly.