Publish project....can't see it on PWA...no errors

[JodyJ]

Created a project in MS Project Pro. Published it. I can see the project in
Project Center but when I go to View a Project, none of the detail is there.
I'm the PM and also assigned to a few tasks. These tasks aren't showing up
under the Tasks tab in PWA. I'm getting no spooler errors.

The only thing that I know of that changed was the install of SP1.

Any ideas what is wrong? All of this functionality worked just fine prior
to the installation of the SP.

 

[Reid McTaggart]

SP1 should have been installed on Project Server as well as on your PC. If
it's on one and not the other, trouble follows.

 

[JodyJ]

It's on both. ???????

SP1 should have been installed on Project Server as well as on your PC. If
it's on one and not the other, trouble follows.
--
Reid McTaggart
Alegient, Inc., Houston
Project Server Experts
Microsoft Certified Partner

 

[Reid McTaggart]

Both or neither, not a mix.

 

[Reid McTaggart]

Here's the download link for PS2K3 SP1
http://www.microsoft.com/downloads/...62-d534-4f17-ab08-7c9b790c5b15&DisplayLang=en

 

[JodyJ]

I have SP1 installed on both project server and on my local PC.

 

[JodyJ]

The only other thing that I can think of that was changed was the RBS.
Previously, it wasn't set up. I set up several levels and assigned them to a
subset of the resource file. Thinking this may be contributing to my
problem, I deleted all the entries in the RBS lookup table and removed the
values from each resource in the Enterprise Resource Pool. I tried to
publish the project plan again....same result. Tried to create a brand new
plan and publish it....same result.

 

[Reid McTaggart]

Maybe we should touch back to the basics. Can you see any projects' details?
Have you checked to ensure that there is a project detail view defined and
that your permissions allow you to use it? Have you clicked the Revert
button under the Filter,Group,Search tab to ensure that no oddball filters
are applied?

 

[Gary L. Chefetz [MVP]]

Jody:

Do you see any errors in the server application event log?

 

[Jonathan Sofer - MCP]

Jody,

When you did your SP1 upgrade did you do the following?

Upgrade the database
It is advised that you back up your database before applying any updates.

Note: You must follow the steps below for each SQL Server and database.
a.. Download the SQL patch, ProjectServer2003-KB837241-SQLFile-ENU.exe.
b.. Double-click on the file to extract the files to a temporary folder.
c.. To apply the files, Osql.exe is required in the same directory from
where Upgdb111.cmd is run or in the system path. If you are running
Upgdb111.cmd directly on the machine where the database resides, this file
should already be present. It is also available on the Project Server CD in
the \support\database folder.
d.. Run Upgdb111.cmd against the Project Server database. If the database
is a partitioned database, run the script against each of the Project Server
databases. Run Upgdb111.cmd from a command line with the following
parameters. To run from a command line, click Start > Run and type cmd in
the dialog box and click OK.

Upgdb111.cmd <sql server name> <database name> <login> <password>

OR if using Windows authentication to SQL Server as the currently logged
in user:

Upgdb111.cmd <sql server name> <database name>

Note: By leaving off the system administrator account login and password,
the command file will assume Windows authentication to SQL Server. If you
supply only the SQL Server name, it is assumed the database name is
ProjectServer.
The SQL file is located at:
http://www.microsoft.com/downloads/...f17-ab08-7c9b790c5b15&DisplayLang=en#filelist

Are you getting any spooler errors when you publish a project plan?