#Project Server 2010 October 2011 Cumulative update #PS2010 #SP2010 #MSProject

October 31, 2011 at 12:02 pm | Posted in CU | Leave a comment
Tags: , ,

The Office 2010 October 2011 Cumulative Updates are now available, please see the links below:

http://support.microsoft.com/kb/2618119

Project Server 2010 October 2011 CU:

http://support.microsoft.com/kb/2596498

Project Server 2010 Server Roll up package October 2011 CU:

http://support.microsoft.com/kb/2596506

Project 2010 October 2011 CU:

http://support.microsoft.com/kb/2596495

As always, test these updates on a test environment before deploying to production.

#ProjectServer 2007 #MOSS #Office 2007 #MSProject SP3

October 25, 2011 at 10:55 pm | Posted in Service Pack | Leave a comment
Tags: , , , ,

Service Pack 3 have now been release for Project 2007 and Project Server 2007 (along with the other Office 2007 products) – http://blogs.technet.com/b/office_sustained_engineering/archive/2011/10/25/office-2007-and-sharepoint-2007-service-pack-3-availability.aspx

Project 2007 SP3: http://support.microsoft.com/kb/2526091

Office Server 2007 SP3 (includes Project Server 2007): http://support.microsoft.com/kb/2526299

Windows SharePoint Services 3.0 SP3: http://support.microsoft.com/kb/2526305

As always, deploy to a Test / Dev system and fully test before deploying to any Production system.

#ProjectServer 2010 cube build status issue, build stages showing incorrect times #PS2010 #MSProject

October 20, 2011 at 3:54 pm | Posted in Issue | Leave a comment
Tags: , ,

I recently looked into an issue (more of an annoyance rather than an issue as it doesn’t cause any errors / problems) for the Project Server 2010 cube build status page displaying the incorrect build stages times. I don’t have a resolution but thought I would share my findings.

Firstly I will show you the issue as I replicated it on my test environment, this can be seen below:

image

As you can see in the tracking comments section the cube was built today (20/10/2011) but the dates displayed in the build stages section shows 19/10/2011.

On my environment I have two cubes, one called test that was built on the 19th and one called zzzz that was built today:

image

On the environment where I was investigating the issue (not my test environment), they only had one cube. I decided to look in the Published database and could see where the dates were coming from, the table is MSP_WEB_CUBE_STATUS. This table keeps historical data for cubes that no longer exist which is fine but for some reason the cube build status page doesn’t show the correct start and end times at each stage for the cube that you are checking. The stored procedure that appears to be used to return this data (MSP_WEB_SP_QRY_CUBESTATUS_GetAllStatus) does filter for the correct cube and returns the correct time/dates so it is unclear how this page shows the incorrect time/dates.

**Update** The stored procedure that does appear to be returning the incorrect results is MSP_WEB_SP_QRY_CUBESTATUS_GetTimeRange. The existing query looks like this:

SELECT DISTINCT
WCSTATUS_MSG_GROUP,
WCSTATUS_START_TIME = (SELECT TOP 1 WCSTATUS_START_TIME FROM MSP_WEB_CUBE_STATUS B WHERE A.WCSTATUS_MSG_GROUP = B.WCSTATUS_MSG_GROUP),
WCSTATUS_END_TIME = (SELECT TOP 1 WCSTATUS_END_TIME FROM MSP_WEB_CUBE_STATUS B WHERE A.WCSTATUS_MSG_GROUP = B.WCSTATUS_MSG_GROUP)
FROM dbo.MSP_WEB_CUBE_STATUS A
WHERE
WCSTATUS_CUBE_UID = @cubeGuid
AND WCSTATUS_MSG_LEVEL = 0
ORDER BY WCSTATUS_MSG_GROUP

but it should filter in the nested select as shown below in bold:

SELECT DISTINCT
WCSTATUS_MSG_GROUP,
WCSTATUS_START_TIME = (SELECT TOP 1 WCSTATUS_START_TIME FROM MSP_WEB_CUBE_STATUS B WHERE A.WCSTATUS_MSG_GROUP = B.WCSTATUS_MSG_GROUP and A.WCSTATUS_CUBE_UID = B.WCSTATUS_CUBE_UID),
WCSTATUS_END_TIME = (SELECT TOP 1 WCSTATUS_END_TIME FROM MSP_WEB_CUBE_STATUS B WHERE A.WCSTATUS_MSG_GROUP = B.WCSTATUS_MSG_GROUP and A.WCSTATUS_CUBE_UID = B.WCSTATUS_CUBE_UID)
FROM dbo.MSP_WEB_CUBE_STATUS A
WHERE
WCSTATUS_CUBE_UID = @cubeGuid
AND WCSTATUS_MSG_LEVEL = 0
ORDER BY WCSTATUS_MSG_GROUP

As mentioned there is currently no resolution to this as it would not be recommended to update the Stored Procedure and this probably needs to be raised to Microsoft if this is causing issues, but hopefully this will explain the “random” time and dates displayed in the build stages section on the cube build status page.

Useful #EPM content viewer #ProjectServer #PS2010 #MSProject

October 14, 2011 at 9:38 am | Posted in Administration, Information | Leave a comment
Tags: , ,

Just a short post to highlight a useful tool for viewing Project Server 2010 content:

http://technet.microsoft.com/en-us/projectserver/hh240184.aspx

image

#ProjectServer 2010 Project Out of Sync warning when editing in the web #PS2010 #MSProject

October 7, 2011 at 12:57 pm | Posted in Administration, Functionality, Information | 3 Comments
Tags: , ,

I have seen this raised a few times as an issue, but this is standard behaviour and by design. This post will show you how this warning is replicated. For those of you that haven’t seen this warning before it states:

Project Out of Sync: Resources or Calendars have been changed and will be updated on your next save. To update your project now, click Sync

image

As the message suggests, this warning is given because either one of the Resources or Calendars have been edited since the Project was last saved. If you want to see the effect of the change straightaway click Sync otherwise all will update when the project is modified and saved. To demonstrate how this warning is replicated see the steps below.

In the example above I have two resources, for the purpose of this example I will now edit the standard rate of UserA from £20 /h to £30 /h (I wont show how to do this!). Then open the project in the web, in this example it is Project1

image

Now click Edit > In Project Web App and you will see the Project Out of Sync warning:

image

As mentioned earlier you can either click Sync to update the plan with the new Resource cost or this will update when making changes to the project and saving.

Hope that saves some confusion Smile

Check out the Mobile App for #SharePoint and #ProjectServer #ipad #iphone #android #SP2010 #PS2010 #SPC11

October 5, 2011 at 2:35 pm | Posted in Information | Leave a comment
Tags: , , , , , ,

My colleague Giles Hamson has created a mobile app that provides RSS feeds from the SharePoint and Project Server communities as well as other useful information such as links to podcasts, user groups details etc.

I have recently added links to the downloads on my blog:

image

I highly recommend downloading the App to give you up to date information on the move!

Available to view: #ProjectServer webcast on Deploying Project Server on #VMware with Shared Infrastructure #VMworld #PS2010 #SP2010 #SharePoint

October 5, 2011 at 11:12 am | Posted in Information, Installation | Leave a comment
Tags: , , , , ,

The recent webcast on Deploying Project Server on VMware is now available to view for those of you that were not able to attend, please see the link below:

https://www.livemeeting.com/cc/mseventsbmo/view?id=1032493923&role=attend&pw=5843495D

#ProjectServer 2010 Resource assignment behaviour when adding another resource to an existing task with a Generic Resource #PS2010 #MSProject #EPM

October 4, 2011 at 9:27 pm | Posted in Functionality, Workarounds | Leave a comment
Tags: , ,

Recently an issue came up at a client where they would get “Unknown Resource” error pop up when adding a second resource to a task using the Resources Tab on the Task Information dialog box in Project Professional.

It is probably easier to explain the issue by showing the repro steps below.

Firstly create a new project plan in Project Professional with one task, add a generic resource to the team then assign the generic resource to the task:

image

The user that created this plan is Support Service, you can see below this user is the assignment owner:

image

Save and publish this project plan as normal. Then another user, in this case using my own account, opens the project and wants to add another resource to Task1. This user builds the team and adds the 2nd resource, in this case UserA:

image

Now the 2nd resource is on the project team this user tries to add UserA to Task1 using the Resources Tab on the Task Information dialog box:

image

Click OK then the user will see the following error and the resource is not added to the task:

Unknown Resource

image

As the error pops up after adding UserA it is not obvious why this occurs. The reason this occurs is because Support Service is not part of the project team and I’m not the Project Owner. If I opened the project plan as Support Service and added UserA I would not see this issue.

There are several ways around this for the example above, these are detailed below.

  • Add Support Service to the project team
  • When on the Resources tab, update the Assignment Owner for the Generic Resource to Project Owner then add the 2nd resource:

image

  • Add the second resource via the Resource Names column instead of using the Resources tab on the Task Information dialog box:

image

Create a free website or blog at WordPress.com. | The Pool Theme.
Entries and comments feeds.

Follow

Get every new post delivered to your Inbox.

Join 641 other followers