Quote

How to determine which version of a 2007 Office product is installed?

Project Interdependency in Project Server 2007 Part 1 (Linking Tasks across Projects)

What is interdependency of Projects?

During the executing of project work, the entire execution may not be solely independent of external influences of external projects.

During the planning phase, it is important that a matrix of interdependencies of projects and program of work is established.

Keeping across externally dependent tasks or activities is equally important to managing tasks on the critical plan on your project.

How to set Project interdependency between projects in Project Server?

Open the Project for which the interdependency is to be set in MS Project Professional (in edit mode)

In the Predecessors column type in <>\Project Name\Task ID where Project Name is the name of the Project to which the predecessor dependency is to be set.

The Project ID is the task ID of the task for which the predecessor relationship is to be set.

Once this has been set you will notice a ghost dependent task appear from the dependent project in your project plan.

Save and Publish the Project Plan.

Note: To set this inter-dependency it is important to open the dependent project in at least ‘read only’ mode. For this inter-dependency to be reflected in both Project Plans, both projects need to be opened in Edit Mode and changes saved accordingly.

What happens if the dependent task on the external project changes?

When the dependent task on the external project changes, the next time the project is opened, changes to the external predecessor task will be shown.

The user will have the option to accept the changed on dependency to the external project or if needed Delete the Link.

On Accepting and closing the dialogue box the accepted changes are reflected in the project plan.

MS Project Server 2007: My Tasks Web Part Error

1. One or more of your resource report that his "My Tasks" is showing a SharePoint error message

2. If you know how to query your database (Published DB of your server) and get unfortunately one row at least, this would indicate a corrupted

Task assignment.

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)))

To resolve this issue try 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

Optionally

· Create a new task with remaining work as work from Task corrupted.

· Re-assign the resources to this task.

· Release the resources from the previous task whereby Remaining Work = 0 and task maked 100% complete.

· Publish the Task/Project

How can Tasks get corrupted?

A common trend that I have seen is for Tasks that are tracked following the Actual work done and work remaining. (Where Resources report the actual work done and the work remaining to be done on each task) whereby, actuals have been entered against this task. If the project manager then switches and tracks progress on task with % complete this could corrupt task assignments giving rise to the error.

Project Server 2007 Data Analysis errors and common issues faced

   

I have faced a number of scenarios where client machines are not able to process the data analysis views of PWA. Some of the common error messages faced were.

Error Message

Project Server query could not be processed.

Cannot connect to the server 'Project Server'. The server is either not started or too busy.

 

Situation 1: Missing components on the client machine.

Refer to article View OLAP Cube data   Describes methods for your users to access OLAP cube data.

It is important you read this article.

 

Component			Version	State during installation
Microsoft Core XML Services (MSXML)			6.0	All components are available in the downloadable Feature Pack for Microsoft SQL Server 2005.
Microsoft SQL Server 2005 Analysis Services OLE DB provider			9.0
Microsoft Office Web Components 11 (OWC11)			2003	This is if you have office 2003 installed on the client machines. If you have another version of Office, you will need to install the appropriate Office Web Component for that version

 

Situation 2: Cross liking of MSOLAP dll

 

If you have a situation where by the issue is client machine specific after ensuring that the above components are installed and available, I would suspect a cross interference of msolap dll.

I have seen this happen in the past and adopted the following to get around the issue.

The registration of MSOLAP90.dll may not have been completed as being default. A prior version of MSOLAP dll may be registered as the default. 

Browse to location of MSOLAP dll using the command prompt and run the following. (you can easily find the location of MSOLAP.dll by runnin a search for MSOLAP*.dll on the client machine)

Sometimes instances of 8.0 and 9.0 get cross linked. Run the below from command prompt 

• Regsvr32 –u msolap80.dll
• Regsvr32 –u msolap.dll
• Regsvr32 –u msolap90.dll
• Regsvr32 msolap90.dll

Now try and access the Data analysis Views.