Skip to main content

Posts

Showing posts from March, 2008

Query to find the deleted Tasks in Projects

All,

Hope this query will help you in finding the Deleted tasks form MS-Project 2003. In this case, team members can see the PWA tasks in their timesheet but they can't update the Actual hrs.
Run this query againstProjectServer database:

select
mp.Proj_Name AS [Project Name],
ma.TASK_NAME AS [Task Name] ,
ma.ASSN_START_DATE AS [Start date],
ma.ASSN_FINISH_DATE AS [Finish date],
ma.ASSN_WORK/60000 As 'Work',
ma.ASSN_ACT_WORK/60000 As 'Actual Hours Reported',
mr.RES_NAME As Resource
from MSP_WEB_ASSIGNMENTS ma
JOIN MSP_WEB_PROJECTS mp ON ma.WPROJ_ID = mp.WPROJ_ID
JOIN MSP_WEB_RESOURCES mr ON ma.WRES_ID = mr.WRES_ID where
ma.WASSN_DELETED_IN_PROJ <>0
Order by mp.Proj_Name

Actions to take if the Project Server 2007 queue stops processing jobs

There are several reasons why the queue can get stuck. The easiest way to know whether the queue is stuck is to look in the Manage Queue page in PWA. If there are several jobs sitting in the “Waiting to be processes” state, then the queue is most likely stuck.

The thing to do first is to find the one job that is in queue position 1 and that is holding up all the other jobs from processing. Follow these steps to help find the stuckedjob:

1) In the “Manage Queue” page in PWA>Server Settings expand the “Job History” and set the “From Date” back to as early as you think the stuck job might be found. A week back would probably be sufficient if this is a recent occurrence.
2) In the “Job Completion Status” remove all jobs statuses and only add back in the following: Getting Queued, Processing
3) Hit the “Refresh” button in the Jobs Grid