Skip to main content
Planview Customer Success Center

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)