Cannot open projects from project server

[Ole Lauridsen]

After a check out problem with a project, I applied the following on all
projects in the table:

Update MSP_PROJECTS
Set PROJ_READ_ONLY = '0',
PROJ_READ_WRITE = '0',
PROJ_READ_COUNT = '0',
PROJ_LOCKED = '0',
PROJ_MACHINE_ID = null,
PROJ_EXT_EDITED = '1'

From MS knowledgebase article KB302937.

After this all projects seems locked, an a new check-out error message
appears in MS Project Professionel. The projects cannot be opened because the
are already checked-out, I am not even given the option af opening the
projects as read-only.

I can read the projects in PWA an everything looks good in PWA.

How do I open up for editing the projects with MS Project Professionale?

Thank you
Ole

 

[Dale Howard [MVP]]

Ole --

Have you tried the steps referenced in the following FAQ:

http://www.projectserverexperts.com/Shared Documents/checkinprojectsandresources.htm

Hope this helps.

 

[Ole Lauridsen]

Yes. In PWA there are no checked out projects, and in the database table
MSP_PROJECTS the fields:
PROJ_READ_ONLY
PROJ_READ_WRITE
PROJ_READ_COUNT
PROJ_LOCKED
PROJ_CHECKEDOUT
are all '0'

anyway I get a message from project that the project is already checked out.
Maybe the problem is on a database level rather than a record level as the
message appears for all project. I am also begining to have problems
publishing new projects.

Thank you
Ole

 

[Gary L. Chefetz [MVP]]

Ole:

All projects? Even the Enterprise Global? If so, this may explain your
troubles. Your query should have excluded this project type. For the global
file, set the following values:

Set PROJ_READ_ONLY = '1',
PROJ_READ_WRITE = '1',
PROJ_READ_COUNT = '1',
PROJ_LOCKED = '0',
PROJ_EXT_EDITED = '0'

And-- PROJ_CHECKEDOUT = '1'

I can't find the KB article you're citing, so I can't figure out why you're
setting the Ext_Edited field to '1' - This will cause the system to rebuild
the binary record for the file the next time you open them, which will not
cause any harm, except for an extra long open process, particularly on
large projects, the next time you open them.

 

[Ole Lauridsen]

Thank you very much. That explains it.

For your information the knowledgebase article ID is: 302937 and has the
title:

Message states the file is locked or in use when you try to open a project
in Project

Thank you,
Ole