Error when linking a project in MSP (CP2014)
SYMPTOMS:
Following error occurs when linking a project in MSP:
ERROR/WARNING MESSAGES:
System.Exception: The argument value is not valid.
at Changepoint.MSP.ClsMSPWorkflowManagement.LoadTaskAndAssignment()
at Changepoint.MSP.ClsMSPWorkflowManagement.MainLoadCPDataToMSP()
REASON:
Task names have non-printable characters.
RESOLUTION:
Execute the query provided below to find the list of impacted projects and tasks. Then modify the task names, by following the steps below:
1- Edit the task in Changepoint task profile page, click on task name
2- Press Ctrl+A to select all, then press "x" to replace the name by the letter "x" , save the task
3- Remove "x" and type the name of the task (do not copy & paste, use the keyboard only to type the name), save the task again
ADDITIONAL NOTES:
Execute the query provided below to find the list of impacted projects and tasks:
;WITH AllNumbers AS
( SELECT 1 AS Number
UNION ALL
SELECT Number+1
FROM AllNumbers
WHERE Number<1000
)
SELECT
p.name 'Project', t.wbs, taskid, t.name 'Task', ASCII(SUBSTRING(t.name, n.Number, 1)) 'ASCII' , r.name 'Project Manager'
FROM tasks t(nolock)
INNER JOIN AllNumbers n (nolock)ON n.Number <= LEN(t.name)
inner join project p (nolock)on p.projectid=t.projectid
inner join ManageMember m (nolock)on m.projectid=p.projectid
inner join Resources r(nolock) on r.resourceid=m.resourceid
WHERE ASCII(SUBSTRING(t.name, n.Number, 1))<32
order by 1, 2
OPTION (MAXRECURSION 1000)