During saving, a project via Microsoft project that connected to Project Server, the job fails with the following 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 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 following the mentioned steps below:
- 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.
- Puvlish the project.