The Project could not be saved to the server In Project Server

I have tried to save a project using Microsoft project that connected to Project Server, the job fails with the below error :

Error ID: 12005 [0*2EE5]

Queue failed to process the message, The Project could not be saved to the server

Queue failed to process the message, The Project could not be saved to the server


Cause

This problem might occur because of trying to insert a duplicate key row in object ‘dbo.MSP_RESOURCES’ with a unique index ‘IX_MSP_RESOURCES_RES_NAME’ in resources.


Solution

In my case,  I didn’t have any duplicated resource. therefore, I will try to map Resource again by doing the following:

Publish Project using Import Wizard in Project Server

  • From Project Professional > File > Save & Send > Save As.

Publish Project using Import Wizard in Project Server

  • Click on Map Resources then Continue to step 2.

Map Local Resources to Enterprise Resources

  • Complete the Import Project Wizard to step 5 >  Click on Save As to save the project to project server that should now be saved successfully.

Save Project in Project Server - project saved successfully

  • Publish the project.

Publish Project in Project Server - project published successfully


Applies To
  • Project Server 2016.
  • Project Server 2013.
  • Project Server 2010.
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s