There are various versions of Project Professionals (Client side) and Project Servers (Server side) available in the market. Among them, Microsoft Project Server versions, 2010 and 2007 as well as Project Professional 2010, 20007 are the recent ones. As these days, Project Professional 2007 and 2010 are the widely used versions, we focus this discussion on them only.
When you try to save your enterprise projects on to the project server database, project professional 2007 or 2010 stores a copy of the project on your systems hard drive. The Project Professional application stores the copy at a location, 'Local Cache' and from this copy only spools the project content on to the Project Server database.
In various occasions, the Local Cache containing all your vital project information gets corrupted and the same is spooled into the Project Server database. Below are some of the prominent symptoms of Local Cache corruption:
The values in the Custom enterprise Project field appear to be 'scrambled', when viewed at the Project Information dialog.
The project cannot be opened normally and appears to be 'stuck' in a 'Checked Out' state in the Local Cache. However, the same is not actually checked out in your Project Server database.
Such corruptions have a long term impact and your Project Server database can become corrupt someday. Below is the suggested resolution that may help you resolve the issue:Steps to resolve issues in Project Server 2007 and 2010
Check in the open projects and exit Project Professional 2007/2010. Close all the other running applications.
Go to Start > Run. In case of Project Server 2007, enter the command, '%appdata%\Microsoft\MS Project\12\Cache’ and in case of Project Server 2010, type in the command, '%appdata%\Microsoft\MS Project\14\Cache' in the Run dialog box.
Delete all the files and folders present in this directory.
Run Project Professional 2007/2010 and establish the connection to the Project Server again.
Go to the menu bar and click File > Open.
From the 'Open' dialog box, double-click the option, 'Retrieve the list of all projects from Project Server' and reopen your projects.
However, if your Project Server database has already been corrupted, you need to take the help of Stellar Phoenix Project Server Recovery software
to repair the corrupt database and recover your precious data successfully.