Project Server 2007

Task Type Explained .... I hope

2010-04-14T09:57:00.001-07:00

Fixed Work (Effort Driven)

If work is changed then duration will change

If another resource is added to task then both duration and work will reduce

If duration is changed then units will change and work (effort) remains the same (fixed work)

If units are changed then duration will change and work (effort) remains the same (fixed work)

Fixed Unit (Effort Driven):

If duration of fixed units task is changed then work will change

If work of fixed units task is changed then duration will change

If another resource is added to fixed unit task then both duration and work will change

If units for both resources are changed then work will remain same but duration will change

Fixed Duration Effort Driven

If work is changed for fixed duration task units will change and duration will remain the same

If units are changed for fixed duration task then work will change and duration will remain the same

If duration is changed for fixed duration task then work will change and units will remain the same

If another resource is added to fixed duration (effort driven) task then both work and units will change

2010-02-17T17:45:00.001-08:00

Problem: (project server 2007 with IIS 7.0 Windows 2008

In Microsoft Office Project Server 2007, you may experience one or more of the following symptoms when you try to access a Web page from Microsoft Office Project Web Access:

When you try to view the "Project Center" page, you receive an error message that resembles the following:
Project Center cannot access the project(s) you are trying to view. It is most likely that you either don't have the permissions to view the project, another user has deleted this project(s) before you were able to view it or that another user is in the process of publishing the project
When you try to view the "Resource Center" page, you receive an error message that resembles the following:
There was an error loading the page. Please try again by clicking Refresh. If this problem persists, contact your administrator.
When you select a user on the "Manage Users" page, you receive an error message that resembles the following:
An error was encountered in loading the page. Refresh the page, or contact your server administrator if this problem persisttions.
When you try to view an "Edit Custom Field" page, you receive an error message that resembles the following:

The custom field could not be saved due to the following reason(s):

An unknown error has occurred

Solution:

In: IIS 7.0 Compression Turn off compression for Port 80 and Office Server Web Services and SSP

Project Server SP2 Deployment Resources

2009-04-29T07:27:00.000-07:00

Service Pack 2 (SP2) Deployment Resources
Deploy Service Pack 2 for Office Project Server 2007
http://technet.microsoft.com/en-us/library/dd637740.aspx
Deploy Project Server 2007 updates
http://technet.microsoft.com/en-us/library/dd630752.aspx
Deploy software updates for Windows SharePoint Services 3.0
http://technet.microsoft.com/en-us/library/cc288269.aspx
Deploy software updates for Office SharePoint Server 2007
http://technet.microsoft.com/en-us/library/cc263467.aspx
Create an installation source that includes software updates (Windows SharePoint Services 3.0)
http://technet.microsoft.com/en-us/library/cc287882.aspx
Create an installation source that includes software updates (Office SharePoint Server 2007)
http://technet.microsoft.com/en-us/library/cc261890.aspx

Project Server Service Pack 2 (SP2) Download Center Page

2009-04-29T07:24:00.000-07:00

Project Server Service Pack 2 (SP2) Description

2009-04-29T07:23:00.001-07:00

Service Pack 2 (SP2) Description
Description of Office Project 2007 Service Pack 2 and Office Project Language Pack 2007 Service Pack 2
953326
http://support.microsoft.com/kb/953326
Description of Windows SharePoint Services 3.0 Service Pack 2 and of Windows SharePoint Services 3.0 Language Pack Service Pack 2
953338
http://support.microsoft.com/kb/953338
Description of the 2007 Microsoft Office servers Service Pack 2 and the 2007 Microsoft Office servers Language Pack Service Pack 2
953334
http://support.microsoft.com/kb/953334

Search Project Server Blogs

2009-01-12T18:48:00.001-08:00

http://search.live.com/macros/projectserver/epm

Steps to Move Project Server 2007 from One Environment to Another Including WorkSpace

2008-10-21T07:36:00.001-07:00

Assumptions:

You have installed Project Server on New Machine to a point where you have Sharepoint Central Administration, Web Application on Port 80, Web Application for SSP and Project Application Service is started.
Make Sure you same project server service pack and patches installed on new server
You have backed and restored project server database to new server
You have backed and restore Content Database for Port 80 (Assuming your project server work space was on port 80)

Steps:

Navigate to Start » All Programs » Administrative Tools » SharePoint 3.0 Central Administration
Click on Operations > Under Topology and Services > Click on Services on Server > Select the Option Project Application
Make Sure Project Application Service is started
Under Shared Service Administration Click on SharedServices1 (Name could be different)
Click on Project Web Access Sites
Click on Create Project Web Access
Make Sure you select the same "Project Web Access Path" if you want to RESTORE AND RELINK SharePoint workspace. My Scenario was PWA.
Enter the account info for Administrator Account and Primary Database Server
Enter the name of Published Database, Draft Database, Archive database and Reporting Database (restored databases)
Click on refresh status after few minutes
The Site should be provisioned
Click on the site just to make sure project web access is working
Click on Workspace "The PAGE not found" (EXPECTED)
Now Create a new web application
Navigate back to central administration > application management > Under SharePoint Web Application Management Click on Create or Extend Web Application
Create New Web-Application on Port 81 *Can be any port except 80
Once the Web application is created on port 81 > Navigate back to central administration > application management > Under SharePoint Web Application Management Click on Content databases
Change the Web-Application to http://servername:81/
Remove the content database of port 81 (Make Sure you are removing the content database of correct web application)
Click on Database name and then click on Remove Content Database > Click Ok
Add Content Database of Port 80 from Previous Server (I did restored the database as "OLD") to this web application on Port 81
Download Project Server Resource kit for project server 2007 from Microsoft.com
Extract it to C:\ResourceKit
Start > Run > Cmd
Browse to C:\ResourceKit
Type

ReLinkAllWSSSites.exe http://servername:81 http://servername/pwa

27. Type Browse to PWA (http://serverName/PWA) you should see all Projects and their SharePoint sites.

OLAP Database Created Outside of Project Server

2008-07-29T07:02:00.000-07:00

Failed to build the OLAP Cubes. Error: Analysis Services Session Failed with the following Error: Cannot Overwrite an OLAP Database Created Outside of Project Server or by Another Project Server Site

Issue: Analysis Database for OLAP got corrupted
Resolution:
1) Login to Analysis Services Machine as Administrator
2) Start All Programs Microsoft SQL Server 2005 SQL Server Management Studio
3) On Server Type Select Analysis Services Enter Correct Server Name Click Connect
4) Expand Analysis Server Databases "DBName" (Cube Name)
5) Right Click and Delete
6) Re-build the OLAP cube via Project Web Access

Announcing the Infrastructure Update for Office Servers

2008-07-16T05:47:00.000-07:00

Download Links:

WSS 3.0 Update
http://www.microsoft.com/downloads/details.aspx?FamilyId=256CE3C3-6A42-4953-8E1B-E0BF27FD465B&displaylang=en
MOSS Update
http://www.microsoft.com/downloads/details.aspx?familyid=3811C371-0E83-47C8-976B-0B7F26A3B3C4&displaylang=en

On July 15th, 2008 Microsoft announced the availability of the Infrastructure Update for Office Servers. The Infrastructure Update for Office Servers is a set of updates to improve platform performance and contain several customer driven fixes. The updates are applicable to Microsoft Office SharePoint Server 2007, Windows SharePoint Services 3.0, Microsoft Search Server 2008 & Microsoft Search Server 2008 Express, Microsoft Office Project Server 2007 and Microsoft Office Project 2007.

Info from link below:

http://blogs.msdn.com/project/archive/2008/07/15/announcing-the-infrastructure-update-for-office-servers.aspx

Infrastructure Update for Windows SharePoint Services 3.0 (KB951695)
http://support.microsoft.com/kb/951695
Infrastructure Update for Microsoft Office Servers (KB951297)
http://support.microsoft.com/kb/951297
Infrastructure Update for Microsoft Office Project 2007 (KB951547)
http://support.microsoft.com/kb/951547
Infrastructure Update for Microsoft Office Project 2007 (KB953751)
http://support.microsoft.com/kb/953751
Infrastructure Update for Windows SharePoint Services 3.0 (KB953749)
http://support.microsoft.com/kb/953749

Cannot use 'partitionResolver' unless the mode is 'StateServer' or 'SQLServer'

2007-12-04T06:44:00.000-08:00

Issues: When you install Report Services 2005 on server that is running sharepoint (WSS 3.0) or MOSS. You will receive this error message when you try to access

http://SERVERNAME/reports

Server Error in '/Reports' Application.

Configuration Error

Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: Cannot use 'partitionResolver' unless the mode is 'StateServer' or 'SQLServer'.

Source Error:

Line 133:    webParts
Line 134:    machineKey validationKey="7A64E08BE8080CFA1C6B0855A414997E85C880F666CCA555" decryptionKey="25444543D5621B3EF55E53EB54E0A71A9FA23E97C5965C48" validation="SHA1"
Line 135:    sessionState mode="SQLServer" timeout="60" allowCustomSqlDatabase="true" partitionResolverType="Microsoft.Office.Server.Administration.SqlSessionStateResolver, Microsoft.Office.Server, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c"

Source File: C:\Inetpub\wwwroot\wss\VirtualDirectories\80\web.config Line: 135

Version Information: Microsoft .NET Framework Version:2.0.50727.832; ASP.NET Version:2.0.50727.832
____________________________________________________________________________________
RESOLUTION:
Here are the steps I followed to resolve this issue:

Locate the Web.config file for reporting services
Usually located in "DRIVE:\Program Files\Microsoft SQL Server\MSSQL.5\Reporting Services\ReportManager"
Save a copy of web.config file (as web_old.config)
Open the web.config file and search for "sessionState mode"
Add partitionResolverType="" as shown below
Save the web.config file
Try to access report manager http://servername/reports

Migrate Project Server 2007 from One Machine to Another Machine

2007-10-29T07:26:00.000-07:00

Purpose of the document:
Purpose of this document is to write a process to migrate MSPS2007 from one server to another (In same domain or different domain).

Terms Used:
In this document Origination Server, is referenced to server in which MSPS2007 is installed and configured as per requirements.

In this document Destination Server, is referenced to server in which MSPS2007 is installed but not configured.

Requirements
Origination Server
1. Domain account that has administrative access to WSS (Windows SharePoint Services) or MOSS (Microsoft Office SharePoint Services)
2. Shared space available to backup databases
3. Domain account has system admin access to database server

Destination Server
1. Domain account that has administrative access to WSS (Windows SharePoint Services) or MOSS (Microsoft Office SharePoint Services)
2. Space available to restore databases in destination server
3. Domain account should have system admin access to database server

Assumptions
Origination Server
1. MSPS2007 is installed
2. Provision a brand new Project Web Access site.
3. Add the migration administrator account
4. Create a backup of the Project Web Access databases.
5. Create a resource, create a project from Project Professional 2007, and make sure the newly provisioned Project Web Access site works correctly

Destination Server
1. MSPS2007 is installed and basic functionality is tested

Backup Databases Using SharePoint Central Administration

Origination Server:
1. Login to Origination server as administrator
2. Navigate to Start » All Programs » Administrative Tools » SharePoint 3.0 Central Administration

3. The Central Administration. The URL will looks like: http://OrginationServerName:port/default.aspx.

4. Click Operations tab on the top navigation bar.

5. In the Backup and Restore section of the Operations page, click perform a Backup.

6. On the Perform a Backup - Step 1 of 2: Select Component to Backup page, select the components to backup (In this case select all four project server databases). Example: PWA_Published, PWA_Archive, PWA_Reporting, PWA_Working. As shown in figure below

7. Click on Continue to Backup options
8. On the Start Backup - Step 2 of 2: Select Backup Options page
a. Under Type of Backup make sure type of backup Full option is selected
b. Under Backup File location enter the information to where the backup files should be stored
c. Also, make sure you have enough space left on the location where backup files will be placed.
d. Click on Ok

9. Files will be backup successfully

Restore Databases Using SharePoint Central Administration

Destination Server
1. Login to Destination server as administrator
2. Navigate to Start » All Programs » Administrative Tools » SharePoint 3.0 Central Administration

3. The Central Administration. The URL will looks like: http://OrginationServerName:port/default.aspx.

4. Click Operations tab on the top navigation bar.
5. In the Backup and Restore section of the Operations page, click Restore from backup
6. On the Restore from Backup: Step 1: Select Backup File page, under Backup File Location, enter the UNC path to the backup folder, and then click OK.
7. On the Restore from Backup: Step 2: Select Backup Package to Restore page, choose the target backup package, and then click Continue Restore Process.
8. On the Restore from Backup: Step 3: Select Component to Restore page, choose the restore level, and then click Continue Restore Process.

9. On the Restore from Backup: Step 4: Select Restore Options page, select New Configuration, and then click OK in the dialog box that appears.

10. To view the restore job status on the restore status page, click Refresh.
Note: Backup and recovery may take few minutes to change the status from “Waiting for Resources”.

11. When the recovery has finished, restart Internet Information Services (IIS) to make sure that the settings are propagated to the IIS metabase.

Re-link Project Web Access
1. Navigate back to SharePoint Central administration

2. Click on SSP located on left hand lower side of pane

3. Click on Project Web Access Sites to continue

4. On Manage Project Web Access Sites page, Click on Create Project Web Access Site
Note: If you want to use the existing link then delete the old link for project web access site and then click on Create Project Web Access Site.

5. On Create Project Web Access Site page
a. Under Project Web Access Site Location
I. Select the web application to host project web access (Example Sharepoint-80)
II. Type Project Web Access Path (Example PWA1)
b. Under Administrative Account, Type the new domain account you want to be administrator to Project Web Access
c. Under Primary Database, Type the information for new database server, published database (Restored from another domain), Draft database (Restored from another domain) , Archive database (Restored from another domain)
d. Under Reporting Database, Type the information for Reporting Database (Restored from another domain)

6. Click Ok

7. To view the job status on the Manager Project Web Access Sites page, click Refresh Status.

Note: Backup and recovery so it may take few minutes to change the status from “Waiting for Resources”.

8. After few minutes or hours depending on size of database the status will change to “Provisioned”

9. Reset IIS

10. Open browser and type the Project Web Access URL and verify the data from another environment

How to Manually Install 2007 ActiveX Controls

2007-09-11T06:18:00.000-07:00