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
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.
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.
- Click on Map Resources then Continue to step 2.
- 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.
- Publish the project.
- Project Server 2016.
- Project Server 2013.
- Project Server 2010.