unable to find specified project

[Chris]

Hi --

Having a problem with Project Server 2003 (latest SP and all updates). Some
projects, when trying to open them through Project Client OR PWA give the
error "Project Server was unable to find the specified project". I can view
the project information in PWA, users can add time, etc... This is happening
on about a dozen or so out of 2000 projects.

I can also see the project information sitting in the SQL tables... odd.

Has anyone come across this before or have any troubleshooting suggestions?

Anything offered would be appreciated!

Thanks

 

[Gary L. Chefetz]

Chris:

Sounds like it could be a timeout issue. I'm curious whehter you are
routinely updating statistics and reindexing the databases as part of your
maintenance plan? It could be something as simple as this that is causing
the problem. It would help if you harvested the application event logs when
this happens.You might even need to do a SQL profiler session to trap the
exact issue.

--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting: http://www.msprojectexperts.com
Project Server Training: http://www.projectservertraining.com
Project Server FAQS: http://www.projectserverexperts.com
Project Server Help Blog: http://www.projectserverhelp.com

 

[Chris]

I checked with our DBA - turns out the DB has never been re-indexed. A few
months back we ran a series of macros on all projects to update some fields
and and some stuff - that's when we noticed the problem.

So we reindexed last night, but that didn't seem to resolve anything. I'm
not sure of it being a timeout issue since it's specific projects that have
'disappeared' and the error happens every time you attempt to open them.
Nothing unusual in the event logs on the Project or SQL servers.

With the SQL Profiler suggestion, would we run that and then try to open the
problem projects?

Thanks for your help... I'll keep hacking away at it. Any other suggestions
you may have will also be appreciated!!!

- C

 

[Chak]

Hi Chris,

Please let me know, which of the following scenario holds for you?

Are you trying to open the project plan from PWA? I mean selecting
project name from Project Center and clicking Open link?

(OR)

You may be having external dependencies in project plan and you are
getting the project not found message when you are trying to open
project plan.

In either of the above case, this issue may be related to rename
process.

Have you renamed any of those projects earlier? If rename process not
went correctly, project processional will not find the project to
open. Project Pro will use ODBC link for each project to open the MPP
from Project Server. It seems to be link may not be correct for all
those projects.

Part of the ODBC link will contain the project name (Example: <>
\xyz.published).
During the renaming process, if ODBC link not updated with new name
and still contains the old name, in this case MS Project Professional
will not find the project to open.

Try to rename the one of the project and publish the project by
choosing entire information option. If this works, please do the same
for all the projects.

Also look under MSP_PROJECTS table to find out the link associated
with those projects.

SQL Query:

SELECT PROJ_ID, PROJ_NAME, PROJ_PROJECT
FROM MSP_PROJECTS
ORDER BY PROJ_NAME

Example: If project name is xyz.mpp, you will see the PROJ_PROJECT
values as <>\xyz.published

This was my guess; I am not sure what exactly going with you. Please
could you explain in detail?


Thanks
Chak
http://www.epmcentral.com