Lessons LearnedLessons LearnedProject Server 2003Project Server 2003

Sean PalesSean PalesBennett AdelsonBennett Adelson

AgendaAgenda

IntroductionIntroduction Designing a Scalable ArchitectureDesigning a Scalable Architecture Common Project Server MistakesCommon Project Server Mistakes Q & AQ & A

Who Are We?Who Are We?Bennett Adelson Enterprise Project Bennett Adelson Enterprise Project ManagementManagement is a division of Bennett is a division of Bennett AdelsonAdelson What does this mean?What does this mean?

Microsoft’s go to partner for EPM in OhioMicrosoft’s go to partner for EPM in Ohio Core focus and competency is EPMCore focus and competency is EPM Proven record of successful Project Server Proven record of successful Project Server

implementationsimplementations Highest quality developers and implementation Highest quality developers and implementation

specialistspecialist

Who Am I?Who Am I?

Director of Bennett Adelson Enterprise Director of Bennett Adelson Enterprise Project ManagementProject Management

Microsoft Project user for over 5 yearsMicrosoft Project user for over 5 years Frequent contributor to Microsoft Frequent contributor to Microsoft

NewsgroupsNewsgroups Former telecom analyst for New York Former telecom analyst for New York

based investment bankbased investment bank

Designing a Scalable Designing a Scalable ArchitectureArchitecture

Top 5 Scalability KillersTop 5 Scalability Killers

1.1. Inadequate network Inadequate network infrastructureinfrastructure

2.2. Inadequate database hardwareInadequate database hardware

3.3. No PilotNo Pilot

4.4. Undefined project management Undefined project management practicespractices

5.5. Unrestricted access to dataUnrestricted access to data

Web Server OptionsWeb Server Options

Single ServerSingle Server Dual ServersDual Servers Single ClusterSingle Cluster Dual ClustersDual Clusters

Single ServerSingle Server

Simplest setupSimplest setup Scale limited to size of hardwareScale limited to size of hardware

Project Server IIS, ASP Pages

Project Data ServiceXML Web Service

Sharepoint “Front-End”IIS

Dual ServerDual Server

Separate WSS and Project ServerSeparate WSS and Project Server Allows ‘right sizing’ of each server based on Allows ‘right sizing’ of each server based on

useuse Use when significant WSS usage is expected Use when significant WSS usage is expected

outside of project serveroutside of project server

Project Server IIS, ASP Pages

Project Data ServiceXML Web Service

Sharepoint “Front-End”IIS

Project Server PDSWSS

Project Server PDSWSS

Single ClusterSingle Cluster Efficient use of less expensive hardwareEfficient use of less expensive hardware Flexibility of maintenance and adding Flexibility of maintenance and adding

capacitycapacity Use when balance of WSS to PS usage Use when balance of WSS to PS usage

unknownunknown

Project Server PDSWSS

Dual ClusterDual Cluster Max flexibility in adding capacity as Max flexibility in adding capacity as

requiredrequired Separate admin and maintenance orgsSeparate admin and maintenance orgs Max capacity strategyMax capacity strategy

Project Server PDS

Project Server PDS

Project Server PDS

WSS

WSS

WSS

Views Processing OptionsViews Processing Options

On Web ServerOn Web Server Separate ServerSeparate Server Multiple Separate ServersMultiple Separate Servers On Database ServerOn Database Server

Project Server IIS, ASP Pages

Project Data ServiceXML Web Service

Sharepoint “Front-End”IIS

Views on Web ServersViews on Web Servers

Default optionDefault option Only supported when using a single PS Only supported when using a single PS

web serverweb server

View Processing SvcNT Service

PS PDSWSS

Views on Separate ServerViews on Separate Server

Required for clustered PS web serversRequired for clustered PS web servers Increased publishing capacityIncreased publishing capacity Single processor speed is criticalSingle processor speed is critical

View Processing SvcNT Service

PS PDSWSS

Views on Multiple ServerViews on Multiple Server

New capability in SP1New capability in SP1 Not ‘clustered’, additional separate Not ‘clustered’, additional separate

serversservers Single processor speed is criticalSingle processor speed is critical

View Svc

View Svc

Views on Database ServerViews on Database Server

Eliminates network overhead during publishEliminates network overhead during publish Increased publishing speedIncreased publishing speed Single processor speed is criticalSingle processor speed is critical

View Processing SvcNT Service

PS Views DB

Database Partition OptionsDatabase Partition Options

Single DatabaseSingle Database Two DatabasesTwo Databases Three DatabasesThree Databases

Single DatabaseSingle Database

All three logical table sets on one All three logical table sets on one machinemachine

Default install optionDefault install option

WSS DB

PS Core DB

PS Views DB

PS Projects DB

Two DatabasesTwo Databases

Separate server for views dataSeparate server for views data Supported through PS InstallerSupported through PS Installer

WSS DB

PS Core DB

PS Views DB

PS Projects DB

Three DatabasesThree Databases Separate server for views dataSeparate server for views data Separate server for project dataSeparate server for project data Requires use of command line toolsRequires use of command line tools

WSS DB

PS Core DB

PS Views DB

PS Projects DB

Multi-Site ConfigurationsMulti-Site Configurations

Multiple Project Server web sites on Multiple Project Server web sites on single hardware platformsingle hardware platform

Separate database (not server) per Separate database (not server) per Project Server siteProject Server site

Additional flexibility for views Additional flexibility for views processing and database layoutprocessing and database layout

Multi-Site Front EndMulti-Site Front End Single or Dual web server clusters for Single or Dual web server clusters for

all sitesall sites Number servers based on total number Number servers based on total number

of concurrent users supportedof concurrent users supported

Project Server PDSWSS

Project Server PDSWSS

Project Server PDSWSS

Views Processing OptionsViews Processing Options

Multiple sites per views serverMultiple sites per views server Multiple views servers per siteMultiple views servers per site

Site 2

Site 3

Site 1

View Svc

View Svc

Database OptionsDatabase Options Multiple servers, partition by siteMultiple servers, partition by site Multiple servers, partition by usageMultiple servers, partition by usage Multiple servers, partition by functionMultiple servers, partition by function

Site 3

Site 1

Site 4

Site 2

Site 1Core

Site 1ViewsSite 2

Core

Site 2Views

10 Common Project 10 Common Project Server MistakesServer Mistakes

Mistake #10Mistake #10

Problem: PWA Users receive a “size Problem: PWA Users receive a “size limit error” when submitting Status limit error” when submitting Status reportsreports

Mistake: There are limits on the volume Mistake: There are limits on the volume of text users can submit through status of text users can submit through status reports’ ActiveX controlreports’ ActiveX control

Resolution: Resolution: Submit smaller quantity of textSubmit smaller quantity of text Use WSS, InfoPath or “other”Use WSS, InfoPath or “other”

Mistake #9Mistake #9

Problem: Portfolio Analyzer reports are Problem: Portfolio Analyzer reports are not interactivenot interactive

Mistake: A licensed Office 2003 product Mistake: A licensed Office 2003 product has not been installedhas not been installed

Resolution:Resolution: Install an Office 2003 product (isnt this Install an Office 2003 product (isnt this

PWA?)PWA?) Unregister and Reregister the PWA DLLUnregister and Reregister the PWA DLL

Mistake #8Mistake #8

Problem: After installing WSS, the Problem: After installing WSS, the Project Server site or pages with grid Project Server site or pages with grid controls won’t loadcontrols won’t load

Mistake: WSS installed after Project Mistake: WSS installed after Project ServerServer

Resolution: Resolution: Install WSS firstInstall WSS first Modify the Exclude listModify the Exclude list

Mistake #7Mistake #7

Problem: You’ve upgraded from STS ’02 Problem: You’ve upgraded from STS ’02 to WSS ’03 and issues have not to WSS ’03 and issues have not migratedmigrated

Mistake: Failed to run STSWiz.exe after Mistake: Failed to run STSWiz.exe after running OWS1002.exerunning OWS1002.exe

Solution:Solution: Run STSWiz.exe before running Run STSWiz.exe before running

PSMIGRAT.exePSMIGRAT.exe

Mistake #6Mistake #6

Problem: Project Professional users Problem: Project Professional users receive Spooler Error 0x80040E14 when receive Spooler Error 0x80040E14 when publishingpublishing

Mistake: PWA users self-assign Mistake: PWA users self-assign themselves to tasks and Project themselves to tasks and Project Managers assign that user to the same Managers assign that user to the same tasktask

Resolution:Resolution: Change your company’s processesChange your company’s processes Hotfix (not included in SP1)Hotfix (not included in SP1)

Mistake #5Mistake #5

Problem: Users receive login error Problem: Users receive login error when trying to download new when trying to download new assignmentsassignments

Mistake: IE Security allows for ONLY Mistake: IE Security allows for ONLY “Automatic logon only in the intranet “Automatic logon only in the intranet zone”zone”

Resolution:Resolution: Set IE Security to “Automatic logon with Set IE Security to “Automatic logon with

current user name and password”current user name and password”

Mistake #4Mistake #4

Problem: Timesheet doesn’t reflect Problem: Timesheet doesn’t reflect changes to Tracking settingschanges to Tracking settings

Mistake: Project Professional users Mistake: Project Professional users have failed to Re-Publish assignmentshave failed to Re-Publish assignments

Resolution:Resolution: Republish All Project PlansRepublish All Project Plans

Mistake #3Mistake #3

Problem: OLAP Cube fails to build! Problem: OLAP Cube fails to build! Mistake: This could be a number of Mistake: This could be a number of

things, but one of the main reasons is things, but one of the main reasons is the existence of special characters in the existence of special characters in the ERP and/or EROCsthe ERP and/or EROCs

Resolution: Resolution: Refrain from using special characters in Refrain from using special characters in

the ERP and/or EROCsthe ERP and/or EROCs

Mistake #2Mistake #2

Problem: Project Server fails after Problem: Project Server fails after installing a hotfix or service pack! installing a hotfix or service pack!

Mistake: Not reading the instructionsMistake: Not reading the instructions Resolution:Resolution:

Install in Test EnvironmentInstall in Test Environment Make backupsMake backups Read ALL of the instructionsRead ALL of the instructions

Mistake #1Mistake #1

Problem: Performance Issues!Problem: Performance Issues! Mistake: Poor PlanningMistake: Poor Planning Resolution:Resolution:

Talk to Experts! Talk to Experts! Plan, Plan, Plan… PlanPlan, Plan, Plan… Plan Proof of ConceptProof of Concept Explore Configuration Planning GuideExplore Configuration Planning Guide Test PilotTest Pilot Small RolloutsSmall Rollouts

How to contact usHow to contact us

Bennett AdelsonBennett Adelson www.BennettAdelson.comwww.BennettAdelson.com

Sean PalesSean Pales 1-877-328-7122 ext. 1031-877-328-7122 ext. 103 1-440-684-5000 ext. 1031-440-684-5000 ext. 103 Spales@bennettadelson.comSpales@bennettadelson.com

Thank you for attendingThank you for attending

Q & AQ & A

??