Missing Site Template

[Larry]

Hi to all:
Our MS Project 2003 has been working correctly for about 6 months. Last week
we started getting these errors: "Error occurred when creating site. Site
does not seem to exist."

MS suggests that I remove any special characters from the project name so I
published a project named Test. - No change
MS suggested that I check for a valid e-mail address in Site Provisionings.
I changed it to several different valid e-mail accounts - No change

However, I have noticed that the Site template: selection is blank, with no
drop down on the "Windows SharePoing Services team Web site provisioning
settings" site. (Admin/DefaultSTSSettings.asp)
Is this causing the problems.
Thanks for your help

 

[Ross Andren]

Can you confirm the presence of a template (*.stp) file in the following
location:

"<install drive>:\Program Files\Common Files\Microsoft Shared\web server
extentions\60\Bin\"

I am assuming here, that the sites that were created before this error are
all still working correctly, and that this error only occurs when you try to
create a new site?

 

[Larry]

Ross:

I checked our three servers and didn't find any *.stp files. We have
divided our MS Project system into three servers, 1.) MS Project server, 2.)
SharePoint server for the Project front end, and 3.) SQL server for the data
backend.

As a test, I was able to manually create a new SharePoint web site using the
Project Workspace template, so it has to be somewhere. The SQL database?

Yesterday I ran the three updates in MS Project SP2a on all servers. Still
no changes.

Any thoughts. And thanks for your help.
-Larry

 

[Ross Andren]

Sorry I missed the detail earlier, but when you say the drop down is blank
for template selection, do you mean that it hasn't been selected, or that
there is nothing to select? - You should see that there is a drop down
option of 'Project Workspace' at minimum. If this is selected and the page
saved, site creation should (hopefully) occur without issue. If you can
create a site manually (by manually I am assuming you mean using the Manage
sharepoint sites page), I don't think that there is an issue with the WSS
not functioning because it cannot find a template.

If the drop down option is missing, unless anyone else has a better
suggestion, I would run the WSS Wizard to re-establish the interaction
between Project Server and WSS (take backups first!) - This should get the
drop down populated.

If the drop down is there, selected and saved and you still have issues, I
would suggest checking the rights of the WSSAdmin user that was set up at
install, ensuring that they are appropriately set up in all the correct
servers (check install docs from MS for details)

Let us know

 

[Larry]

Ross:
I ran the WSS wizard without any success. So I got out my credit card and
called MS Technical support. Here is what we did to get it up and running.
In summary we took it all apart and reassembled it. We got it to finally
work. Here is what we did.
Thanks again for all of your help. Look forward to your future advice
Have a good holiday.

RESOLUTION :
============
1. Sharepoint sites are not getting created.
2. We ran the WSS wizard and Proxycfg.
3. Added WSS admin user in sharepint administrator group STS_WPG for both
project server and sharepoint server.
4. Ran PSComPlus tool and pointed the WSS admin user.
5. Re-pointed the content database with the SQL server name changed.
6. Changed the sharepoint server name. Used the original NetBIOS name
instead of the alias for both SQL and Sharepoint server
7. Saved the changes in the PWA sharepoint settings. This time we could save
the changes.
8. Still the sites were not creating.
9. Created a new website with a different port.
10. Extended it and pointed it to the original content database.
11. As it was showing the ‘config database not present error’ while browsing
the website we took Hemant from WSS team in conference.
12. Changed the application pool for the new website as per KB823287.
13. We then tried the settings back on the default website. It worked.
14. We could create the sharepoint sites manually. But automatic site
creation is not working.

 

[nickpangaro]

I was having the same problem with a new installation. I found that when
I went to the top level page of the server, I got some kind of
restricted access message. Googled that message and came up with this.
See if this helps you at all, it was their Method 3 that did it for me

 

[Marc S.]

Larry,

what happens if you click the 'Save Changes' button on the 'Connect to
SharePoint server' site (Admin/StsAdMod.asp) in the Admin section? Do you get
any kind of error message?

This is the easiest way to validate the connection between Project Server
and WSS.

Let us know...

Marc