Unable to update Task Start/Finish Date

Products

• Clarity PPM On Premise

Issue/Introduction

Unable to update Task Start Date or Task Finish Date values on some of our projects unless we update the ETC of one of the Assignees of the Task to a non-zero value.

Environment

Release : 15.8.1

Component : CA PPM PROJECT MANAGEMENT

Cause

This is caused by xog integration when an assignment segment is created with 0 etc.

In this situation the prassignment.prstart and prassignment.prfinish dates get populated.  If the assignment has 0 etc you will not be able to update the task dates.

When you try to update the task dates a query checks the min/max dates on the assignment. If this query returns anything but 0 for those values you will not be able to update the task start and finish.

This is the query

SELECT MIN(prStart) AS prMinStart, MAX(prFinish) AS prMaxFinish, MAX(prStatus) AS prMaxStatus, MAX(prEstSum) AS prValue FROM PRAssignment 
WHERE prTaskID=<enter internal taskID)

 

Once you update the etc and then set it back to 0, the start and finish on the assignment are removed.

Resolution

In the xog file, if there is truly no ETC being added, remove this section from the xog.

Otherwise, the work around is to add etc and then remove it.