Archive for April, 2006

Project Server Administrator – To Do List

Saturday, April 29th, 2006
The job of a Project Server Administrator (PSA) requires commitment, endurance & motivation. Besides regular user support work, PSA has to perform a lot of tasks on a regular basis to keep the EPM running smoothly. I will not go into the details of each topic but will just give some highlights here:
a. Daily Tasks

  1. OLAP Cube status check

  2. AD Sync status check

  3. Enterprise Resource Pool status check

  4. SQL Jobs (Backup, Portfolio, other scripts)

  5. Windows Scheduler jobs (if any)

  6. Check Windows Event Viewer logs for errors & warnings

  7. Check ‘Project Issues’ Sharepoint list for new issues posted by users

b. Weekly Tasks

  1. Close past Pay Periods

  2. Portfolio Analyzer Views

  3. Check Resources for correctness of RBS & other custom fields

  4. Backups (SQL databases, Enterprise Global Template, Sharepoint Sites backup)

  5. Sharepoint Sites

  6. Sharepoint Site Usage Analysis

c. Monthly Tasks

  1. Check Project Plans for correct information of owner, close finished projects, department, classification or other custom fields

  2. Resource Permissions & group membership review (those with higher privileges)

  3. Check the ‘Last Connected’ column in Admin > Users > Show Grid for users who haven’t logged on for long

  4. IIS Backup

  5. Logs Retention (Event Viewer logs, SQL logs, Sharepoint logs, Analysis Logs, Project Server Logs)

  6. Check number of Licenses in use

The order of a PSA tasks can be categorized differently in your organization.  The above tasks list will give you an idea as to what needs to be done.

KB Articles2

Thursday, April 27th, 2006

a. You receive a "There is no information to display in this view" error message when you try to access a Project view in Microsoft Project Server 2003 or in Microsoft Project Server 2002


b. How to remove assignments from a user’s timesheet in Project Server 2003


c. How to troubleshoot issues with Online Analytical Processing (OLAP) cubes when you work with Microsoft Project Server


d. An SQL query of a resource’s timesheet returns a value that is less than the actual work hours that appear in Microsoft Project Web Access

Factor in the productive hours per day when estimating duration

Wednesday, April 26th, 2006

Just want to share this article which I read today.


Factor in the productive hours per day when estimating duration


Kb Articles for April 2006

Wednesday, April 26th, 2006

a. Resource summary information is displayed by using a time unit other than the time unit that you specify in Project Server 2003

b. Error messages when you run the Setup program for Project Server 2003: “Error 25624. Failed to execute SQL String” and “Installation ended prematurely”

c. “0x80040e14” error message is displayed in the Microsoft Office Project Server Spooler dialog box and is logged in the Application log when you publish a project to Project Server 2003

d. Error message when you try to log on to Project Server 2003 or Project Server 2002: “You have entered an incorrect user name/password combination. (5002)”

Error Message in WSS

Tuesday, April 25th, 2006

Error messages in Windows SharePoint Services: "Server Error in ‘/_vti_bin’ Application" or "The list cannot be displayed in datasheet view"


WSS SPS with SQL 2005

Tuesday, April 25th, 2006

How to install SharePoint Portal Server 2003 Service Pack 2 and Windows SharePoint Services Service Pack 2 in a deployment that uses SQL Server 2005 as the database back end

Comparison of WSS and SPS

Tuesday, April 25th, 2006

Script to Add all users to a AD group

Sunday, April 16th, 2006