lessons learned project server 2003 sean pales bennett adelson
DESCRIPTION
Lessons Learned Project Server 2003 Sean Pales Bennett Adelson. Agenda. Introduction Designing a Scalable Architecture Common Project Server Mistakes Q & A. Who Are We?. Bennett Adelson Enterprise Project Management is a division of Bennett Adelson What does this mean? - PowerPoint PPT PresentationTRANSCRIPT
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 [email protected]@bennettadelson.com
Thank you for attendingThank you for attending
Q & AQ & A
??