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.
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.