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

Article translations Article translations
Close Close
Article ID: 982763 - View products that this article applies to.
Expand all | Collapse all

On This Page

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: June 13, 2010 - Revision: 3.0
APPLIES TO
  • Microsoft Project Server 2010
Keywords: 
kbtshoot kbprb KB982763

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com