#ProjectServer #PS2013 #Excel Pivot Table limitation

Just a quick post to highlight a limitation / issue with Excel Pivot Tables that I hadn’t seen before, details below. This particular Pivot Table uses a Data Model that contains two OData feeds from Project Server 2013, one for Project details and one for Task details. The connections can been seen below: The relationship...

#ProjectServer #PS2010 / #PS2013 local master projects and tasks with no assignments

Something to be aware of when using local master projects in Project Server 2010 or 2013 when tasks in the sub projects have no assignments. You will see random text / characters next to the Unassigned name as seen below: The text / characters displayed will change depending on where you last clicked. Repro steps...

#ProjectServer 2010 field calculation in PWA #PS2010 #MSProject #SP2010

A quick blog post to highlight an issue and workaround for editing plans in PWA when using custom fields that use the inbuilt fields. This post uses Finish Variance as an example. The Finish Variance field doesn't recalculate in PWA after making edits to plans, this only updates after changes in Project Pro. This post...

#ProjectServer 2013 environment migration / rollover steps update #PowerShell #PS2013 #SP2013

Something to consider when following the rollover steps outlined in the post below. https://pwmather.wordpress.com/2013/05/02/projectserver-2013-environment-migration-rollover-steps-powershell-ps2013-msproject-sp2013/ If the target farm (Test / Dev) is a later patch level than the Content database and Project Web App database, they will need to be upgraded after mounting. Upgrade the content database using the Upgrade-SPContentDatabase command and the Project Web...

#ProjectServer 2010 Bulk update project site issue #PS2010 #MSProject #SP2010 #SharePoint

I had a recent query from a colleague regarding the bulk update project site functionality in Project Server 2010. In this scenario my colleague had taken pre-configured databases from an environment at our offices and restored these 5 databases to the clients production environment. They then created some test projects / updated configuration etc. A...

#ProjectServer 2010 Resource assignments display issue #PS2010 #SP2010 #PS2013 #SP2013

Recently I was reminded of a minor issue that I thought I would share with you. While working with a client for a recent migration from Project Server 2007 to Project Server 2010, a query was raised regarding material resources and the resource assignment view in PWA. Material resources show a work and remaining work...

#SharePoint 2010 Missing Server side dependencies Central Admin Help site orphaned #SP2010 #PS2010 #PowerShell

Whilst working on a client site today to deploy the June 2012 CU to their SharePoint / Project Server 2010 farm I came across an issue in the pre-update health check. The issue was identified by the SharePoint health analyser as Missing server side dependencies. This particular missing dependency was an orphaned site in the...

#ProjectServer Active Issues and Risks on PWA Reminders Web Part #PS2010 #SP2010 #SharePoint

The Project Server reminders web part contains key information relating to all projects that the logged on user is involved in. This includes new task assignments, timesheet information, pending approvals and active issues and risks assigned to the logged on user. This post focuses on the issues and risks count as I have seen a...

#ProjectServer and #SharePoint 2010 April 2012 Cumulative Update #PS2010 #SP2010 recalled

************************************************ Update: 14/06/2012 - The April 2012 CU Server Packages are now available again - http://blogs.msdn.com/b/alimaz/archive/2012/06/14/sharepoint-server-2010-june-2012-cumulative-update-package-is-available-now.aspx ************************************************ The Project Server 2010 Server Package and SharePoint 2010 Server Package for April 2012 CU has been recalled and removed from the download servers: http://support.microsoft.com/kb/2598152 (Project Server 2010 Server Package) http://support.microsoft.com/kb/2598151 (SharePoint Server 2010 Server Package) Notice This hotfix package is...

#ProjectServer 2010 new Portfolio Analysis error #PS2010 #SP2010 #MSProject

I recently came across an issue on a client site and on the Project Server forums with creating a new Portfolio Analysis, clicking the new button threw the error below: In the ULS logs the following lines were key to resolving the issue: Exception occurred in method Microsoft.Office.Project.Server.BusinessLayer.LookupTable.ReadLookupTablesMultiLang System.Data.ConstraintException: Failed to enable constraints. One or...