Concepts: Information Architecture, Knowledge Management, Portals, Enterprise Search, Collaboration, Extranets, Intranets, Business Intelligence, Business Process Automation, ECM, Records Management, CRM, ERP, Mobile, Web
Approach: Project Management, Business Analysis, Strategy, Design, Development, Implementation
Technologies: Microsoft SharePoint, Office 365, Azure, SQL Server, Windows, HTML5, CSS, JavaScript, ASP.NET
Monday, March 03, 2014
SharePoint Server or Project Server Patch Installed Patch Missing
Description
After installing a SharePoint Server or Project Server Service Pack or Cumulative Update, the Configuration Wizard shows that the Patch is missing from servers in the farm. In this case, the Configuration Wizard on Server 1 is showing that the Project Server 2013 SP1 Patch is missing, yet it was already installed.
Error: Some farm products and patches were not detected on this or other servers. If products or patches are missing locally, you must quit this program and install the required products and patches on this server before restarting this wizard. If products or patches are missing on other servers, you must install the required products and patches on the specific servers, and you may then click the Refresh button to perform the status check again.
Attempting to run the Project Server 2013 SP1 Patch installation again from the .exe verifies that the Patch is already installed on the system. Herein lies the problem. On one hand, the Configuration Wizard will not run because it thinks the patch is missing. On the other hand, it is not possible to install the patch because it is already installed on local server. Patch installed, patch missing, patch installed, patch missing.
Solution
The solution to this problem is to run a PowerShell cmdlet on each of the servers that the Configuration Wizard is reporting, patch missing.
1. Log into the SharePoint Server
2. Open the SharePoint Management Shell as Administrator
3. Get-SPProduct -local
This cmdlet retrieves a list of the SharePoint-related products installed in the farm. It also retrieves the version information for updates installed. Using the -Local switch retrieves information for local server only.
It may take some time for the cmdlet to run, but once it completes on the servers, you can do a refresh on the Configuration Wizard and the Configuration will recognize that the patches are, in fact, installed on the servers and it will advance automatically to the next screen. You can continue run the Configuration Wizard upgrade procedure.
References
Microsoft TechNet (May, 2010). Document farm configuration settings (SharePoint Foundation 2010). Retrieved March 3, 2014 from http://technet.microsoft.com/en-us/library/ff645390%28v=office.14%29.aspx
Microsoft TechNet (January, 2014). Document farm configuration settings in SharePoint 2013. Retrieved March 3, 2014 from http://technet.microsoft.com/en-us/library/ff645391.aspx
Microsoft TechNet (July, 2012). Get-SPProduct. Retrieved March 3, 2014 from http://technet.microsoft.com/en-us/library/ff607885.aspx
Thank you! It worked.
ReplyDeleteYou may get an error when you try the -local command.
ReplyDelete"Cannot access the local farm, verify that the local farm is properly configured, currently available, and that you have the appropriate permissions to access the database before trying again."
This means there is a missing configdb.
You will to manuall recreate the connection to the DB in the registry.
Mainly you will need the connection string line below.
--snip---
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\14.0\Secure]
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\14.0\Secure\ConfigDB]
"dsn"="Data Source=YOURSQLSERVER;Initial Catalog=SharePoint_Config;Integrated Security=True;Enlist=False;Connect Timeout=15"
"id"="35c64e39-072c-401b-b7ca-c83e6f3590d2"
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\14.0\Secure\FarmAdmin]
"CredentialKeyDPEnt"=hex:01,00,blah, blah, blah\