Microsoft announced the release of the August 2013 Cumulative Update (CU) for Project and Project Server 2010 and 2013. After installing this Cumulative Update, there were some problems though!
First of all, you can find a description and download the CU using this link. When you execute the downloaded bits, it will extract the installer to your system. Double-click on it, and it will “install” the CU to your environment. What you have to do next is running the “SharePoint 2010 Products Configuration Wizard“, which will perform the actual upgrade/patching. Just follow the steps of the wizard, and the configuration -should- complete without any errors. Although, this will happen
The error wasn’t very clear, so after digging into the log file, I didn’t find anything special, except:
The exclusive inplace upgrader timer job failed.
Task upgrade has failed with a PostSetupConfigurationTaskException An exception of type Microsoft.SharePoint.PostSetupConfiguration.PostSetupConfigurationTaskException was thrown. Additional exception information: Failed to upgrade SharePoint Products.
Ok, strange. Problem is that the environment offline and cannot be accessed now. What you have to do is re-run the configuration wizard. This will take your environment up and running again!
Great, so if you go back to the PWA, you will be welcomed as usual. But, things are not what they seem. If you look in the Event Viewer of your machine, you will see an error “System.Data.SqlClient.SqlException: Invalid object name ‘MSP_QUEUE_RENDEZVOUS”:
That’s not good! So, let’s check what it is looking for. If you open SQL Server Management Studio, and connect to your SQL Server. If you open the PWA_Draft database, and expand the “Views” node, you will see:
There will be 3 views.. instead of +250! It looks like the CU deleted all the other views! Therefore, several jobs (and some other stuff) will not process anymore!
How to solve it? Well, actually Microsoft will have to solve this! But what I did was creating a SQL Create script, that creates the missing views (based on a backup I took before applying the CU August 2013). You can download the script here: GenerateViewsAfterAugust2013CU
Note: use it at your own risk! Try it on a test/acc environment before applying it on a production environment!
After executing this script, you will see some successful job queues again: