Project Center grid disappears/reappears

M

Melanie

This issue is intermittent so it is very difficult to track:

Sometimes (5x a day) when attempting to open project center we get the:
Project Center cannot access the project (s) you are trying to view. It is
most likely that either you don't have permissions to view the project,
another user has deleted this project before you were able to view it or that
another user is in the process of publishing the project.

So we cannot see any projects in project center.

It was suggested that we run the sp 'sp_updatestats against the MSP_TASKS.
The stored procedure will not run and gives the error: SQL Execution Error
Executed SQL statement: sp_updatestats
Error Source: .net SqlClient Data Provider
Error Message: Timeout expired. The timeout period elapsed prior to the
completion of the operation or the server is not responding.

There are 46,000+ tasks in this table.

Thank-you for your assistance in advance.
 
P

Paul Conroy

Make sure you're using 64bit SQL and Project Server(2007 only)
Project Server Database should have their own LUN (15k drives)
Project Server should have it's own SQL Server (not shared with other apps)
TempDB should have a file for each logical/virtual CPU
SQL Indexes should be rebuilt regularly and statistics updated
Be mindful of other Operations (transactions will be slower if the cube is
building, indexes are rebuilding, other long queries are being run)
Performance will also be affected if you have a deep nested RBS and you're
user account is at the top of the tree and you're using dynamic category
permissions.
Make sure you have the latest Service Packs/Updates as these contain many
perofrmance optimisers.
--
Please rate this post if it has helped

http://www.fundraiseonline.co.nz/TheProjectServerGuru/

http://theprojectserverguru.spaces.live.com
 
M

Melanie

Not using 64 bit, only have 32 bit.
The drives are good.
The SQL server is dedicated (not shared with other apps)
SQL Indexes and statistics are updates automatically (set to true)
Cube only builds at night, like 1 am or so.
All OS service packs and updates are on the server.
SQL Server 2005 is updates with SP2.

I don't quite understand what you are saying here:
Performance will also be affected if you have a deep nested RBS and you're
user account is at the top of the tree and you're using dynamic category
permissions.

Thanks so much Paul for attempting to resolve.
 
M

Melanie

Project Server 2007 with SP1
SQL 2005 SP2 and hotfix 3228
About 500 projects
About 46,000 tasks
 
M

Melanie

I would like to upgrade to 64 bit but that is beyond my control.

4096 mb ram
2 Dedicated SQL servers - 1 for reporting the other for archive published
draft

RBS as Microsoft recommends

Category Rule Description
Projects
Allow users in this category to view all projects managed by resources that
they manage
If a project is managed by a resource that has an RBS code that is below
the category member in the RBS hierarchy, then the category member is able to
view the project in the Project Center site in Project Web Access.

Projects
Allow users in this category to view all projects assigned to resources
that they manage
If a task in a project is assigned to a resource that has an RBS code that
is below the category member in the RBS hierarchy, then the category member
is able to view the project in the Project Center site.

Resources
Allow users in this category to view information for all resources that
they manage
If a resource has an RBS code assigned to it that is below the category
member in the RBS hierarchy, then the category member is able to view the
resource information.

Resources
Allow users in this category to view information for all resources in
projects that they manage
If a project manager creates a project that includes ten resources, then
that project manager is able to view the information for those ten resources.

Models
Allow users in this category to view models created by resources that they
manage
If a model was created by a resource that has an RBS code that is below (in
the same branch of the RBS tree) the user requesting access to the model,
then the user is able to view the model.
 
P

Paul Conroy

Your servers clearly are not handling the performance requirements of the
application.

You really need to monitor the performance of each of these servers
(especially the SQL servers). There are some pointers on my blog site. This
should help you put a business case together for upgrading the hardware if
required.

How much RAM is in your application server(s)?

--
Please rate this post if it has helped

http://www.fundraiseonline.co.nz/TheProjectServerGuru/

http://theprojectserverguru.spaces.live.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top