View Khurram Jamshed's profile on linkedin

Friday, December 16, 2011

Virtual Migration Environment for Project Server 2010 Issue

While migrating Project Server 2003 data to Project Server 2010, since it cannot be done direclty, i had to use Project Server 2007 environment as an intermediate step. For this Microsoft has provided a Project Server 2007 Hyper-V Virtual Migration Envrionment with all the data migration scripts pre-loaded on the VM. This all makes life prety easier in terms that you dont have to be worried about such issues of preparing a VM with Project Server 2007 etc. etc.

The reason i am writing this blog is the issue you will come across when you will provision your PWA 2007 first time using the migrated DBs, you click on Project Center to witness if all your hard work has paid off and BINGO - nothing appears there :(  You can check Resource center and similar message waiting for you there as well and no resource data appears in the grid.

How to resolve this? quite simpe actually, Dynamic Content Compression must be disabled in Internet Informtion System. It is on by default in Windows Server 2008 R2, having dynamic content compression enabled can cause issues if you need to make corrective changes to your Project Server 2007 data in the VME (specifically issues with project/resource center grid, editing custom fields and resources).

To disable Dynamic Content Compression, follow the steps in VME:

1. On the Project Server VME, click Start, click Administrative Tools, and then click Internet Information Services (IIS) Manager.

2.  In Internet Information Services (IIS) Manager, in the Connection Pane select VME (VME\Administrator).


3.  In the VME Home pane, in the IIS section, click Compression.
4.  In the Compression section, deselect Enable dynamic content compression to disable it.

5.  In the Actions pane, click Apply to save the change. The Alert “The changes have been successfully saved” displays if the change has been applied successfully.

6.  Close Internet Information Services (IIS) Manager.

This is all guys, hope this helps some of you - happy migrating, cheers.

MS Project and Project Server 2010 Dec CU

The December Cumulative Updates (CU) for Project and Project Server 2010 and 2007 have been released.  Details can be found on Brian Smith's blog, update contains number of fixes of Project Server and Project both so better run the CU on test environment prior to deploy on production.

http://blogs.technet.com/b/projectadministration/archive/2011/12/14/microsoft-project-server-and-sharepoint-server-2007-and-2010-december-2011-cu-announcement.aspx

You can also join in January the TechNet webcast covering both Project Server 2010 and Project Server 2007 Dec CU.

https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032493964&culture=en-us

Happy patching.

Saturday, November 26, 2011

MS Project and MS Project Server 2010 OCT CU

The October 2011 Cumulative Updates for Microsoft Project and Project Server 2010 have now been released. The 2007 Server packages that were withdrawn for a short period are now re-built and available. For details you can visit Brian Smith blog where all the links of the server roll-up packages are also available.

As Project Server 2010 is now based on SharePoint Server 2010 Microsoft strongly recommend that you install the Project Server 2010 Server Rollup Package as there are a large number of individual server packages for SharePoint Server. The Project Server 2010 Server Rollup Package contains all the patches released in this Cumulative Update for SharePoint Foundation Server 2010, SharePoint Server 2010 and Project Server 2010.

And last, always try the updates on the test environment first, untill then happy patching.

Preparing Hyper-V VM with Project Server 2010 Demo Pack

Recently i was preparing my new laptop to run the Project Server 2010 Hyper-V VM and i came across few issue while setting up my machine to run VM. Although its been long since the Information Worker VM and Project 2010 pack is out for MS Partners and Customers to evaluate and for demo purposes, but thought that its a good idea to put all the bits together for others reference again.

To run the MS Hyper-V VM you need to have the Virtualization enabled system to support the Hyper-V functionality, and the Hyper-V manager is only available on Windows Server 2008 and Windows Server 2008 R2 so far. But the good news is that it will be availabe on Windows 8 platform, so you dont have to prepare the dual boot system, but till then install the Windows 7 on your C drive and install the Windows Server 2008 on seperate drive (C or E or etc.) to have the dual boot option. There are lot of material available over the web related to the dual boot, you can go through this for your reference. There is also an excellent blog posted by Jan Kalis some time back about useful tips for Demo here.

While installing and running the Windows Server 2008 R2 for the first time, when you open the Server Manager to enable the Hyper-V role or any other role you might come across this issue:
  • roles and features are not displayed with a yellow bang against them in the Server Manager window. You receive the following error message at the bottom of the Server manager if you try to open it:
    • Server Manager
    • Unexpected error refreshing Server Manager: The remote procedure call failed. (Exception from HRESULT: 0x800706BE)
For more information, see the event log: Diagnostics, Event Viewer, Applications and Services Logs, Microsoft, Windows, Server Manager, Operational.
At the same time, the event below is added into the Microsoft-Windows-ServerManager/Operational log:

  • Log Name: Microsoft-Windows-ServerManager/Operational
  • Source: Microsoft-Windows-ServerManager
  • Date: <date & time>
  • Event ID: 1601
  • Task Category: None
  • Level: Error
  • Keywords:
  • User: <user name>
  • Computer: <computer name>
  • Description:
  • Could not discover the state of the system. An unexpected exception was found:
  • System.Runtime.InteropServices.COMException (0x800706BE): The remote procedure call failed. (Exception from HRESULT: 0x800706BE)
  • at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
  • at Microsoft.Windows.ServerManager.ComponentInstaller.CreateSessionAndPackage(IntPtr& session, IntPtr& package)
  • at Microsoft.Windows.ServerManager.ComponentInstaller.InitializeUpdateInfo()
  • at Microsoft.Windows.ServerManager.ComponentInstaller.Initialize()
  • at Microsoft.Windows.ServerManager.Common.Provider.RefreshDiscovery()
  • at Microsoft.Windows.ServerManager.LocalResult.PerformDiscovery()
  • at Microsoft.Windows.ServerManager.ServerManagerModel.CreateLocalResult(RefreshType refreshType)
  • at Microsoft.Windows.ServerManager.ServerManagerModel.InternalRefreshModelResult(Object state
Here is the Microsoft support article to resolve the issue, the only point you have to be careful about is the drive letter to access the folder mentioned in this article. The common mistake you can do is to use C drive, although most likely you have windows 7 on your Drive C and Windows Server on Drive D or E may be. So be careful else you will end up finding nothing and this will increase your frustation :)

Now once done with this, enable the Hyper-V role and follow the VM Setup Guide that consist of all the details of how to set-up your information worker VM to start the for first time. Assuming you have successfully import the VM to Hyper-V manager and managed to start, now its the Project 2010 Demo pack you have to install now. On the surface the demo pack appears to install without issue.

Installation Complete

But when you try to navigate to http://project.contoso.com/PWA you get the dreaded ‘An unexpected error has occurred’.

An Unexpected Error has occurred

On navigating the Central Administration > Application Management > Manage Service Applications > Project Server Service Application and checking the provisioned Project sites, it appears that no Project Server Web App sites have been provisioned, even though the demo installer reported it was successful.

No Project instances provisioned


It seems that the installer runs into an issue when the underlying demo VM has either expired or was not activated prior to installing the Project Demo and Eval pack. Luckily, fixing the problem couldn’t be simpler.

Firstly, follow the instructions in VM Setup Guide to activate the VM. To Activate the Virtual Machine an internet connection is required.  To do this, add a second NIC to the VM using the Hyper-V management console & connect it to an external network connection that has internet access.  Activate Windows from within the VM.  Windows will still expire after 180 days, but it will not prompt for activation or shut down after 2 hours.

Once the VM has been activated, you should see the following.

Activation Successful

As the demo installer has done most of the hard work, including restoring the various databases, creating the web application and configuring things like the Secure Store and Excel Services, all that is remaining is to (re)provision the Project Web App site using the restored databases. To do so, navigate to Central Administration > Application Management > Manage Service Applications > Project Server Service Application and choose to ‘Create a Project Web App Site’.

In the web page, choose the ‘project’ web application to host the Project Web App as per below.

Project Web App - Configuration 1

Then enter the names of the databases that were previously restored as per below and click on ok.

Project Web App - Configuration 2

After a short while the Project Web App site will provision and http://project.contoso.com/PWA will be accessible without the dreaded ‘An unexpected error has occurred’.

Happy evaluating :)

Tuesday, September 27, 2011

My View: Project 2010 & Project Server 2010 Certifications

This post was long been pending from my side, recently i have passed the following Project 2010 and Project Server 2010 exams and would like to share my experience and tips to prepare for the exams:

Although i was slightly late to attempt for these exams, but i always appriciate the benefit of being certified in the practising technology and domain. And i belive that being certified helps you gains employer confidence, and validate, your product knowledge.

So few tips for anyone of you out there who wants to attempt for the exam. There are certain knowledge areas related to each of the above mentioned exams, and if you validate your knowledge against those topics can help you pass the exam. For me Project 2010, Managing Projects were relatively more diffcult than Project Server 2010 exam, but for you it could be other way around. So here are few points you can consider while preparing For Project 2010, Managing Projects:

  1. Expect lot of questions related to the new features of Project 2010. Trust me if you know this good, more chances are that you pass the exam.
  2. Understand the positions of features and options on a new Office Ribbon User Interface.
  3. Knows the use of the new and old features of Project 2010 well. Now this is important, if you do not use Project in your everyday routine you might face some difficulty in this area.
  4. Understand the Task Types and their impact to a task's work, duration and resource assignment when one of these changes.

The way i have practised and prepared for the exams was: i have looked into the domain areas of the exam mentioned on the Microsoft Learning site under this particular exam page and verified my knowledge related to these skills. And i have used this book to study, Microsoft Project 2010 Step by Step. Its an easy to read and good to start with if you are beginner user of Project 2010. You might can find training classes or material based on the area you are located.

The Project Server 2010 exam, 70-177, covers the configuration areas of the product. You can also get scneario based question and asked for your expert opinion about the next step you should take. Unlike Project 2010 exam there are no such area from where you get the most of the questions. The best way to prepare for this exam is to go through the official skills measure page of the exam and verify your preparation. The number of questions from each skill area is based on the percentage mentioned for that area, and that is almost equal.

Please feel free to ask for any help related to the exams, be aware that these are the only two exams released so far for EPM 2010. For those who are planning to attempt the exam, I wish you good luck.

Sunday, September 4, 2011

August CU for Project and Project Server 2010

The August 2011 Cumulative Updates for Microsoft Project and Project Server 2010 have now been released. However there is a delay in server roll-up package due to late issue identified with the Sharepoint Foundation CU, and thus delays the release of the server roll-up packages. The server rollup patch is the preferred patch because it contains the fixes for all of the server technologies used by Project Server 2010. 

This delay does not affect the August 2011 Cumulative Update for Project and Project Server 2007.

Description of the fixes and and to download individual server package of Project Server 2010 can be found at the following link:

Individual Project Server Package:
http://support.microsoft.com/kb/2553047

For Project 2010 hotfix package:
http://support.microsoft.com/kb/2584056

My advice, as always, is to test any CUs with a recent copy of your production database before deploying into production to prevent issues with your production server.

For more details, visit Brian Smith blog.

Happy patching.

Wednesday, August 31, 2011

Tech-Ed Australia 2011

Tech-Ed Australia 2011 is live now, from 30th Aug - 2nd Sept 2011. And I would like to take this opportunity to spread the word about our fellow EPM Consultant and MVP, Alexander Burton, Tech-Ed Australia 2011 sessions. He will be taking part in following two sessions:

The Sharepoint Developers Guide to Project Server 2010

It’s just meant to be – Project Server and SharePoint server are better together, and this is the session that will show you why. Come and join us as we take you on a tour showing how the two products work together, and how you can deliver better solutions by integrating the two. Get to know how developers can leverage both of these great tools together and how you can deliver more value, what the features of the tools can offer and what you need to know as a developer to start solving real world business problems.

Ask a SharePoint expert Q/A panel

Join the SharePoint End / Business user ‘experts Alexander Burton. Dan Holme, Ben Walters & Bhavik Merchant for a open forum Q&A panel in the SharePoint Interactive Theatre in the Expo hall, sponsored by AvePoint.

More over videos of the session shall be available online after the event here, I hope those who attend will have some great time. Good luck.

Tuesday, August 9, 2011

Project Server 2010 JUN CU Issue to Multi-Lingual Deployments

For those who are working with the Project Server 2010 multi-lingual implementations, please be aware of a recently discovered issue after the June CU and SP1 have been installed.  It would appear that we have a bug whereas all column headers in the Project Center and Resource Center grids appear in English, regardless of the selected UI language.  The issue appears to be related to the June CU, as an SP1 / SP1 language pack environment (without the June CU) does not display the problem.



Resolution:
Since there is no solution to avoid this so far, you can opt for one of the listed options below. This is basically to bring the importance of the issue to MS notice, because usually the MS time to resolve such issues based on its severity and wide impact to the users.

  1. There is a thread already posted on official Project Server forums, you can go and leave your feedback here.
  2. You can log your issue at support@microsoft.com 
  3. You can leave the comment on this blog post, OR send me an email through my blog "send me an email" option and i will forward your feedback to the related MS person. 

All the credit goes to the Quint Mouthaan to notifying the users about this issue on Project Server Forums, and also allowing me to post this on my blog to spread the word as much as possible.

Wednesday, August 3, 2011

Project Server 2010 and MS Dynamics AX 2012 better together

This is to announce the release of new White Paper explaining the integration of Project Server 2010 with Dynamics AX 2012 Financial and Project module. You can download the document from here.

This document explains the integration architecture for The Microsoft Dynamics AX 2012 and Microsoft Project Server 2010 and provides instructions for setting up integration between the two programs. By setting up integration between the two products, project managers can create projects in either of the products and synchronize project data between them. This solution enables you to draw on both the core project management capabilities in Project Server 2010 and the financial management capabilities in Microsoft Dynamics AX.

You can also go through this document to know more about New, Changed and Depreceated features for the Microsoft Dynamics AX 2010 here. This document provides a summary of new and changed features that are planned to be implemented in Microsoft Dynamics AX 2012. Additionally, it provides deprecated feature notices for features which are planned to be removed in Microsoft Dynamics AX 2012 or future releases.

Hope this excites you a bit :)
Leave comments if you think this post helps you by any means.

Sunday, July 24, 2011

Using Content Type to Hide Default Issue/Risk columns from Input Form

In my previous blog, Create/Manage Issue/Risk list centrally, i talked about How to create and manage Issue list centrally and how it helps the administrator to save lot of unwanted work. In this post i will explain another one of the great advantage you could achieve if you use content type to manage the lists. One of the frequently recieved clients request is: How to hide/remove default Issue/Risks columns from the Project site? Now you might wondering that what is so difficult about this :) but this is a tricky part, because removing/changing the default Issue/Risk list columns can cause you lot of trouble. But the good news is that you can do this without any issues if you are using content type, below are the steps for you:

1. Create Issue list content type, please follow my previous blog to create the content type.
2. Once created, go back to the list settings, and click on content type:



3. Here you will see all the default and custom columns we have added in the content type earlier, click on the one you want to hide from the form, in my case i will click on the "category" column:



4. And there you can set it to Hidden from the column settings:



And if you can now go and add new item to the Issue list, you will notice that category column appears no more on the form to bother the users. 



*23-0-2013**Update**
This is to update that there is an exception to the above process, i.e. hiding any of the default fields of Issues/Risks list available on project site. That even hiding of some fields can result in queue error, to be precise its the Links column available on these sites. Hiding this column cause queue error similar to the deletion of columns, so you need to leave this column as is in order to avoid queue errors.

Thanks to Dan Stopher, of EPM Partners, for finding this culprit :) Please see his blog for more details about the exception.

Share