2007 - Error Provisioning PWA

[Viren]

I have the following environment:

* SQL2005 is my SQL Server 2005 SP2 box hosting all databases
* MOPS2007 (final version not the beta version) is where Application & Web
Tier for Project Server is running.
* MOSS2007 (final version not the beta version) is where Web Tier for
Project Server 2007 & Application + Web Tier for MOSS 2007 which includes
index, search, and mysites, etc...


I have setup the environment in the following sequence i.e. setup Project
Server with the existing MOSS installation.
1) Installed and configure MOSS2007, created farm and got my portal up and
running

2) Installed Project Sever bits to MOSS2007 & ran SharePoint Products and
Technologies configuration wizard (it detected MOSS installation
automatically and ran the SharePoint wizard by itself).

3) Installed Project Server bits on MOPS2007 & ran SharePoint Products and
Technologies configuration wizard and joined to the existing farm, created
while setting up MOSS.

I have used the following guide to setup the environment:
http://technet2.microsoft.com/Offic...d7c6-4108-b6fd-7eba162a5b621033.mspx?mfr=true

_________________________________________________________________________________________________________________
When I attempt to provision a Project Web Access Site, I get the following
error in the MOPS2007 event viewer
_________________________________________________________________________________________________________________

Event Type: Error
Event Source: Office SharePoint Server
Event Category: Project Server Provisioning
Event ID: 6971
Date: 02-Apr-07
Time: 11:27:51 AM
User: N/A
Computer: MOPS2007
Description:
Failed to provision site PWA.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
_____________________________________________________________________________________________________

Event Type: Error
Event Source: Office SharePoint Server
Event Category: Project Server Provisioning
Event ID: 6966
Date: 02-Apr-07
Time: 11:27:50 AM
User: N/A
Computer: MOPS2007
Description:
Provisioning 'PWA': Post provisioning setup failed.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
_____________________________________________________________________________________________________

Event Type: Error
Event Source: Office SharePoint Server
Event Category: Project Server Provisioning
Event ID: 7013
Date: 02-Apr-07
Time: 11:27:50 AM
User: N/A
Computer: MOPS2007
Description:
Provisioning 'PWA': Post provision setup failed.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
_____________________________________________________________________________________________________

Event Type: Error
Event Source: Office SharePoint Server
Event Category: Project Server Provisioning
Event ID: 7383
Date: 02-Apr-07
Time: 11:27:50 AM
User: N/A
Computer: MOPS2007
Description:
ProjectSite post provision setup completed with errors;
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.


Some facts:
1. I DID NOT TAKE THE MOSS BOX OFFLINE (QUIESCE) BEFORE I INSTALLED THE
PROJECT SERVER BITS ON MOSS SERVER.

2. By checking the logs I can tell that the project server databases are
correctly created. It's in this post provisioning stage where this file not
found error keeps happening.

Regards,

Viren Saini

 

[Scott Wagner [MCP, MVP]]

Provision Office Project Server 2007 sites on the farm
This final procedure allows you to create the Office Project Server 2007
instance on the farm, which is done through Central Administration. During
this process, you specify the Project Server administrator account, point to
the database server that will host the Office Project Server 2007 databases,
and name the Office Project Server 2007 databases.

Provision Office Project Server 2007 sites on the farm

1. From the top navigation on Central Administration, click
Operations.

2. On the Operations page, in the Topology and Services section,
select Manage this Farm's Shared Services.

3. On the Manage this Farm's Shared Services page, in the SSP Name
list, select the Shared Services Provider in which you would like to
provision Project Web Access.

4. On the home page for this core service, in the Project Server
section, click Project Web Access Sites.

5. On the Manage Project Web Access page, click Create Project Web
Access Site.

6. On the Create a New Project Web Access page, do the following:

a. In the Project Web Access Site Location section, from the
SharePoint Web Application to host Project Web Access list, select the name
of the extended Web site you created to host the SharePoint site.

b. In the Project Web Access path box, enter the name you will use
to specify the URL to the Project Web Access home page (for example, if you
enter PWA, the URL to the home page would be http://servername/PWA).

c. In the Administrator Account section, type the Windows user
account that will be given administrative credentials to the Project Server
instance.

d. In the Primary Database section, type the name of the computer
running SQL Server on which the Published, Draft, and Archive databases will
be located. In the three Database Name fields, type unique names for each of
the three Office Project Server 2007 databases.

Note:

You can use the default database names. However, make sure that they
do not already exist on the computer running SQL Server.

e. In the Reporting Database section, select Use the primary
database server if you want the reporting database to be created on the
Primary database server that you specified in the previous section. If you
want the Reporting database to be created on another computer hosting SQL
Server, clear this option and enter the name of the SQL Server on which you
want it to be created. In the Reporting database name field, type a unique
name that you want to use for the Reporting database.

Note:

You can use the default database name. However, make sure that it does
not already exist on the computer running SQL Server.

7. Click OK. The provisioning process starts.

8. You will return to the Manage Project Web Access page. Click the
Refresh Status button to update the status of the provisioning process. When
provisioning is complete, Provisioned will appear as entry in the Status
column. When provisioning has been completed, you can click the URL to go to
the Project Web Access site.

Note:

Provisioning is an asynchronous process, so it might take a few
minutes before the job is complete.

 

[Viren Saini]

Scott,

Thank you so much for the information that you have shared.

However, I am facing the problem at the STEP 8, that you have mentioned in
your post, where it shows the status as 'Failed - see the Event Log'. When i
see the event log into the Project Server machine, it shows the error
messages that i had shared in my post.

Regards,

Viren Saini

 

[David R]

Scott,

I am having the identical problem with setting up PWA. I have followed all
the steps, yet get this cryptic error. If you or anyone has any ideas about
how to resolve this, please let us know.

David R