Skip to main content
Planview Customer Success Center

A resource assigned to a workgroup has a termination date, how to remove it? (2014)

SYMPTOMS

A resource that is currently assigned to a workgroup has the field 'termination date' populated. The field is grey and disabled and the date cannot be removed. There is no menu option to unassign the resource and reassigning it to a different workgroup has no impact. How to remove the termination date?


RESOLUTION

The symptoms point to an inconsistency in the table WorkgroupHistoryMember. To clean this up, please execute the following SQL against your Changepoint database:

exec workgroupMembershipAnalysis '<resourceid>',1

e.g.

exec workgroupMembershipAnalysis '80432237-B43B-4317-9F21-02A986812FDE',1

This will not remove the termination date but it will clean up the inconsistencies in the table WorkgroupHistoryMember. After this, you can edit the resource and unassign and reassign it. This removes the termination date.

For unassigning/reassigning a date needs to be specified. Please make sure to choose the same date in both cases or there will be a gap in the availability.