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 stopped and threw 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

please check this url

http://www.microsoft.com/office/community/en-us/default.mspx?&query=service+stopped&lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.project.server&p=1&tid=f733dcea-a6ad-4b0e-8b88-9abe22737e2a&mid=a61247e3-026c-4988-954c-6000c2186305

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. Again I considered it as a bug because it did not report this to the event log.

Best Regards

Bilal Okour

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

Dear All,

Thanx only to God ...

and our first Community open Day went very successfully with 110 person attend. The initial feedback we received I can summarize it as the following

1. Those who attend, most of them never left till the last minute, thank you our audience, we promise you that our session quality will be always like this and better
2. The organization was amazing, thank you both DotNetBoom and ProRanger teams, don't forgot the superman, Bashar lulu
3. The content was very rich, thank you for those who spoke (Fady, Omar, Ehab, Loay, Alaa, Mustafa, Anton and Myself)
4. We have been requested to do an extension for this even as most of the audience became more welling to know more.

I have posted a photo album for this community event, please check out my photo album in this blog

Best Regards

Bilal Okour

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 Tasks" 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

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

Next Saturday will be a unique experience for me , I will be conducting two sessions in Microsoft Enterprise Project Management solution

So far the registered people for the event are around 280+, I don’t know how much will really attend my sessions but for sure they are going to be BIG.

I am so excited to get into this experience as it is really a challenging one. So wait for me in this event and don't forget to wish me the best wishes

For more details please refer to the ad somewhere below this post

Best Regards

Bilal Okour

To use outlook as a client for Microsoft Project 2007

1. First upgrade to version 2007
2. Got to EPM site ==> Personal Setting ==>  Set up Outlook synck  ==> Download
3. Complete the download
4. Close and open your outlook

1. On the top left corner you will find “Import New Assignment”, only for the first time it will ask you about your server name and credentials, after that each time you will open Outlook the importing of the new tasks will take place as the first step after outlook is opened and it will synchronize what is ever there in the Server
2. After updating the task using Outlook then you have to click on “Update Project Access”

Best Regards

Bilal Okour

Best Regards

Bilal Okour

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. MVPs Open Day, Executed by one of the largest company in kuwait and it is going to be the first event hre 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
   
2. 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.

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

Best Regards

Bilal Okour

This question is always being asked : What task type should I use, I wrote two posts earlier about only this topic, you can refer to these posts to get a clear idea about what I am talking about, here are the links for those posts

http://ebilal.spaces.live.com/blog/cns!1EB5037F50572440!696.entry

http://ebilal.spaces.live.com/blog/cns!1EB5037F50572440!658.entry

Now in this post I will only give examples to illustrate the different types of MS Project 2007 Tasks Types

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

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