SharePoint (and Project Server) Shenanigans

For me the year starts with some big fireworks display, as Dubai has plan to create a world record of biggest fireworks at new year. It was fun to witness such historic moment, at the same time a little guilt that this enormous amount of money could be used to something more useful.

You can find the details of Project Server 2013/2010 installation package here: http://blogs.technet.com/b/projectsupport/archive/2013/12/12/microsoft-project-server-2010-and-2013-december-cu-announcement.aspx

Note, as usual, that this should be applied to test environment first prior to production. Also Mar 2013 CU is been set as baseline for all Project Sever 2013 CUs, so install Mar 2013 CU first.

Dec CU includes fix to one of the commonly encountered issue:

• Assume that you change values for fields such as Project Owner and Name on a Project Detail Page (PDP) in Project Web App. When you save and refresh the page, the values are reverted to what they were before the change.

Happy patching and Happy New Year to everyone …. 

Before i proceed, please note that Bulk Import tool was released along with the release of Project Server 2010 and to be used with Project Server 2010. Till date, i am not sure, if Bulk Import tool without modification will work with Project Server 2013. This issue, and its resolution, is for Project Server 2010 environment.

Some time back Andrew Lavinsky had discuss Bulk Import tool feature in great detail through his blog, a blog worth every minute of your time. Please go through these blog posts if you are interested to use Bulk Import tool:

• The Bulk Import tool, Unwrapped (Part 1)
• The Bulk Import tool, Unwrapped (Part 2)

My post is to highlight the following issue you may come across while trying validating Site URL:

Just before this blog, a normal time i have experienced to install any CU on Project Server 2013 servers, were some where between 4-5 hrs and some time more than that as well 😦 and this duration is for 1 CU only, imagine if you have to install more than 1 CU which is common as March CU is a pre-requiste for any new CUs to be installed.

Which means, that either you plan to start the installation at day end, so that next day when you will resume work you only have to wait for configuration wizard to be finished

you can sit idle and stare at that progress bar on your screen, moving as slowly as any slowest turtle exist on planet earth, and curse yourself that why have you started the installation at this time.

I have been look for ways to improvise the duration of installation of CU, and the good news is that there is a way to install the same CU with the duration time of between 30-45 mins … yea you are reading it rite, its mins NOT hrs 🙂

Credit for this goes to Russ Maxwell, who brought this solution forward. And i am re-posting this good to spread to Project server community, because its equally painful for us as well 🙂

From the start the suspect in this whole case, i.e. why CU takes so long, are the SharePoint services running on the server such as App fabric/search etc. As they consume most part of CPU, and push windows installer to a lower priority to consume CPU time.

So here is a Power-Shell script to automate and speed up the installation process by disabling SharePoint server services gracefully. The scirpts performs the following steps:

1. Disable the IISAdmin and SPTimerV4 service
2. Shut down IIS Admin and Timer Services if they are running                                                                                                          
3. Give you the option to Pause the Search Service Application (see search notes below)                                                                                      
4. Stop Search Services (see search notes below)                                                                                                                                                     
5. Install the patch in passive mode (No user interaction required but will witness the patch install in the UI). Note:  Power Shell should remain open in the background while patch is running.
6. Upon completion of the patch, the Power Shell script, services in step 1 are set to Automatic                                                                          
7. Starts up IIS Admin and Timer Services                                                                                                                                              
8. Starts up Search Services                                                                                                                                                                                      
9. Resume the Search Service Application if it was paused                                                                                                                       
10. Finally, the script will display the Start Time and End Time for patch install

The script can be downloaded from the script gallery below:
http://gallery.technet.microsoft.com/scriptcenter/Server-2013-automate-and-833aeb0b

A walkthrough using the script is below:

Copy the script and CU in the same folder, note that only one CU should be placed in the folder and file extension should be .exe.

Open the power shell and run the script, i recommend to pause search service application here by choosing 1. The screen shots below are of Project Server 2013 JUN CU installation on my server:

Notice the installation time of JUN CU, 35 mins, voila 🙂

Happy patching.

Follow these very detailed and helpful TechNet article in order to prepare Office Web App server , and then bind it with your SharePoint server later to make it work.

1. Plan office Web Apps Server
2. Deploy Office Web Apps Server 
3. Configure SharePoint 2013 to use Office Web App Server

No mapping between account name and security SIDs was done

The Service Packs contain all cumulative fixes since SP1, starting with the June 2011 Cumulative Update (CU) and the July 2011 Public Update (PU) all the way through to the April 2013 CU and May 2013 PU.  The Service Packs also contain previously unreleased fixes.  In addition to general product fixes, these fixes include improvements in stability, performance, and security.The complete list of fixes is available here.

All the download are available through Microsoft download center, and the link to each download is as below:

After successfully completing the configuration wizard, i was browsing project site to relate document to particular task in project to verify if the absence of icon issue is resolved. So first to confirm that its not resolved by Apr CU, i.e. document indicator still not appearing along with the task in project views, however document indicator will appear in project center views along with the project name.

But this is not the issue i am blogging it about 🙂

While verifying this issue, i came across another issue i.e. when trying creating  risk/issue i found this message at the bottom of the page:

The Server was unable to save the form at this time. Please try again.

This paper is written by Microsoft senior consultant, and it includes guidance and best practices for those who plan to implement Project Server 2013 in their organization. 

It provides an analytic comparison of both the Project Online solution versus implementing a Project Server 2013 on-premises solution, and describes scenarios in which you would select one solution over the other. 

The target audiences for this white paper are partners, consultants, decision makers, and technical personnel who need to understand what is required to successfully implement Project Server 2013 in their environment, whether it be an on-premises solution or an online solution with Office 365.

Good Luck.