13 ianuarie 2011 11:18Hello! I have a question. Why I get error "ProjectAlreadyExists" when I create the project though it doesn't exist in archive, draft, reporting, publishing bases. This project I created before, but it didn't create because of error in its task. Now I try create this project and get error "ProjectAlreadyExists". I use MSProject 2010.
13 ianuarie 2011 15:53
You can try cleaning your cache and double check the project isn't existing on the server using the open dialog, checking both published and draft projects.
- Propus ca răspuns de Christophe FiessingerMicrosoft Employee, Owner 13 ianuarie 2011 20:55
13 ianuarie 2011 21:14Proprietar
Hi Andromeda61 - You could also take a look in the Server Settings option of Delete Enterprise Options to see if the already existing version can be deleted. When you create a project the first thing that happens is a check is made that the name isn't already in use - then a placeholder goes into the database. I'm guessing things went wrong for you at that point and it is this placeholder that is blocking you using the same name again.
Blog | Facebook | Twitter | Posting is provided "AS IS" with no warranties, and confers no rights.
Project Server TechCenter | Project Developer Center | Project Server Help | Project Product Page
- Propus ca răspuns de Amit Khare - Project Management Consultant 9 mai 2012 12:31
14 ianuarie 2011 07:27Hi. I create the project via PSI with the same guid (PROJ_UID) and get the error of existing project. But if I create the project with the same name in PWA by hand I don't have this problem. I cheked in Server Settings option of Delete Enterprise Options. This project exists nowhere.
14 ianuarie 2011 16:11Proprietar
17 ianuarie 2011 12:27No, I searched all 4 databases but I didn't find this project. It is strange.
17 ianuarie 2011 15:04I decided this problem. Guid of this project left in DB Archive in tables MSP_WEB_SECURITY_PROJECT_OWNERS and in views MSP_WEB_SECURITY_PROJECT_OWNERS_PUBLISHED_VIEW
- Propus ca răspuns de Clark Wilson 27 octombrie 2011 23:05
9 mai 2012 11:22
We have experienced the same problem occasionaly using the following scenario:
1. Create the project with a given PROJ_UID using the QueueCreateProject PSI call
2. Delete the project using the PSI QueueDeleteProjects call
3. (Re-)create the project using the QueueCreateProject PSI call.
We are getting the ProjectAlreadyExists error in step 3.
Reflection of the QueueCreateProject PSI call shows, that this error is only returned if one of the following two stored procedures MSP_SECURITY_CHECK_PROJECT_HAS_OWNERS and MSP_PROJECT_CHECK_PROJECT_EXISTS finds the PROJ_UID. In our case it is the first one, which inspects the MSP_WEB_SECURITY_PROJECT_OWNERS table.
We do not know why the entry in the MSP_WEB_SECURITY_PROJECT OWNERS table was not deleted in the second step. In fact we are not even sure that step 2 was executed at all - it may be that step 1 did fail during its processing without cleaning up intermediate steps.
To verify that we do have some 'leftovers' from the deletion we used the following SQL query (NOTICE: Any query against the Published or Draft database is NOT supported!)
USE [ProjectServer_Published] GO select S.* FROM MSP_WEB_SECURITY_PROJECT_OWNERS AS S LEFT JOIN MSP_PROJECTS P ON P.PROJ_UID = S.PROJ_UID WHERE P.PROJ_UID IS NULL
- Propus ca răspuns de Jan R. Cirpka 9 mai 2012 11:27
22 mai 2012 17:21
I have experienced twice now the exact situation Dennis has documented very well here.
<blush> In fact I now notice above "Proposed As Answer by Clark Wilson Thursday, October 27, 2011 11:05 PM" <\blush>
- Editat de Clark Wilson 22 mai 2012 17:26 noticed my name above
22 mai 2012 20:01ProprietarNo blush necessary Clark. You'd be suprised how many times I find an answer for an issue on my own blog - that I'd forgotten I ever wrote.