MS Project 2007 :: installing SP1 result in Stopping Microsoft Office Project Server Events Service

Yes, this true because it happened with me, after installing WSS 3.0 SP1 I started installing Ms Project Server 2007 SP1, exactly in step 5 it stop and throw an exception tilling that the Microsoft Office Project Server Events Service was not able to get started !!??

After searching completely the "Whole Internet" I found one post talking about this issue

and what I came to know that this service trying to access the Internet address

http://crl.microsoft.com/pki/crl/products/CodeSignPCA.crl

but the network setup did not allow this (this is true and expected for the ideal and secure network). I was sure that this is my issue that stopped me from completing my work in the last 2 days.

So, the only solution suggested by my colleagues in Networks and Systems department is to allow Internet Access in complete during the installation of SP1 then remove it

It work, yes, but for me I consider this a stupid bug regardless of the person who wrote the code unless it is a policy to catch the people who are using the unlicensed copies

Best Regards

Bilal Okour

MS Project Server 2007 :: How to install it in a single mode

Hi folks

I found this article good for the people who are going to deploy Project Server 2007 in a stand alone computer

http://technet2.microsoft.com/Office/en-us/library/c9531164-2705-4233-84d1-78bd728dd7611033.mspx

Best Regards

Bilal Okour

MS Project 2007 :: Corrupted Tasks

How do you know if your Project has a corrupted tasks, simply the following indicators will till you if so

1. One ore more of your resource report that his "My Taks" is showing sharepoint error message
   
2. If you know how to query your database (Published DB of your server) and get unfortunately one row at lease
   

   SELECT MSP_PROJECTS.PROJ_NAME, MSP_ASSIGNMENTS_SAVED.TASK_NAME,
   MSP_RESOURCES.RES_NAME, MSP_ASSIGNMENTS_SAVED.ASSN_UID,
   MSP_ASSIGNMENTS_SAVED.PROJ_UID,
   MSP_ASSIGNMENTS_SAVED.TASK_UID, MSP_ASSIGNMENTS_SAVED.RES_UID
   FROM MSP_ASSIGNMENTS_SAVED INNER JOIN
   MSP_PROJECTS ON MSP_ASSIGNMENTS_SAVED.PROJ_UID =
   MSP_PROJECTS.PROJ_UID INNER JOIN
   MSP_RESOURCES ON MSP_ASSIGNMENTS_SAVED.RES_UID =
   MSP_RESOURCES.RES_UID
   WHERE (NOT EXISTS
   (SELECT TASK_UID
   FROM MSP_TASKS_SAVED
   WHERE (TASK_UID =
   MSP_ASSIGNMENTS_SAVED.TASK_UID)))

    

   Then to resolve this issue do the following

• Open Gantt View, Insert "Publish" column, and select No for the task that you got from the above query
• Publish your project
• Again Gantt View, For the  "Publish" column, and select "Yes" for the task that you got from the above query
• Publish you project

Best Regards

Bilal Okour

MS Project :: You need to know these terms

Here are some useful interpretation

Duration = Actual Duration + Remaining Duration
Percent (%) Complete = Actual Duration / Duration
Work = Actual Work + Remaining Work
Percent (%) of Work Complete = Actual Work / Work
Start: At the beginning it is the baselined start, later one it will be replaced by the actual start
Finish: At the beginning it is the baselined finish, later one it will be replaced by the actual finish

Note: Remember to baseline your plan to save the original values

Best Regards

Bilal Okour

MS Project :: You need to know these terms

Here are some useful interpretation

Duration = Actual Duration + Remaining Duration
Percent (%) Complete = Actual Duration / Duration
Work = Actual Work + Remaining Work
Percent (%) of Work Complete = Actual Work / Work

Best Regards

Bilal Okour

I will be speaking in 2 big events in Kuwait

Dear All,

for all who are interesting in understanding Microsoft EPM solution then they can attend my sessions at the following two major events

1. Community Open Day, executed by DotNetBoom and ProRangers communities and sponsored by Microsoft. Here I will conduct 2 sessions which will cover how Microsoft EPM can be best implemented to Manage the IT projects during all phases in the IT Development Life Cycle.
2. MVPs Open Day, the first event in Kuwait where different MVPs from Middle East, Africa and Europe will be gathering together to unleash the latest technology experience they have. I am sure that you will never feel that you lost one minute of your time. Waiting to see you there

More details will come soon and I will make sure to keep you updated

 

Best Regards

Bilal Okour

MS Project 2007: Examples about Tasks Types

A lot of project mangers using EPM solution are keeping asking me about giving examples to illustrate the different types of MS Project 2007 Tasks Types

Here I am trying to give some examples

Fixed Duration

• The football match will take 90 minutes to finish
• Flying from Kuwait to Amman will take 1:30 hour to complete regardless of the number of the passengers inside and regardless of the number of aircrafts flying at the same time
• The woman will take 9 months to deliver, you cannot divide this work for two resources (she and her girl friend)

Fixed Work

• You are required to enter 2000 records into an application, each record will take 5 minutes and you will pay (or get paid) per record.
• You are required to floor 100 square meters of one building, each square meter will take 30 minutes.
• You want to install Windows XP on 100 boxes, each box will take 1 hour and you need to pay (or get paid) per each installation.

Fixed Unit

• You want 1 developer to work 8 hours (100% or full day only) to develop a program
• You need 5 developers and each to work 20% of their capacities to complete the program
• You need 5 developers to work 8 hours a day (100% each) to complete the program
• You need 1 developer to work 4 hours a day (50% or half timer) to complete the program

Best Regards

Bilal Okour

A MS Project 2007 Crazy Error: My Tasks is now not working???

I have completed one installation and implementation for PS2k7 at one organization, it worked fine for around 2 months, suddenly the My task did not work for some users but it is working for the others

I knew that there is a corrupted assignment and the only solution for me was to roll out the project from the last copy just before the issue starts

I found this post in the Internet that approach this issue in a very logical way, the suggested solution can figure out the corrupted task and gives a walk around solution for this,  and it was posted by: Rod Gill, Microsoft MVP for Project

for more details about Rod please check the button of this post

Now I will let you with the  post

"

if you add a new resource that already has % complete>0 then
there is still a bug (after SP1) that causes a corrupt assignment. The
symptoms are that the resource cannot access My Tasks.
The following SQL will highlight which assignment is corrupted:

 
SELECT MSP_PROJECTS.PROJ_NAME, MSP_ASSIGNMENTS_SAVED.TASK_NAME,
MSP_RESOURCES.RES_NAME, MSP_ASSIGNMENTS_SAVED.ASSN_UID,
MSP_ASSIGNMENTS_SAVED.PROJ_UID,
MSP_ASSIGNMENTS_SAVED.TASK_UID, MSP_ASSIGNMENTS_SAVED.RES_UID
FROM MSP_ASSIGNMENTS_SAVED INNER JOIN
MSP_PROJECTS ON MSP_ASSIGNMENTS_SAVED.PROJ_UID =
MSP_PROJECTS.PROJ_UID INNER JOIN
MSP_RESOURCES ON MSP_ASSIGNMENTS_SAVED.RES_UID =
MSP_RESOURCES.RES_UID
WHERE (NOT EXISTS
(SELECT TASK_UID
FROM MSP_TASKS_SAVED
WHERE (TASK_UID =
MSP_ASSIGNMENTS_SAVED.TASK_UID)))
--Run against Published Database
As far as I'm aware the only work around is not to add a new assignment to a
partially completed task. Instead create a copy of the task and assign the
new resource to it. A pain I know!

Rod Gill,

Microsoft MVP for Project

Author of the only book on Microsoft Project VBA. For details visit:
http://www.projectvbabook.com

"

Best Regards

Bilal Okour