Showing posts with label Updates. Show all posts
Showing posts with label Updates. Show all posts

Monday, 18 September 2017

SharePoint & Project Server 2016 Upgrade Error after Windows Update

Applies: SharePoint Server 2016, Project Server 2016

So, you have decided to apply Windows Server updates? Following this, it is important to remember to check if there are some pending updates for SharePoint and Project Server 2016. Sometimes there are security updates that apply to SharePoint and Project Server, which may not my not be obvious just by looking at the updates, prior to applying them.

After windows server updates are applied, it is best practice to ensure that your farm is in a healthy state. You can do this by running the SharePoint Configuration Wizard (SCW). If you have multiple Web/App Servers, Start by running this on the one that hosts the Central Admin (CA) portal.

You may encounter upgrade issue as shown in fig below.

#Blog_Upgrade Error

Fig (1) – SharePoint Config Wizard Upgrade Error

If this happens, run the below CMD on each of the Web/App Servers, starting with the main server (hosting the CA)

psconfig.exe -cmd helpcollections -installall -cmd secureresources -cmd services -install -cmd installfeatures -cmd applicationcontent -install -cmd upgrade -inplace b2b -force –wait

#Blog_Upgrade CMD

Fig (2) – Upgrade CMD

Hopefully this will resolve your issue, as per fig (3) below.

#Blog_Upgrade Successful

Fig (3) – Successful Upgrade

Hope this helps.

Sunday, 17 January 2016

Beware!! Jan 2016 Security Patch MS16-004 (KB3124585) Breaks SharePoint 2013

January Security Patch Can Break SharePoint 2013. Read more>>>

Please be mindful that just applying the security update for SharePoint servers, without the full SharePoint/Project Server CU can cause issues. I would high recommend that user don't enable Automatic Updates on SharePoint Server, but instead, download and install them manually. Be in control of what is being applied to the servers. Not only does a 'bad' patch break SharePoint, it cannot be uninstalled.

Monday, 5 December 2011

EPM2010 SP1 - How does it impact you? And, the Mystery behind Patching Process.

If you missed my last webinar, here is the link to download the PPT copy. Hope this helps.

Topics covered;

  • The key fixes and enhancements include in SP1.
  • Practical things you should consider and have in place before taking the leap towards patching.
  • Approach and best practices for patching your EPM/SharePoint environment.
  • FAQs
image

Thursday, 17 November 2011

Microsoft EPM/SP 2010 – SP1, How it Impacts you & the Mystery behind Patching (FREE MPUG Webinar)

Intended Audience/Role: PMs, PMO and EPM/SharePoint 2010 Administrators

Description

Eager to upgrade to Microsoft EPM/SharePoint 2010 Service Pack 1, but afraid of breaking something in the process?

Join veteran Microsoft EPM consultant, PJ Mistry, for this FREE 1.5 hour webinar discussing the ins and outs of Service Pack1. PJ will discuss how this will impact you if you are an existing user and thinking about upgrading and also the mystery behind the patching process. In this webinar, you will learn;

1. The key fixes and enhancements include in SP1.

2. Practical things you should consider and have in place before taking the leap towards patching.

3. Approach and best practices for patching your EPM/SharePoint environment. Applies to Service Packs and Cumulative Updates.

There are many myths and some uncertainty about how best to implement software updates for EPM/SharePoint. Attending this webinar will bring you a step closer to the light at the end of the tunnel.

 

Pointing upRegister for Webinars

Pointing upAbout the Presenter

image

PJ Mistry is the Director of Projects at Project Solution Ltd, based in Cambridge, United Kingdom. He is an avid evangelist of Microsoft SharePoint and Enterprise Project Management (EPM) with over 12 years hands-on field experience. His achievements include 10,000 user rollout of EPM and integration with SAP. His technical expertise has been a key ingredient in the development of some of the add-ons that fill the key gaps in the out-of-box offering/ capability of Microsoft SharePoint & EPM. To learn more visit: www.EPMAPPStore.com. Contact him at: PJ@ProjectSolution.com. Follow him on Twitter @EPMSolution or blog www.EPMGuy.com.

Wednesday, 2 November 2011

SharePoint 2010 SP1 and June CU Upgrade issues

I came across some issues after upgrading to June 2011 CU and wanted to share this with the rest of you. If any of these issues is a concern, then you should hold off applying June 2011 CU and apply Aug 2011 CU instead. See latest updates here.

There are some issues reported by end users on SharePoint 2010 SP1 and June CU. You may need to verify on your end. Here is the list of the potential issues for your reference from Harry Chen's blog.


1. Security validation error when people picker is on an infopath form.
http://ghamson.wordpress.com/2011/07/20/security-validation-issue-form-services-issue-with-sp1june-2011-cu-release-2-in-sp2010-sharepoint-msproject-projectserver/

2. Cannot provision new PWA sites through the GUI. Workaround is to create via powershell.  We have verified this is an issues on SP1 and June CU.
http://projectserverblogs.com/?p=4991

3. Unable to open Performance Point Dashboard Designer after SP1/June CU
http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010general/thread/4c71d238-d4ff-4320-833b-47985b36a8e1

4. JS Bug in grouped view since SP1?
http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010general/thread/ea9e87d5-5b5f-408e-a1bc-a6326ef458ad

5. SP 2010 Document Library Column "Show Filter Choices" is not ...
http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010general/thread/70c6cc25-d1c9-42cd-8d3d-463252e4e1f0

6.Sharepoint Wiki Link Creation Failing
http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010general/thread/d03f842b-71ae-492c-b083-2abde53068a9

7. SP2010 Column Filter causing Unable to display Web Part error and ...
http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010general/thread/44cfd798-be7a-4436-8786-bd44049e7def

8. Security validation issue
http://www.infopathdev.com/forums/p/20173/70028.aspx

9. June CU Unique Permissions \ People Picker Issue - This has been confirmed in our environments and Microsoft claimed it will be fixed in August CU.

http://social.technet.microsoft.com/Forums/eu/sharepoint2010setup/thread/7669d518-f7c9-4be4-9cd7-a1d5eae5ddd7


10. Update-SPProfilePhotoStore not working after SP1 + CU June 2011 - We are having issues to import pictures and it is an issue.

http://social.technet.microsoft.com/Forums/en-US/sharepoint2010setup/thread/b6f1789c-de63-429d-ab22-4bb5dd953770

11. BI status list display form missing source list after upgrade
http://sharepointconnoisseur.blogspot.com/2011/09/sharepoint-2010-sp1-and-june-cu-upgrade_14.html

SharePoint Connoisseur: SharePoint 2010 SP1 and June CU Upgrade issue #3 - Broken functions

Sunday, 23 October 2011

EPM/SharePoint 2010 – Aug 2011 CU, latest downloads

There has been some changes to the Aug CU packages as result of changes to SPF. Even though the article dates show Oct, these are NOT the Oct updates.

The version has been incremented to 14.0.6109.5005

After the upgrade, use the following PowerShell command to display the Farm version;

Get-SPFarm | Select -ExpandProperty BuildVersion

image

SharePoint 2010 Foundation

Article ID: 2553050 - Last Review: October 17, 2011 - Revision: 2.0

Description of the SharePoint Foundation 2010 cumulative update package (SharePoint Foundation server-package): October 13, 2011

clip_image001

Hotfix Download Available

View and request hotfix downloads

More info <http://support.microsoft.com/kb/2553050>

SharePoint 2010 Server

Article ID: 2553048 - Last Review: October 17, 2011 - Revision: 2.0

Description of the SharePoint Server 2010 cumulative update package (SharePoint server-package): October 13, 2011

clip_image001[1]

Hotfix Download Available

View and request hotfix downloads

More info <http://support.microsoft.com/kb/2553048>

Project Server 2010

Article ID: 2553049 - Last Review: October 17, 2011 - Revision: 2.0

Description of the Project Server 2010 cumulative update package (Project server-package): October 13, 2011

clip_image001[2]

Hotfix Download Available

View and request hotfix downloads

More info <http://support.microsoft.com/kb/2553049>

Project 2010

Article ID: 2584056 - Last Review: September 1, 2011 - Revision: 1.0

Description of the Project 2010 hotfix package (project-x-none.msp): August 30, 2011

clip_image001[3]

Hotfix Download Available

View and request hotfix downloads

More info <http://support.microsoft.com/kb/2584056>

Pointing upKnown issue 1
After you install this hotfix, you must restart the User Profile Synchronization Service for profile synchronization to work correctly.
Workaround
To work around this issue, follow these steps:

  1. Visit Central Administration.
  2. Click Manage Services on the System Settings section.
  3. Find User Profile Synchronization Service in the list of services and then click Stop if its status is Started. Click Start and provide the credentials to start the User Profile Synchronization Service as soon as its status is Stopped.

Light bulbNote

This is build 14.0.6109.5005 of the cumulative update package.
I would recommend that you test hotfixes before you deploy them in a production environment. Take necessary backups before attempting to upgrade.

Because the builds are cumulative, each new release contains all the hotfixes and security updates that were included with the previous update package releases.

High fiveHow to Deploy Aug 2010 CU Updates?

Earlier there were different camps recommending different approaches.  SharePoint folks recommend applying SPF and then SPS updates. If in doubt, I would suggest a blended/safe approach;

  • First of all, ensure your system is at SP1 level
  • Then apply (SharePoint Foundation 2010 Aug CU) + (SharePoint Server 2010 Aug CU) + (Project Server 2010 Aug CU)

Obviously, you don't need to deploy SharePoint Server or Project Server updates if you are running only SharePoint Foundation 2010.

Observe the best practice of updating the binaries first (on all web/app servers, one at a time) and then upgrade by running the SharePoint Config Wizard (on all web/app servers, one at a time starting with the one hosting the Central Administration). Some of you have asked for some detailed steps and this will follow next week.

Thursday, 13 October 2011

What You Need to Know about Project Server 2010 Service Pack 1, Part 1:

The release of Service Pack 1 for Project Server 2010 and Microsoft SharePoint marks a major milestone in the product development lifecycle. All fixes prior to the June 2011 Cumulative Update (CU) are included in SP1. In addition, there are some key enhancements included in SP1 that users will appreciate, from new browser support to site storage metrics. In this article I cover seven of the most interesting and useful updates.

Read more: http://tinyurl.com/6ah4fob

In my next article, I'll lay out a basic plan for you to follow in implementing Service Pack 1.

SP1 WebNLearn! Sign up to join PJ Mistry for an MPUG WebNLearn session on Nov 29, 2011 that explores what you need to understand about the contents and implementation of Service Pack 1!

Tuesday, 9 November 2010

SharePoint & Project Server 2010 October CU – Critical Info

Microsoft has discovered a critical issue in the recently released October Cumulative Updates for SharePoint Server 2010 and Project Server 2010, and have removed the files from download availability.  If you have already downloaded the CU, do not install it.  If you have installed the CU, please contact Microsoft Support for assistance.  Microsoft will be posting additional information about the issue as soon as they have it, and will make the Cumulative Update available for download again as soon as the issue has been fully resolved.

Issue Details

The October Cumulative Update makes some changes and updates to the user profile database.  Unfortunately there are certain situations where this update does not complete as expected and leaves the update in an inconsistent state.  This causes issues with several SharePoint features that use the User Profile Application such as MySites, People and Expertise Search & Ratings.

If you have already applied the October Cumulative Updates

You should perform the following steps below;

Note: If you encounter any issues following these steps or have questions specific to your environment/deployment please call Microsoft Product Support for assistance.

Check the following locations for the Microsoft.Office.Server.dll to determine the version. If the version is 14.0.5128.5000 or greater, the October CU is applied.

  • C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\ISAPI\Microsoft.Office.Server.dll
  • C:\Windows\assembly\GAC_MSIL\Microsoft.Office.Server\14.0.0.0__71e9bce111e9429c\Microsoft.Office.Server.dll

Using Central Administration perform the following steps

  1. Click on Manage Service Applications
  2. Select User Profile Service Application by clicking on it
  3. At the top of the screen on the Service Applications tab, click on Manage
  4. On the Manage Profile Service: User Profile Service Application page, click Manage User Permissions
  5. On the Permissions for User Profile Service Application dialog, you will need to;
    • Specify the desired user accounts and click the Add button to add them to the list
    • By default SharePoint 2010 RTM has these accounts;
      • NT Authority\authenticated users
      • All Authenticated Users
  image
    • Once the user accounts are in the list, you will need to set the permissions appropriately for your environment and click OK.

Note: info as received from Microsoft SharePoint Team

Tuesday, 19 January 2010

SQL Server 2008 CU9

If you have SQL Server 2008 in your EPM/SharePoint environment, you may interested in the latest SQL 2008 CU9. Review the fixes in particular for Analysis Services and SQL Reporting.

Hotfix download is available
Hotfix Download Available
View and request hotfix downloads

Cumulative update package 9 for SQL Server 2008

Monday, 18 January 2010

EPM2007 – What is my system patch level? download latest ‘complete’ package

Find out if you have the latest patches. Compare version numbers against figure below. Download single ‘complete’ package containing all latest updates?

EPM2007 Updates

(click picture to enlarge)

- How to verify EPM updates and patch level?

Hope this helps.

Thursday, 2 July 2009

EPM2007 Updates Catalogue (Post SP2)

Here is a catalogue of key Microsoft Project Sever 2007 updates and KBs post SP2, organised in chronological order. All in one place!

The update application and verification process is encapsulated in the figure below. Click figure below to open. 

EPM2007_UpdateApplication_1 EPM2007_Updates

 Updated: 10th Jan 2010

MS KB Article KB Date Description Summary / Resolution My Comments

977022















977028
















977266











977023


December 15, 2009

 

 

 

 

 

 

December 15, 2009

 

 

 

 

 

 

 

December 15, 2009

 

 

 

 

December 15, 2009

 

Windows SharePoint Services 3.0 Cumulative Update Server hotfix package (Sts-x-none.msp): December 15, 2009

Some key issues fixed;
1.    After you create a calculated column that includes a reference to the hidden ID column in a Windows SharePoint Services 3.0 environment, the CPU usage increases to 100%.
2.    When you upload some files to a Windows SharePoint Services 3.0 Discussion Board, multiple duplicated discussion items appear unexpectedly.
3.    In a Windows SharePoint Services 3.0 site, after you add an additional choice to the Task Status site column, workflow tasks that have a Task Status of Completed cannot be viewed.

<Refer to other fixes in the associated KB>


Project Server 2007 hotfix package (Pjsrvapp-x-none.msp, Pjsrvwfe-x-none.msp): December 15, 2009

Some key issues fixed;
1.    When you change the calendar for a resource, the actual work that is already reported is recontoured.
2.    When you change the base calendar for a resource, the total actual work value for an assignment remains the same. However, the dates on which the work appears are changed.
3.    If there are no resources assigned to a task, assignment views display the incorrect number of work hours in Microsoft Office Project Web Access.A queue save job takes a long time to finish. This problem typically occurs when projects are very large and have many defined custom fields.
<Refer to other fixes in the associated KB>



Project 2007 hotfix package (Project-x-none.msp): December 15, 2009
This hotfix fixes the following key issues;
1.    When you copy and paste a duration column to another duration column, all assignment-level actual work changes to zero. The task-level actual work remains unchanged.
2.    Remaining Work is recalculated for some tasks when some actual work is entered in a different task.
3.    The Free Slack value is calculated incorrectly for two linked tasks that have Finish No Later Than and Start No Earlier Than constraints.
<Refer to other fixes in the associated KB>

SharePoint Server 2007 Cumulative Update Server hotfix package (Coreserver-x-none.msp): December 15, 2009

Some key issues fixed;
1.    If a profile import occurs during the time that domain controllers in a domain are unavailable, the profiles for that domain are marked as "Profiles missing from import."
2.    Issue with Alternate Access Mapping
3.    A Date type cell in a .xlsx file is treated as a Number type cell by the IFilter component when the cell to the left of the Date type cell has a style applied but does not contain a value.

<Refer to other fixes in the associated KB

High recommended considering the issues fixed in WSS, Project Server and Project especially resource calendar issue.

Process for existing deployments; SP2 + Dec CU Process for NEW deployments; RTM + SP2 + Dec CU Apply this CU only if you are encountering types of issues fixed.  

975002
















974990















975923















974988

October 27, 2009















October 27, 2009














October 27, 2009














October 27, 2009

Windows SharePoint Services 3.0 Cumulative Update Server Hotfix Package (Sts-x-none.msp): October 27, 2009

Some key issues fixed;
1.    You run a crawl for some Lists or Surveys, and you receive access violation error messages
2.    You upload a file to a Windows SharePoint Services 3.0 site, and the custom content type that you selected from the New menu is not used
3.    You encounter performance problems when you run a crawl on a Windows SharePoint Services 3.0 site
4.    Users who have read permission do not receive alerts for drafts or for minor version documents when the Content Approval option is enabled in a Windows SharePoint Services 3.0 site

<Refer to other fixes in the associated KB>


Project Server 2007 hotfix package (Pjsrvapp-x-none.msp, Pjsrvwfe-x-none.msp): October 27, 2009

Some key issues fixed;
1.    If you add specific fields to the Summary view on the Resource Assignments page, the view is broken and cannot be displayed. The following fields cause this problem: Task ID, Unique ID, Outline Number, and Duration.
2.    When you add lines to a timesheet that contains custom fields, the data in the custom fields is lost.
3.    An Active Directory sync fails if the enterprise custom fields have default values.
4.    When you try to save a resource plan, the resource plan cannot be saved.
5.    The Project Web Access regional setting issue

<Refer to other fixes in the associated KB>

Project 2007 hotfix package (Project-x-none.msp): October 27, 2009
1.    This hotfix fixes the following key issues; You assign cost resources and work resources, or material resources and work resources to the same task in Office Project 2007 and tasks are in progress. After you publish a project, the Reporting (Project Publish) queue job takes a long time to be completed.
2.    You expand a sub project from a master project and make a change. Then, you open the same sub project by itself within the same session. You cannot save the sub project. Additionally, Office Project 2007 crashes.

<Refer to other fixes in the associated KB>

Prerequisites
You must have 2007 Microsoft Office suite Service Pack 2 or 2007 Microsoft Office suite Service Pack 1 installed to apply this hotfix package.


SharePoint Server 2007 Cumulative Update Server Hotfix Package (MOSS server-package): October 27, 2009

This hotfix contains Project Server 2007 updates.
Prerequisites
To install this hotfix, you must have 2007 Microsoft Office Servers Service Pack 2 or 2007 Microsoft Office Servers Service Pack 1 installed.

Apply this HF only if you are affected for example WSS crawl, mixed resource assignment save time issue etc. I would recommend not mixing the resource types on same tasks.

Process for existing deployments; SP2 + Oct CU Process for NEW deployments; RTM + SP2 + Oct CU Apply this CU only if you are encountering types of issues fixed. 

973410 WSS3
(Aug CU)








973937 PS2007
(Aug CU)















973930 P2007
(Aug CU)

 

 

973409 MOSS
(Aug CU)

 

August 25, 2009
Rev: 1.0







August 25, 2009
Rev: 1.0














August 25, 2009
Rev: 1.1




August 26, 2009
Rev: 1.0
Windows SharePoint Services 3.0 Cumulative Update Server Hotfix Package (Sts.msp): Aug 25, 2009
This hotfix fixes the following key issues;
  • custom site content types - cannot create a new child content type
  • calculated column - "The SQL server might not be started" error message
  • rename a folder name - the approval comments for the document are removed unexpectedly
  • <Refer to numerous updates in the KB>

    Project Server 2007 hotfix (Pjsrvapp.msp & Pjsrvapp.msp): Aug 25, 2009

    This hotfix fixes the following key issues;
  • submitting more than 100 task updates gives error
  • issue with Resource Assignment page
  • Total field at the bottom of Timesheet view is incorrect because overtime work values are doubled
  • Time-phased actual work is incorrect after you submit the actual working hours during nonworking time in PWA
  • When you assign cost resources and work resources or assign material resources and work resources to the same task in Project 2007, the reporting publishing job takes a long time.
  • <Refer to numerous updates in the KB>

    Note Before you apply the hotfix that is described in this article, delete temporary Internet files in Internet Explorer.

    Project 2007 hotfix (Project.msp): Aug 25, 2009

    This hotfix fixes the following key issues;
  • Inactive resources on 100% complete tasks on enterprise projects give warning message.
  • Issue with editing views in Enterprise Global.

    SharePoint Server 2007 Cumulative Update Server Hotfix Package (MOSS server-package): Aug 25, 2009

    Still confirming if this includes Project Server Aug CU (973937). Note: the KB is still in progress and public download is not available yet (checked 2nd Sep).

  • I am currently testing this CU.
    Following successful testing, I will be recommending applying this Aug CU which resolves the Admin issue of Enterprise Global views etc. 

    Process for existing deployments
    SP2 + Aug CU

    Process for NEW deployments
    RTM + SP2 + Aug CU

    Apply this CU only if you are encountering types of issues fixed.

    970946 WSS3
    (Jun CU)

     



    971502 PS2007
    (Jun CU)


     

     

     

     

     

     

    971501 P2007
    (Jun CU)

     

     

     

     

     

     

     

     

    971537 MOSS
    (Jun CU)

    3/07/2009
    Rev 2.0





    15/07/2009
    Rev 1.0















    01/07/2009
    Rev 2.0

















    22/07/2009
    Rev 2.0
    Windows SharePoint Services 3.0 Cumulative Update Server Hotfix Package (Sts.msp): June 30, 2009
    Key fixes include sub-site migration issues, issues with list with more than 500 items, issues with version control etc. Refer to numerous updates in the KB.
    Note: There is an additional WSS CU (971538) released end June for languages other than English.


    Project Server 2007 hotfix (Pjsrvapp.msp & Pjsrvapp.msp): July 15, 2009
     

  • The Tracking Method setting on the Task Settings and Display page is not applied to proposals or to converted proposals!
  • In Resource Usage view, the total work for summary resource assignments under the Other Projects and Commitments sections is wrong.
  • Issue with My Tasks page
  • In Project Professional 2007, the values for actual work differ from the values that are submitted by resources after you accept updates for assignments. These incorrect values are displayed on the My Tasks page if you save and publish the project after the data is changed by accepting the updates for assignments.
  • etc, refer to other details in the MS KB


    Project 2007 hotfix (Project.msp): June 30, 2009

    This hotfix fixes the following issues;

  • If an enterprise resource task assignment has 0 hours of work associated with it, the values that you see for the summary resource assignments under the Other Projects and Commitments sections in the Resource Usage view do not match.
  • If projects have complex contours and large amounts of actual work, the save process to Project Server 2007 takes a very long time in Project Professional 2007.
  • Performance is very slow when you insert custom field list items in the Japanese version of Project 2007 by using the CustomFieldValueListAdd Visual Basic for Applications (VBA) method .
  • You have resource leveling set to automatic. You also have a VBA event code that is running. After the event code runs, leveling no longer occurs automatically.
  • You create cross project links between tasks. When you change the scheduling of a task, the linked tasks are not updated.

    SharePoint Server 2007 Cumulative Update Server Hotfix Package (MOSS server-package): July 15, 2009

    Includes Project Server Jun CU (971502). If Project Server is deployed on a MOSS platform then apply this ‘combined’ MOSS update.

  • Apply this CU only if you are encountering types of issues fixed. If not, and you can wait until end Aug then I would recommend you apply the Aug CU which is earmarked to resolve the Admin issue of Enterprise Global views etc.  I will keep you posted on the Aug CU.

    Process for existing deployments
    SP2 + June CU

    Process for NEW deployments
    RTM + SP2 + June CU




    2000241 01/07/2009 Queue Job Status shows "Waiting to be processed" and then never completes

    Cause;
    Although there may be other causes for this error, this issue can occur when the SQL retry limit value is set to 0.

    Resolution;
    To resolve this problem, set the SQL Retry Limit value to the default value of 5 and then restart the Microsoft Office Project Server Queue Service. To do this, follow these steps in the KB.
    Apply the resolution if you are encountering this type of issue.

    Remember to also check if there any jobs that have may have failed and blocking correlation.
    2000163 27/06/2009 In Microsoft Project Web Access, when a project is published and a Project Workspace is created by a project manager, other project managers at the same level in the Resource Breakdown Structure (RBS) structure do not have access to the newly created workspace.

    Resolution: Refer to Workaround options in the KB.
    Alternative Resolution: Add user to project team and assign to project say a ‘dummy’ task.
    Does not affect you if your business processes dictates that PMs can only view edit own projects.
    971620 26/06/2009 During the installation of the 2007 Microsoft Office servers Service Pack 2, a product expiration date is activated incorrectly. If you have applied the manual fix then this does not concern you.

    Apply this patch only if affected.
    Apply SP2 + 968860 + 971620
    971562 26/06/2009 In the Resource Usage view, the total work for the summary resource assignments under the Other Projects and Commitments sections is wrong. Apply this patch only if affected.
    Apply SP2 + 968860 + 971562
    2000144 16/06/2009 The tasks status indicator states "Update has not been submitted" even though the task is submitted.

    Resolution:
    In order to display the correct indicator next to the task, click My Tasks in the left navigation pane to refresh the page. Alternately, click away from the My Tasks page and then go back to the My Tasks page. When you do this, the red exclamation point disappears.
    Update your internal end-user training material as appropriate.
    971217 02/06/2009 The SharePoint Products and Technologies Configuration Wizard fails after you install any cumulative update or service pack for Project Server 2007 that was released in October 2008 or later Highly recommended if you have a pre Oct 2008 patch level.
    Run the check script to identify potential upgrade issue.
    971202 11/05/2009 Actual Work entered in My Tasks changes when Non-work time is entered in My Timesheets in Microsoft Project Web Access

    Cause;
    This problem may occur when the Non-Work time typed into the timesheet is entered as a calendar exception into the resource’s calendar. Creating a Non-Work entry makes the resource unavailable for work for a portion of the day. The Work is timephased across the entire day and not in a specific period, resulting in a change in the entered Actual Work for the same day. There may be an overlap of Work time entered in My Tasks and Non-Work time entered in My Timesheets. This problem occurs even if the total number of hours reported does not exceed the resource’s availability for that day.

    Workaround options;
    Project members should enter overhead time in “My Timesheets” BEFORE they enter the billable time “My Tasks”.
    OR
    Enter time in the “My Timesheet” category, then import it into “My Tasks” category using the Import Timesheet feature in Project Web Access.
    Update your business processes as necessary to accommodate these workaround options.
    971189 11/05/2009 Outlook freezes when typing an e-mail message when the Project Web Access add-in is installed Apply this patch only if affected.
    Apply SP2 + 968860 + 971189
    971066 13/05/2009 In Project 2007, the values for actual work differ from the values that are submitted by the resources after you accept updates for assignments. These incorrect values are displayed on the My Tasks page if you save and publish the project after the data is changed by accepting the updates for assignments. Apply this patch only if affected.
    Apply SP2 + 968860 + 971066
    968860
    (Apr CU)
    30/Apr/2009 Project Server 2007 Post SP2, April Cumulative Update (CU). Key fixes include;
    Issue with editing a custom field through PWA affecting
    booking type issue
    Milestone progress issue
    Issues with PWA > My Tasks page
    Issues with PWA updates and approval
    "Check-in pending" issue
    Review the full list in the KB for further details.
    Highly recommended as this has has key updates.
    Apply SP2 + 968860

    Note: This posting is provided "AS IS" with no warranties, and confers no rights.Test all updates thoroughly on a ‘replica’ development/test environment prior to applying on your production environment.

    Wednesday, 1 July 2009

    SP2 issue – fix for product expiration date activated incorrectly

    MS Article ID: 971620

    During the installation of the 2007 Microsoft Office servers Service Pack 2, a product expiration date is activated incorrectly. This means that the product will expire 180 days after Service Pack 2 is deployed, as if it were a trial installation.

    If you have applied the manual fix then this does not concern you. If have not and or are planning SP2 upgrade, then the recommended solution is to apply the following updates available from the Microsoft Download Centre:

    When you install the 2007 Microsoft Office servers Service Pack 2, the product expiration date is activated incorrectly

    Note: for background, refer to previous post regarding this.

    Sunday, 28 June 2009

    Microsoft Support Lifecycle

    I had a query from a customer regarding MS Office software support lifecycle. Below is some info from Microsoft that might be interesting.

    Microsoft provides support on the current service pack, and in some cases the immediately preceding service pack, for the products listed below. See the Lifecycle Support Policy FAQ for details on the Service Pack Support Policy. As a convenience to you, Microsoft is providing a list of the currently supported service packs: Supported Service Pack List. If you have any questions regarding support for a product, please contact your Microsoft representative. If you need technical support, visit the Contact Microsoft Web site.

    MSProductLifecycle

    (click picture to enlarge)

    Microsoft Support Lifecycle

    Wednesday, 13 May 2009

    EPM2007 Post SP2 Apr CU – Fixes and Verification

    You may be aware that post SP2 April CU was released towards end of April.
    Issues that are fixed by this HF package are detailed below;

    Project Server

    1

    When you edit a custom field through PWA for a project plan that has in-progress tasks, and then you reopen the project in Project 2007, the duration and percentage complete for these tasks are unexpectedly changed.

    2

    After you accept updates for assignments, Project 2007 shows different contours for actual work and for actual overtime work. If you save and publish the project, the resource's timesheet on the My Tasks page shows the same incorrect contours.

    3

    By default, the booking type for all resources is Proposed. This may cause issues. For example, assume that the resource booking type is set to Proposed for the enterprise resource. However, in the project, the same resource’s booking type is set to Committed. After you change the details about the resource and then publish the project plan, the booking type in the project changes back to Proposed. Therefore, resource pending updates for that project are lost. Additionally, resources cannot see their work on the My Tasks page.

    4

    Milestone becomes 100-percent completed if one of the following conditions is true:

    · You use the QueueUpdateProject Project Server Interface (PSI) method two times to update the task constraint date.

    · An update is made to a predecessor task.

    5

    On the approvals page, the timephased view starts at the beginning of the affected tasks instead of the date range where the new updates are at. For example, assume that you have a task that begins January 1 and ends December 31. Also assume that it is now May, and when you visit the updates page, you see the timescale starting in January instead of in May. This means that you have to scroll to the new May updates.

    6

    On the My Tasks page in Project Web Access (PWA), you perform grouping on one or two fields. In the list of tasks or assignments, if the leaf on which the grouping is performed is clicked, no tasks or assignments are displayed. Additionally, you receive the following error message:

    The indicated project is not available in Project Centre.

    7

    After you accept updates and periods on the My Tasks page, an actual work contour of 0 hours is added to dates after the last date that has actual work for some assignments. This causes actual work to redistribute across the period.

    8

    When you set the site regional settings as Swedish, Norwegian, or Finnish in PWA, the sorting order in the Select Task – Webpage Dialog box is incorrect if one or more of the Å, Ä, or Ö characters is included in a project name.
    In this situation, the sorting order in the Select Task – Webpage Dialog box starts by listing all the projects first, followed by all tasks.

    9

    When you visit the Assignment Details page directly from the My Tasks view, the Gantt Chart is always set to use the date range of the current date instead of the range that is set in My Tasks view.

    10

    On some assignments, when a task update that has actual work hours is submitted from PWA and accepted by the project manager, additional hours of actual work are incorrectly added to that assignment.

    11

    On the My Tasks page in PWA, if the data is displayed as being timephased, and any grouping is applied, you may receive the following error message when you try to print the view:

    The "TaskPart" Web Part appears to be causing a problem. Object reference not set to an instance of an object.
    Web Parts Maintenance Page: If you have permission, you can use this page to temporarily close Web Parts or remove personal settings. For more information, contact your site administrator.
    Troubleshoot issues with Windows SharePoint Services.

    12

    If an enterprise resource task assignment has 0 hours of work associated with it, the values that you see for the summary resource assignments under the Other Projects and Commitments in the Resource Usage view may not match.

    13

    When you search specific Korean characters on the Edit Project Properties page, you may receive the following error message:

    This project is currently checked out. No edits can be made to it while it is checked out.

    Note This issue does not occur on the Manage User page when you search the same characters. The same issue also occurs in an English-language environment if you search some Chinese characters.

    14

    On the My Tasks page, you enter time on the Gantt Chart for a multiple-week task. However, after you click Save All, some time may not be saved.

    15

    When you delete a timesheet line in PWA and then add another line, the added line is empty. Additionally, you receive the following error message:

    While communicating with the project server an error occurred. Check connectivity with your administrator to determine if further action is necessary.

    16

    The Resource Assignment page returns no data when the filter that is applied is based on an enterprise custom field.

    17

    When you delete resources in PWA or through the PSI, the deletion fails, but no error is returned to tell you why the deletion failed.

    PWA version – Check the version of PWA via SITE SETTINGS, should read: 12.0.0.6504.
    (click picture to enlarge)
    Project Server Database Version Table. The alternative is to check the Project Server Database Version Table. Right click on the Version table and select ‘Open Table’.
    The version should read: 12.0.6503.5000.
    (click picture to enlarge)
    I would recommend checking all the four Project Server databases rather than simply focusing on the Published DB. The version number should be the same in all the four DBs.

    Project Professional 2007
    This update should put the final 'nail in the coffin’ for the on-going project ‘check-in pending' issue.

    1

    In Project 2007, in the Open dialog box, when you sort projects by using the Last Modified field, the sorting is incorrect.

    2

    In the Task Usage view, the ACWP field is not displayed correctly in the grid pane.

    3

    After you accept updates and periods on the My Tasks page, 0 hour actual work contours are added to dates after the last date that has actual work for some assignments. This causes actual work to redistribute across the period.

    4

    After you perform a recalculation, task names disappear if a certain grouping type exists in the project plan.

    5

    Baseline values are reset when you save an .eds file to the server.

    6

    In Project Web Access (PWA), you check in a project. Then, you open this project in Project 2007. However, this project displays a status of "Check-in pending."

    7

    Project 2007 returns unexpected leveling results when you level on a day-by-day basis in Project 2007.

    8

    A project file together with child project is not checked in when you click the Close button (the "X" at the top of the window) to exit Project 2007.

    9

    If the total value length of a field exceeds 255 characters, you cannot filter custom fields.

    To check if Project Professional 2007 has been upgraded correctly, review the version under Help > About Microsoft Office Project.
    The version should read: 12.0.6503.5000

    (click picture to enlarge)

    Monday, 4 May 2009

    Service Pack 2 for EPM2007 - How to verify installation?

    After the installation of SP2, the following methods can be used to confirm if the updates have been successfully applied;

    Server;

    1) PWA version – Check the version of PWA via SITE SETTINGS

    The version should read: 12.0.0.6421.



    2) Project Server Database Version Table. The alternative is to check the Project Server Database Version Table. Right click on the Version table and select ‘Open Table’.
    The version should read: 12.0.6422.1000
    I would recommend checking all the four Project Server databases rather than simply focusing on the Published DB. The version number should be the same in all the four DBs.
    Note: I have experienced a situation where the ProjectServer_Reporting DB failed to upgrade in Step 8 of 9.



    Client;
    To check if Project Professional 2007 has been upgraded correctly, review the version under Help > About Microsoft Office Project.
    The version should read: 12.0.6423.1000


    Note: The SP2 update includes all the updates upto and including Feb CU.

    Saturday, 2 May 2009

    Service Pack 2 for Project Professional & Project Server 2007

    The key changes/updates for Project Professional and Project Server 2007 are detailed below.

    Key Updates for Project professional;

    Enhancements/DCR;

    For those who have struggled with issue of ordering of Enterprise Project Templates, you will be pleased to hear that this is now fixed with SP2.


    Also refer to previous post regarding this. http://microsoftepmsolution.com/2009/04/ordering-enterprise-project-templates.html

    Summary of Issues Fixed;

    There are a number of changes to improve stability and reliability. Summary is shown below;

    1. Language packs - Fields that were inaccessible from within Project pro are available
    2. Active Cache checkin pending issues
    3. Saving to previous versions of mpp file formats
    4. scheduling engine fixes, VBA issues and Gantt Chart Problems

    See below for full list of changes to Project Standard/Professional 2007;

    1

    Consider the scenario in which a project has been edited and saved by one user and then while that user has the project open, it is force checked in. Then, a second user opens the project and clicks Cancel on the message telling them that the project has been modified by another user. The second user opens it again and instead of seeing the message again, the project opens, and the edits of the first user are lost.

    2

    Custom code that uses the Project object model to update custom field lookup tables did not perform quickly. For instance, code that updates 1000 lookup table records that used to take about two minutes now takes a few seconds.

    3

    For Project Professional languages that support phonetics, the custom field "Add Field to Enterprise" functionality does not work if a custom field has a lookup table and if any of the phonetic values are blank.

    4

    If changes are made and saved to a checked-out offline project and then the project is published immediately after Project Professional is connected back to the server, Project may not actually publish the information.

    5

    If the Active Cache size limit is exceeded when you save an already-open project, you receive a warning message telling you the cache size has been exceeded. However, the project is not saved.

    6

    If you assign a cost resource to a task using the resource initials field, Project crashes.

    7

    If you have a Fixed Units task with a Must Finish On constraint, when you edit timephased actual overtime work, the task behaves like a Fixed Work task instead. This means that when you change the task's duration, the assignment's units change instead of the work value.

    8

    If you have nested subprojects and you open the top level master projects as read-only, the nested subprojects may get opened with read-write access instead of being opened read-only.

    9

    If you save a project to the XML file format, and you have a resource where the maximum units are less than 100 percent, the maximum units change to 0 percent or to 100 percent when the XML file is opened.

    10

    If you save to the 2003 MPP format, you may find that tasks you deleted reappear as blank rows. For example, you have three tasks, T1, T2, and T3, with IDs 1, 2, and 3. You delete T2. Instead of T3 becoming task ID 2, it is still task ID 3, and a blank row is where T2 used to belong.

    11

    If you use the Gantt Chart Wizard, the Gantt bar names as seen in the Bar Styles dialog box are changed to unrecognizable characters.

    12

    In Project 2007, you open a Project 2003 MPP file that contains a large lookup table. This may take a very long time.

    13

    In some cases, when a project is saved to the server and the save process fails, the next time you try to save the project, not all changes are saved.

    14

    In some situations, a project's data can get damaged in the local cache. After this happens, Project may still attempt to save the bad data to the Project server and may fail in the process. Then, you receive error messages that resemble the following:
    <error id="12005" name="ActiveCacheQueuedMessageExecutionError" Violation of PRIMARY KEY constraint 'PK_MSP_PROJECT_CALENDARS'. Cannot insert duplicate key in object 'MSP_PROJECT_CALENDARS'. Violation of PRIMARY KEY constraint 'PK_MSP_PROJECT_CALENDARS'.
    Now, Project goes through a process to fix the data before saving.

    15

    In the French, Portuguese, Polish and Hungarian language versions of Project Professional, when you insert a field into a task or resource views you see an error message stating that the field does not exist.

    16

    Because of password encoding/decoding changes in Project 2007, when you add and remove passwords from the same project file by using the "Save As" function, the passwords may become damaged, and you cannot open the files. As an example, you have a password associated with a project, and you Save As to remove the password. Later, you open the file, but you are prompted for a password. No matter what you enter, you cannot open the file

    17

    On some projects, when you attempt to level them on a day-by-day basis, Project hangs.

    18

    Password protection is removed from an MPP file, and during the process, you Save As the file to a new name. When you open the file a subsequent time, you are prompted to enter a password, and you are unable to open the project.

    19

    Project Professional may crash if you set a task to use a dependency on a deliverable. This occurs if the deliverable has been deleted from the SharePoint list but the project hasn't yet been updated to reflect this change.

    20

    Project Professional may crash in the following scenario. While connected to a server, you create, save, and close a project. Later, you delete the project from your local cache, and then while working offline, you create and save a project with the same name. Later, when Project Professional goes back online, it crashes.

    21

    Some formulas don't work correctly when the system list separator is a semicolon. As an example, the following formula works correctly when the list separator is a comma but fails when it is a semicolon:
    Switch(([duration]=1 or [duration]=3)=true;"one";([duration]=2 or [duration]=4)=true;"two";[duration]>4;"more")

    22

    The ProjectBeforeSave event may not work correctly if a project is being closed as a part of the save process. The error "Run-time error '1004': An unexpected error occurred with this method." is seen.

    23

    The results of sorting and renumbering a task or resource list are not saved. For example, a task's ID equals 5, and after sorting and renumbering, the ID equals 2. After saving and reopening the project, you find that the ID equals 5 instead of 2.

    24

    When additional work is added to assignments that are on fixed duration tasks, the new work is spread incorrectly over a longer duration than expected. For instance, if you have an assignment that has 24h of actual work and then you increase the work to 32h, instead of the work being spread over an additional day, it is spread over three additional days.

    25

    When fixed costs are assigned to summary tasks, the accrual may not be correct. Instead of the cost getting spread across the task's duration, it gets spread to the earliest finish date of any of the summary task's subtasks.

    26

    When you enter a time-phased zero (0) Actual Overtime Work value at the beginning of an assignment, the assignment remaining work does not get rescheduled properly. Instead, the zero Actual Overtime Work entry is ignored and the work is not rescheduled.

    27

    When you save from Project Professional or from Project Standard to the XML file format, a resource's Maximum Units value is not saved correctly. For example, if a resource's Maximum Units value is set to 50 percent, the value changes to 100 percent when you save it to the XML file format.

    28

    You cannot set a task dependency predecessor or successor lag time by using VBA. For example, you run the following code:
    ActiveSelection.Tasks(1).TaskDependencies.Add From:=ActiveProject.Tasks(1), Type:=pjStartToStart, Lag:="2d"
    When you do this, you receive the following error message:
    Run-time error '1101';
    The argument value is not valid.

    29

    You have a resource with multiple cost rate tables defined. You are working in the Resource Usage view, where you see the timephased cost both at the assignment and resource level. Next, you change the assignment to use a different cost rate table. After this change, you see the new cost on the assignment, but it has not rolled up to the resource. Changing the view and coming back shows the correct value.

    30

    You start Project Professional, and you connect to a server profile in the offline mode. Later in Project Professional, you select the Work Offline command to go back online. But, Project Professional still says offline.

    31

    Your project has task durations that are less than one day, and you save to the XML format. When you open the XML file, these durations are changed to one day (1d).


    Key Updates for Project Server 2007;

    There are a number of changes to improve security, stability and performance. Summary is shown below;

    Enhancements/DCR;

    None.

    Summary of Issues Fixed;

    1. Queue Service – modified to prevent consumption of large amounts of memory
    2. Database indexes have changed to improve performance
    3. fixes to Cost resource issues. Proper handling off tasks that have other resource types assigned to same task
    4. Fixes to resource plan, build team and scheduling engine

    See below for full list of changes to Project Server 2007;

    1

    The cost on assignments increases unexpectedly. This occurs if all the following conditions are true: the cost resources accrual method is set to Start or to End, there is a work type resource assigned to the same task, and you update the work in the My Tasks view.

    2

    When you have a cost and work resource that is assigned to a task, and you update the work resource in the My Tasks view, the cost contour of the cost resource may be incorrectly changed.

    3

    You may be unable to see a user's RBS value on the Manage User's page if your browser's primary language preference is different from the Project Server's primary language.

    4

    Under some conditions, when you edit and then save a custom field on the Project Properties page, the process fails, and an error similar to the following is found in the Universal Logging Service (ULS) logs:
    System.ArgumentException: Value was either too large or too small for a Decimal.Couldn't store <NaN> in NUM_VALUE Column. Expected type is Decimal. ---> System.OverflowException: Value was either too large or too small for a Decimal.

    5

    In the My Tasks view, if you display work in day units and your project's calendar is set to less or more than eight hours per day, the work value you see in the My Tasks view is displayed incorrectly. For instance, your project is set where one day equals 7 hours, and in My Tasks you enter 7 hours on a given day. After recalculation, the work appears as .875d instead of as 1d.

    6

    When certain projects that have invalid baseline data are saved to Project Server, the process fails, and you see an error message with details similar to the following:
    "An unhandled exception occurred in WinProj.SaveProject."><error id="42"

    7

    You add the local StartX and FinishX custom fields to your project and publish. Then, you set dates to these fields in the My Tasks view. Later, you submit a change, and your manager accepts and then publishes the project. When you look at these fields in the My Tasks view, the dates you entered are missing.

    8

    When you provision a Project Web Access site, you are able to specify an instance of SQL Server for the Reporting database that is different from the database for the Archive, Draft, and Publish databases. If you edit the site properties, you can change the location of the Reporting database only one time. The next time you try, the option to do so is disabled.

    9

    You create a material resource with a cost value, assign it to a task with units greater than one, and then publish the task. You perform a query against the Project Server reporting database. When you compare the returned results from the TPAssignmentByDay table, you find that the value is different from the assignment cost seen in Project Professional.

    10

    You created an enterprise custom field and applied a formula to it. You selected the option to have summary tasks use the formula. Later, in the Project Details view, you look at the values on the summary task and find that the summary level does not have the correct value.

    11

    Consider the case in which you have an enterprise custom task field that you populate in Project Professional and then publish. You go to the My Tasks view, change the value for the custom field, and then submit the change to your manager. Once the manager accepts the update, you look at the task in your My Tasks view, and you notice that the value for the custom field reverted back to the previous value.

    12

    Project Center views that filter on enterprise custom fields and that use the "Does Not Equals" operator do not work correctly. Instead of seeing a list of filtered projects, you see no projects.

    13

    When there are around 5000 status updates waiting to be processed, performance degrades and the Project Server database shows a substantial increase in deadlocks.

    14

    If your timesheet title includes extended characters, when you import a timesheet into the My Tasks view, these extended characters do not appear correctly.

    15

    A formula is associated with an enterprise custom field. Later, the formula is invalidated, such as can happen when a field the formula relies on is deleted. As expected, the formula fails. However, other valid field formulas may also stop calculating. Now, the failure of one formula does not affect the calculation of other unrelated formulas.

    16

    When you work on the timesheet approval page and you approve a timesheet, a dialog box prompts you to choose the next approver. Certain extended characters in the approver's name may not appear correctly. For example, the letter "ø" appears as "�".

    17

    When you create a Resource Center view, there's an RBS filtering option that says "Filter Resources to user's RBS branch." This option does not work. Therefore, when a Resource Center view that has this option enabled is applied, instead of seeing only those resources that are in your RBS branch, you may see all resources.

    18

    Timesheets are created by team members to report time they have worked on tasks as well as nonproject administrative-type tasks. Once a timesheet is created, however, the project tasks are not updated to reflect the addition of tasks by a project manager

    19

    When you restore a project using the Administrative restore process, if a different project with the same name exists in the draft database, a conflict can arise with a resulting failure.

    20

    Loading the Build Team page in Project Web Access may take a long time depending on how many resources there are. For instance, previously it may have taken a couple of minutes to load, and now it takes a matter of seconds.

    21

    You work in the My Tasks view, and you create a new task. On the New Task page, you enter a start date, and you set work equal to zero because you are trying to create a milestone task. When you click submit, you see a message similar to the following:
    Value must equal or exceed minimum value.

    22

    If a task with a cost resource assigned to it is published, the e-mail notification associated with the published task fails.

    23

    You install a hotfix or a cumulative update that includes new client Project Web Access controls (Pjclient.cab or Pjcintl.cab). You go to PWA to a location, such as the Project Center, and you are prompted to update the controls, and so you do this. However, after the process finishes, you find that the fix that you expect to see does not seem to be working. Under certain conditions, the new controls are not installed correctly. Therefore, even though you have installed the hotfix or update correctly, you are still using the old controls.

    24

    Several Project Server database performance fixes have been made, as well as performance fixes on various Project Web Access pages. For the database, it was found, for instance, that some tables and stored procedures that needed indexes were missing them, or in other cases, the indexes were not correct. As a result, a number of queries that used to take 30-40 seconds now run in 1-2 seconds. Additionally, a page like the Add or Edit Group page now takes seconds to populate the Available Users list instead of taking several minutes.

    25

    The Project Web Access resource plan page may not show the correct date format in the From and To fields or on the timescaled grid. For instance, if your regional settings are set such that dates are in the dd/mm/yy format, the dates in the resource plan always appear in the mm/dd/yy format.

    26

    Fixed-duration tasks that are scheduled on the server may cause resource assignments to get additional work when the tasks' duration is increased. For example, you have a fixed-duration task scheduled for today and tomorrow, but the assignment only works today. When the duration is increased, the assignment incorrectly gets additional work added to it.

    27

    Consider this scenario. Your manager creates a period status report, and you submit a report. Later, your manager deletes the status report request. However, you continue to see the periodic request for the status report. If you try to open one of the requests, you see the message "You do not have sufficient permissions to view the specified page. Please contact your administrator for permissions to view this page."

    28

    Under certain conditions and especially on farms where there are lots of workspaces and sites, the Project Queue service can leak memory leading to memory starvation on the server. Once the memory is leaked, the Queue service has to be restarted in order to free up the memory.

    29

    In rare cases, the Project Details Web part can be removed from the Project Details page. Once this happens, there's no user interface within Project Web Access to add it back.

    30

    You enter your work on the My Tasks view and you have the Timesphased view enabled. You also have tasks that are tracked on a Percent of Work and Actual and Remaining Work basis. In this case, you are incorrectly able to enter timephased work for these types of tasks.

    31

    When you compare the cost resource actual cost values in Project Professional with those in the Project Server reporting database MSP_EpmAssignmentByDay table, you see various rounding differences.

    32

    In some cases, database changes that are shipped as a part of an update are not applied correctly. This can happen most often if you provision a new empty Project Web Site on a server that has had database updates applied to it.

    33

    If you have a fixed-duration task where the assignment begins after the task's start date and if you enter a new start date for the assignment in the My Tasks view that is later than the assignment's start date, you may see progress and actual duration applied when they should not be.

    34

    On a fixed-duration task, if you enter time-phased actual work in the My Tasks view where the you complete all work earlier than the task's finish date, the remaining duration may be calculated incorrectly.

    35

    If you report and submit time from your My Tasks view but then your manager rejects the update, if your manager included comments with the rejection, the notification e-mail that is sent to you does not contain your manager's comments.

    36

    When you use the Korean version of Project Server 2007, you may see an error message similar to the following when you save changes on the Edit Project Properties page:
    The following cost custom field has erroneous data: CF_Cost
    The following date custom field has erroneous data: CF_Date
    The value for the custom field is not a valid date, or it is outside the range for dates, which is January 1, 1984 through December 31, 2049.
    This may occur for any enterprise project level date or cost field.

    37

    When you search for users on the Manage Users administrative page by using extended characters such as ä, ü, and ö, no users are found.

    38

    When projects are renamed, the summary resource assignment associated with the project may not get updated properly. Therefore, you end up with duplicate records in the reporting database. For instance, for a given assignment, you may see one record associated with the old project name and one for the new project name.

    39

    When the server queue service calls business processes that cause resource calendars to be loaded, the calendars may not get unloaded. Therefore, after time, the queue service may consume large amounts of memory.

    40

    Some Fixed Duration tasks that get scheduled on the server may lose progress. As an example, a task that was 100% complete becomes 99% complete because the task's finish date gets increased by a minute.

    41

    Consider the case in which you have two fixed duration tasks that have dependencies between them and they have resources assigned. Additionally, the dependent task has progress applied to it. These tasks are published to Project Server. In Project Web Access, you add actual work to the already partially completed assignment. But, upon recalculation, you find that actual work has actually decreased.

    42

    You have a fixed duration task that has a dependency to another ask. The task has progress applied to it. On the server, the progress on the task is reduced, but the change is ignored.

    43

    When an update is installed on Project Server, the Project Server Queue and Event services are not stopped while the update occurs.

    44

    When you try to provision a new Project Web access site, the process may fail. However, when you edit the failed site and try to correct the errors, you receive an error message that resembles the following: “The Project Web Access site specified can not be created because a site by that name already exists. Enter another Project Web Access path and try again.”

    45

    The Project Web Access Timesheet "Replace Actual with Planned" feature does not work. Instead of copying the planned work into the actual work fields, nothing happens. This feature worked correctly prior to the Infrastructure Update release.

    46

    You use the Active Directory Enterprise Resource Pool Synchronization function in Project Server. You try to troubleshoot some errors that you find in the Universal Logging Service (ULS) log. But, you cannot do this because the messages aren't correct and are missing some parameters necessary to understand the problem.

    47

    When provisioning a new Project Web Access site, databases that are versioned newer than the Farm could be used. Now, this scenario is blocked. You can provision a new PWA site using existing databases if database versions are older or equal to the Farm version.

    48

    When you work on the Project Web Access Resource Plan page, if you sort the grid of resources, the resource plan gets inadvertently checked back in and prevents you from saving the changes you made.

    49

    When more than one task in a project gets marked as the project summary task, the project and its tasks are not viewable in Project Web Access.

    50

    On long running Project Server Interface (PSI) calls involving timesheets, a process lock may expire and may cause problems. Hotfix 21266 that was previously released addresses this issue. However, there has never been a Universal Logging Service (ULS) entry to alert you to such problems. Now, if similar write lock timeout problems occur, the ULS log will contain an entry with details similar to the following:
    "ProjectHasWriteLock:TimeOut Exceeded; Ignoring Write Lock"

    51

    You install Project Server 2007 into a farm on a Windows Server 2008-based computer where User Account Control (UAC) is enabled. Additionally, the SharePoint timer service and the Shared Service Provider (SSP) service accounts are different. In this case, the Project Queue service may fail to start. Therefore, no jobs are processed in the queue.

    52

    When status updates are accepted and applied on the server, the time to process them may be very long. For instance, an update that used to take 30 minutes now takes just a few minutes.

    53

    A number of functions in Project Web Access (PWA), such as the Project Center "Edit Project Properties" and "Resource Plan" functions, are disabled if the PWA site's regional locale settings are set to locations such as German (Switzerland).

    54

    When you save a resource plan that has been applied to a Proposals or Activities project, you may see a message similar to:
    General error: An invalid value was passed to Project Server (Use this error information along with other errors to find out the cause of the problem.)
    General error: Work value used is invalid. (Use this error information along with other errors to find out the cause of the problem.)
    This problem occurs if you enter a value and then you later clear the value and attempt to save the resource plan.

    55

    If Project Server contains a formula that has a graphical indicator, and this graphical indicator contains a reference to another field, or the graphical indicator contains a Date or Duration constant value like "10d" or "5/1/08," the graphical indicator does not calculate.

    56

    If the Create New Proposal or Activity global permission has been denied, you still see the Proposals and Activities link in the global quick launch pane. Additionally you can click the Proposal and Activity menu options on the New menu in the Project Center view. Clicking any of these items produces an Error page which says you don't have sufficient permissions to the specified page.

    57

    The My Tasks view shows deleted tasks with a strikethrough font adornment. When you export these tasks to Excel, they do not properly show the strikethrough.

    58

    When the duration of a fixed-duration task is changed and calculated on Project Server, the work on assignments behaves like a Fixed Work task instead of like a Fixed Duration task. For instance, a 5d fixed-duration task with 40h of work on an assignment gets changed to 10d. Instead of the work increasing the 80h, it remains at 40h.


    Contact me if you want to learn about WSS and SharePoint fixes/changes.