Reinstalled Project Server 2007 and can no longer reach Project Workspaces

[Project Server Slave]

Hello,

We did a complete wipe of our server and then reinstalled Project
Server 2007. We used the same WSS_Content DB and the same archive,
draft, published and reporting DB's. When I try to go to any of the
project work spaces, they we get a page cannot be found, 404 error.

One thing about the installation that should be noted. It wouldn't
let us specify PWA as the address, because it said it already
existed. We wiped the box so I have to assume that this is in the
database somewhere. So we changed the address to something like
OCPWA. So everything in Project Server works fine, but we cannot get
to the Project Workspaces anymore and the event log has the errors
below whenever someone publishes a project.

Event Type: Error
Event Source: Office SharePoint Server
Event Category: Project Server Sharepoint Integration
Event ID: 7866
Date: 5/25/2007
Time: 8:47:35 AM
User: N/A
Computer: PROJECT01-OC
Description:
Standard InformationSI Entry Point: WssInterop.CreateWssSite
Project User: OPUSCREATIVE\spencerf
Correlation Id: 5fc38579-1277-4fc3-8f77-f74efdbc4a4a
PWA Site URL: http://project01-oc/OCPWA
SSP Name: SharedServices1
PSError: WSSProjectAlreadyHasSpWeb (16404)
The Web site specified is already linked to another project. Select
another Web site and try again.

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.


Can anyone recommend how to fix this situation? Thank you.

 

[Ben Howard]

Hi,
The part of the log that gives the clue is
PSError: WSSProjectAlreadyHasSpWeb (16404)
The Web site specified is already linked to another project. Select
another Web site and try again.
It means that the project workspace template already has a project
associated with it, presumably from the previous site collection (this is a
wss issue rather than Project Server).

To resolve the issue, you need to create another WSS Project Template from a
non-project workspace, and then reference this workspace from within the
Project Server administration. There is a reference to this here
http://msdn2.microsoft.com/en-us/library/ms503640.aspx - and note the
community content at the end.

If you create a new template based on a site that is already linked to a
project, then you will get an error when trying to provision a new site for
any other project from this template. You should instead start with a clean
site provisioned from the Create Site Collection option within SharePoint
Central Administration - based on the Microsoft Office Project Workspace
template. This will then avoid this error.

 

[Project Server Slave]

Hi,
The part of the log that gives the clue is
PSError: WSSProjectAlreadyHasSpWeb (16404)
The Web site specified is already linked to another project. Select
another Web site and try again.
It means that the project workspace template already has a project
associated with it, presumably from the previous site collection (this is a
wss issue rather than Project Server).

To resolve the issue, you need to create another WSS Project Template from a
non-project workspace, and then reference this workspace from within the
Project Server administration. There is a reference to this herehttp://msdn2.microsoft.com/en-us/library/ms503640.aspx- and note the
community content at the end.

If you create a new template based on a site that is already linked to a
project, then you will get an error when trying to provision a new site for
any other project from this template. You should instead start with a clean
site provisioned from the Create Site Collection option within SharePoint
Central Administration - based on the Microsoft Office Project Workspace
template. This will then avoid this error.

Thanks Ben. I ended up going into the Published DB and just deleting
the values in the column that listed the Work Space Path. I had to
NULL out a few other values, like WSS Roles etc, but then I was able
to create a site from scratch again through PWA. Thanks for the help.