S
Sam
I am currently in the process of upgraded our systems from PS 2003 to PS 2007
and in a test environment I transferred over 1800 projects from the PS 2003
database to the PS 2007 published database. Everything seems to be working
fine except for Project Center which would only display the following message:
"Project Center cannot access the project(s) you are trying to view. It is
most likely that you either don't have permissions to view the project,
another user has deleted this project(s) before you were able to view it or
that another user is in the process of publishing the project."
After checking many settings I found that the Project Server was generating
this response after 29.9998 sec. making me think that it was timing out due
to the amount of projects. When I deleted the projects and only transferred
250 of them Project Center started working and the projects could be seen.
As I started transferring over more projects I found that Project Center
stopped working when I loaded over 750 projects on the published database.
While many of the 1800 we have in PS 2003 projects would be moved to the
archived database and not need to be loaded by Project Center we have on
average 500-600 projects that we are actively working on and this maximum
project limit has me greatly concerned. Adding filters to the view or
filtering projects through security settings doesn't seem to affect the
problem.
Is there an easy way to adjust this timeout setting for Project Center or
change its query so that it is pulling from an indexed database instead of
running dynamic queries every time the Project Center web part is refreshed?
Any ideas on why this change was made from PS 2003?
Thanks,
Sam
and in a test environment I transferred over 1800 projects from the PS 2003
database to the PS 2007 published database. Everything seems to be working
fine except for Project Center which would only display the following message:
"Project Center cannot access the project(s) you are trying to view. It is
most likely that you either don't have permissions to view the project,
another user has deleted this project(s) before you were able to view it or
that another user is in the process of publishing the project."
After checking many settings I found that the Project Server was generating
this response after 29.9998 sec. making me think that it was timing out due
to the amount of projects. When I deleted the projects and only transferred
250 of them Project Center started working and the projects could be seen.
As I started transferring over more projects I found that Project Center
stopped working when I loaded over 750 projects on the published database.
While many of the 1800 we have in PS 2003 projects would be moved to the
archived database and not need to be loaded by Project Center we have on
average 500-600 projects that we are actively working on and this maximum
project limit has me greatly concerned. Adding filters to the view or
filtering projects through security settings doesn't seem to affect the
problem.
Is there an easy way to adjust this timeout setting for Project Center or
change its query so that it is pulling from an indexed database instead of
running dynamic queries every time the Project Center web part is refreshed?
Any ideas on why this change was made from PS 2003?
Thanks,
Sam