Skip to main content
Language Selector

  1. Other Languages

    (machine translation)

Planview Customer Success Center

MSP work code and work location is not saved

  1. Last updated
  2. Save as PDF

Symptoms:
On some tasks the work code and work location will not retain their value after setting them in MSP and saving back to Changepoint. The values are empty again, the next time the plan is open in MSP.

Reason:
Work code/location changes in MSP are not saved to Changepoint since the impacted tasks has no work code or location information in Changepoint.


Resolution:
1-Use the query below to find the impacted project and task names:

select 'Missing records in TaskWorkDefaults', p.name 'Project', t.WBS, t.Name 'Task', tw.TaskID, t.*
from Project p (nolock) inner join
Tasks t (nolock) on p.projectid = t.projectid left outer join
TaskWorkDefaults tw (nolock) on t.taskid = tw.taskid
where t.deleted = 0 and tw.taskid is NULL
order by p.name, t.WBSorder

2-Update the tasks listed by the query in Changepoint first, and then link to MSP with “Update all” option. From that point on the work code and location updates will be transferred in both directions (from / to MSP).