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... Continue Reading →
#ProjectServer data snapshot for reporting #PS2010 #MSProject #SP2010 #Excel #SSRS #SQL
Quite often there is a requirement for some form of data snapshot in Project Server for trend analysis reporting. This post will give a simple explanation of how this can be achieved using the Project Server Reporting database and a SQL job. This example just captures some key project metrics such as Actual Work, Actual... Continue Reading →
#ProjectServer 2013 / 2010 / 2007 high-level Audit Export via #PowerShell #MSProject #PS2010 #EPM
Quite often there is a request for audit information from Project Server but unfortunately there is nothing available out of the box. This post covers a very high-level solution to this using the Project Server PSI and PowerShell. Most actions in Project Server are processed via the Project Server queue, one simple way to get... Continue Reading →
#ProjectServer 2010 #MSProject Enterprise Global custom fields out of synch #PS2010 #PS2007
I recently came across an issue where the enterprise custom fields in the Enterprise Global didn’t match what was displayed in PWA > Server Settings > Enterprise Custom Fields and Lookup tables. I am not sure how or why this has happened, all I know it is seemed to be a combination of an upgrade... Continue Reading →
Check for missing config after #ProjectServer 2007/2010 PWA instance merge #PS2010 #PS2007 #MSProject
I recently worked on a Project to migrate two Project Server 2003 instances into one Project Server 2010 instance. We achieved this by migrating both Project Server 2003 instances to two separate Project Server 2007 instances then merged the smaller of the two instances into the other instance in 2007. Luckily we only needed to... Continue Reading →
Project Server 2003 migration to #ProjectServer 2007 error #PS2007 #PS2010 #MSProject
I recently worked on a project to migrate from Project Server 2003 to Project Server 2010. While running the P12 migration tool the error below was thrown in the command prompt window: PWA Migration: Setup views to Project Server 2003 – Failed The Log file details for the error were as follows: Err1 = 37000... Continue Reading →
#ProjectServer 2010 Quick Launch configuration page issue after upgrade from #PS2007 #PS2010 #MSProject #SP2010
I recently investigated an issue where the Quick Launch configuration page in PWA > Server Settings didn’t display the links / sections correctly in Project Server 2010. The sections would not expand so therefore you could not change any settings for these links. The issue appears to exist only when upgrading from Project Server 2007... Continue Reading →
Investigating #ProjectServer and #SharePoint errors #PS2007 #SP2007 #MOSS #PS2010 #SP2010
This is quick a quick post to summarise the main key areas that can be used when investigating any Project Server issues, I have included SharePoint as most would also apply to SharePoint. Firstly I will just list the key tools / logs that can be used then go on talk about each one in... Continue Reading →
#ProjectServer 2007 #MOSS #Office 2007 #MSProject SP3
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... Continue Reading →
Accessing custom fields that allow multiple values from look up tables in #ProjectServer via T-SQL #MSProject #PS2010 #PS2007
At recent query came up on the Project Server forum regarding accessing custom fields that allow multiple values in the PWA_Reporting database. This is quick post to show how this can be achieved. In this example I have a single value lookup custom field called ProjectStatus and a custom field that allows multiple values called... Continue Reading →
You must be logged in to post a comment.