A plan cannot be imported from SharePoint task list into a PWA site in Project Server 2010

Symptoms

You try to create a new plan in Project Web App (PWA). You do this by clicking From SharePoint List on the PWA site in Microsoft Project Server 2010. However, the project update from Project Server Interface (PSI) that imports tasks to the plan fails. You find that the job status is Failed And Blocking Correlation if you open My Queued Jobs . Additionally, if you click the error message, a message displays that resembles the following:
ProjectDataSet

Table Assignment

Row: ASSN_UID =<GUID>

Error ProjectActualsArePotected (1047)-column

Table Task

Row: TASK_UID = <GUID>

Error ProjectActualsArePortected (1047) – column

General

Queue:

GeneralQueueJobFaild (26000) – ProjectUpdate.ProjectAddToMessage. Details: id=’26000’ name= ‘GeneralQueueJobFailed uid’=<GUID> JobUID=<GUID> ComputerName=<servername> GroupType =‘ProjectUpdate. MessageType=’ProjectAddToMessage’ MessageId=’2’. For more details, check the ULS logs on machine <servername> for entries with JobUID <GUID>

If you try to create the plan again, you receive the following error message:
"An unknown error has occurred on the server."

Cause

This problem occurs when the following conditions are true:
  1. The SharePoint task list contains names in the Assigned to field that are the same as enterprise resources in Project Server.
  2. The task list contains values greater than zero in the %Complete field.
The second error occurs because a project summary task is already created. All project names must be unique. Therefore, a second try to create the same plan causes a project name conflict.

Resolution

Resolution 1


Delete the plan from the Draft database and change the SharePoint List. To do this, follow these steps:
  1. Log on to PWA as the Administrator, select Database Administration in Server Settings , and then click Delete Enterprise Objects .
  2. Select the Projects and the Delete project from Draft and Published databases option.
  3. Select the name of the plan that could not be updated and then click Delete .
  4. In SharePoint List, remove either the resource name in the Assigned To section or the value in the %Complete section. Only one of these fields can contain values in order to create a new plan in PWA by using the From SharePoint List feature.

Resolution 2


Use Project Professional 2010 to create a new file from a SharePoint List. Project Professional does not have the same issue as Project Web App. To do this, follow these steps:
  1. Start Project Professional 2010 and connect to the server.
  2. Go backstage by clicking the File tab and then click New .
  3. Select New from SharePoint Task List.
  4. Type the URL for the SharePoint Task List website and then click Validate URL .
  5. Select the task list and then click OK .

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Properties

Article ID: 982763 - Last Review: Jun 13, 2010 - Revision: 1

Feedback