Site of deleted projects not removed

M

Monika

Hi all,

I delete a project from Project Professional 2003.
The link of the site is also removed. for example (
http://server/sites/projectserver_150 )
I checked this in "Admin" -> "Manage Windows Sharepoint Services" -> "Manage
Sharepoint sites"
The deleted sitelink doesn't appear anymore.

But when it try to access the site of the deleted project, i can do that.
Is that a normal behavior?

thanks!
 
D

Dale Howard [MVP]

Monika --

When you delete the project on the Clean up Project Server database page in
PWA, are you remembering to select the "Delete the SharePoint team web site
for the specified project" option as well? If you don't select that option,
the SharePoint site is obviously not going to be deleted. Let us know.
 
M

Monika

OK.
but normally the project manager deletes the project with project
professional 2003.
-> FILE -> OPEN -> select the project --> then delete it.
With this approach you don't have a chance to remove also the belonging
sharepoint site.


So, is there really no way to find the obsolete sharepoint sites?

The only way to find the orphaned sharepoint sites is to increment the
links, beginning with
http://server/sites/projectserver_101
http://server/sites/projectserver_102
http://server/sites/projectserver_103 etc

and compare it with the published list of sites. ("Admin" -> "Manage Windows
Sharepoint Services" -> "Manage Sharepoint sites")
Then i goto the link and delete it.
But this is a very boring job!!

Also a Project Manager doesn't see the menu "Clean up Project Server
database" in PWA

thanks
monika
 
D

Dale Howard [MVP]

Monika --

I believe it is a mistake to allow project managers to delete their own
projects through Microsoft Project Professional. As the Project Server
administrator, you have lost control of the process, and as a consequence,
you now have orphaned SharePoint sites. The best way to locate and delete
the orphaned sites is to do it the way you are doing it, which is a boring
manual process.

To correct your current situation, I would propose that you set the Delete
Project permission for the Project Managers group to Not Allowed, which
means that neither Allow or Deny is checked for that permission. As the
Project Server administrator, you should have the sole authority to delete a
project in PWA, and then you can delete the associated SharePoint web site
at the same time. Hope this helps.
 
R

Rafael Dorneles

Hello Monika...
I had the same problem, and I discovered that unique way to delet this
site is in the database.

1 - In the Project Web Access click in "Admin", after in "Manager Windows
SharePoint Services", take note about the ID of the project that you want to
take off the site reference.
2 - Conect to the Project Server Database (SQL Server), Query Analyser,
select the Project Database and run this query:

UPDATE MSP_WEB_PROJECTS
SET WPROJ_STS_SUBWEB_NAME= 'NONE'
WHERE WPROJ_ID = <Project ID>

<codProject ID> = Change to the ID Project that you took a note in the web
access

It´s this...


"Monika" escreveu:
 
Top