Error "ProjectAlreadyExists"

Wszystkie odpowiedzi

• 13 stycznia 2011 15:53

   

   
  

  0

  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.

   

  Grtz, J

  • Zaproponowany jako odpowiedź przez Christophe FiessingerMicrosoft Employee, Owner 13 stycznia 2011 20:55
  •  
  • Odpowiedz
  • Cytuj

   
• 13 stycznia 2011 21:14

  Właściciel

   

   
  

  1

  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.

  Best regards,

  Brian.

  ---

  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

  • Zaproponowany jako odpowiedź przez Amit Khare - Project Management Consultant 9 maja 2012 12:31
  •  
  • Odpowiedz
  • Cytuj

   
• 14 stycznia 2011 07:27

   

   
  

  0
  Hi. 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.
  • Odpowiedz
  • Cytuj

   
• 14 stycznia 2011 16:11

  Właściciel

   

   
  

  0

  Do you see a record in the MSP_PROJECTS table in the  Draft DB for the project you try to create?

   

  ---

  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
  • Odpowiedz
  • Cytuj

   
• 17 stycznia 2011 12:27

   

   
  

  0
  No, I searched all 4 databases but I didn't find this project. It is strange.
  • Odpowiedz
  • Cytuj

   
• 17 stycznia 2011 15:04

   

   
  

  1
  I 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

  • Zaproponowany jako odpowiedź przez Clark Wilson 27 października 2011 23:05
  •  
  • Odpowiedz
  • Cytuj

   
• 9 maja 2012 11:22

   

   
  

  1

  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

  
  

  
  

  ---

  - Dennis | Netherlands | Blog | Twitter

  • Zaproponowany jako odpowiedź przez Jan R. Cirpka 9 maja 2012 11:27
  •  
  • Odpowiedz
  • Cytuj

   
• 22 maja 2012 17:21

   

   
  

  0

  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>

  • Zmodyfikowany przez Clark Wilson 22 maja 2012 17:26 noticed my name above
  •  
  • Odpowiedz
  • Cytuj

   
• 22 maja 2012 20:01

  Właściciel

   

   
  

  0
  No 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.

  ---

  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

  • Odpowiedz
  • Cytuj