PS2007 Task Update not working

[Mike Mahoney]

A number of users have submitted a variety of updates including new tasks.
These were approved and MSP prompted to load the updates into the plan. The
plan however was not updated.
The Applied Task Update Requests and Errors clearly show the updates
accepted. The Manage Queue page shows no errors.
However the event log has the following error:

Event Type: Error
Event Source: Office SharePoint Server
Event Category: Project Server Task Statusing and Updates
Event ID: 7838
Date: 16/05/2007
Time: 10:48:28
User: N/A
Computer: CCM-PRDPRJ01
Description:
Standard InformationSI Entry Point:
Project User: CHEYNE\ckim
Correlation Id: 7be874e4-6eb9-4703-a991-5a60f8ab6b3f
PWA Site URL: http://ccm-prdprj01/ProjectServer
SSP Name: SharedServices1
PSError: StatusingApplyUpdatesFailure (3124)
Task updates could not be applied to the Project Server database. Project
UID: 0c058847-ff59-4d07-a52b-89f5caa0ed7d. Job UID:
7be874e4-6eb9-4703-a991-5a60f8ab6b3f. Sub job ID: . Error details:
System.NullReferenceException: Object reference not set to an instance of an
object.
at
Microsoft.Office.Project.Scheduling.TaskScheduler.ScheduleSummaryTask(SessionSchedule
schedule, CpmDateTypes cpmDateType, Boolean assignmentsToSchedule, Project
project, ProjectSchedule projectSchedule, Task summary, TaskSchedule
summarySchedule)
at
Microsoft.Office.Project.Scheduling.TaskScheduler.Schedule(SessionSchedule
schedule, SchedulingOptions options, AllocationInfo allocationInfo,
TaskSchedulingPass taskPass, CpmDateTypes cpmDateType, PlanOption planOption,
Project project, Task task, AssignmentPlan plan, TaskSchedule taskSchedule)
at
Microsoft.Office.Project.Scheduling.SessionSchedulerBase.ScheduleForward(SessionSchedule
schedule, SchedulingOptions options, TopologicalOrder topOrder, Heap
asapAlapHeap)
at
Microsoft.Office.Project.Scheduling.SessionSchedulerBase.Schedule(SessionSchedule schedule, SchedulingOptions options)
at Microsoft.Office.Project.Scheduling.Scheduler.Schedule(SessionSchedule
schedule, SchedulingOptions options)
at Microsoft.Office.Project.Scheduling.Scheduler.ScheduleCore(Session
session, SchedulingOptions options)
at
Microsoft.Office.Project.Scheduling.Scheduler.ScheduleApply(ISchedulingEngineData data, ISchedulingOptions options, SchedulingDataFilter filter)
at
Microsoft.Office.Project.Scheduling.SchedulingEngineData.ScheduleApply(ISchedulingOptions options, SchedulingDataFilter filter)
at
Microsoft.Office.Project.Server.BusinessLayer.StatusApprovalMessageHandler.Schedule(PlatformContext context, SchedulingDataAccess data)
at
Microsoft.Office.Project.Server.BusinessLayer.StatusApprovalMessageHandler.ProcessCore(StatusApprovalApplyResult
result, StatusTransactionState expectedState, Boolean keepSchedulingResults)
at
Microsoft.Office.Project.Server.BusinessLayer.StatusApprovalMessageHandler.Process(StatusApprovalMessage
message, StatusTransactionState expectedState, Boolean keepSchedulingResults,
StatusApprovalApplyResult& result)
at
Microsoft.Office.Project.Server.BusinessLayer.StatusApprovalMessageHandler.Process(StatusApprovalMessage message)
at
Microsoft.Office.Project.Server.BusinessLayer.Queue.ProcessStatusApprovalMessage.ApplyStatusUpdates(Message
msg, Group messageGroup, JobTicket jobTicket, MessageContext mContext)
at
Microsoft.Office.Project.Server.BusinessLayer.Queue.ProcessStatusApprovalMessage.ProcessMessageCallback(Message
msg, Group messageGroup, JobTicket jobTicket, MessageContext mContext).

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.

We are in the process of dumping the approval page into excel so we can
manually retrieve these situations, however we are losing a lote of notes and
credibility with Team Members

 

[NZ Projects]

One identified cause of this issue is bad data in the assignment contour
causing an
infinite loop during rescheduling. The assignment with the bad data need not
be
any of the assignments being updated. It maybe identifiable in Project
Professional
2007 by comparing the data in Task Usage and looking at the totals on the
left hand
pane - with the total of timephased entries in the right hand pane. For
example there maybe
a 100% complete tasks that show 15h in the left pane but
only a total of 8h in the right hand pane.

If the bad data is identified and corrected in Project Professional 2007 and
then
saved and published then preview will work and updates can be processed.

To correct use the task usage view and zero all data for the assignment
(left hand
and right hand pane) and then re-enter through the timephased view and
ensure the
left and right hand totals are the same.

 

[mike.mahoney]

One identified cause of this issue is bad data in the assignment contour
causing an
infinite loop during rescheduling. The assignment with the bad data need not
be
any of the assignments being updated. It maybe identifiable in Project
Professional
2007 by comparing the data in Task Usage and looking at the totals on the
left hand
pane - with the total of timephased entries in the right hand pane. For
example there maybe
a 100% complete tasks that show 15h in the left pane but
only a total of 8h in the right hand pane.

If the bad data is identified and corrected in Project Professional 2007 and
then
saved and published then preview will work and updates can be processed.

To correct use the task usage view and zero all data for the assignment
(left hand
and right hand pane) and then re-enter through the timephased view and
ensure the
left and right hand totals are the same.








- Show quoted text -

That's a useful observation. We have had a range of problems
publishing data and always comes down to an assignment issue. My debug
approach has been to change the task publish setting to "No" on a line
by line basis to identify the problem task /assignment. This is a
painfully slow method.

Thanks

Mike