You are currently reviewing an older revision of this page.
“The GUID in the project database doesn’t correspond to GUID for this project in the ect.fid file” appears as a tooltip when the mouse pointer is hovered over a project in the folder tree in Project Manager. The icon for the project folder has a red-circle slash symbol on it, and no project pages are listed.
Project folders are correlated to the project database by an alphanumeric string, referred to as the "guid". The message indicates that the guid value found in the ect.fid file does not match the value found in the "guid" column of the record for the project in the "Project" table.
"The software" and "the application" in the steps below refer to the Bentley application affected, either promis•e or Bentley Substation.
If not already installed, install SQL Server Management Studio (SSMS). If SSMS is installed it should appear in Start > All Programs > Microsoft SQL Server 200x. SSMS can usually be downloaded as a standalone item or installed from the SQL Server installation file.
Run SSMS. A “Connect to server” dialog will appear. Enter or browse for the server name. It should appear as it does in the Setup dialog.
After connecting to the SQL Server, expand the Databases folder in the Object Explorer on the left.
Expand the database used by the software (see the Setup dialog to determine the proper database).
Expand the Tables folder.
Right click on the dbo.Project table and select "Open Table" or "Select Top 1000 Rows" as the case may be.
In the Project table, examine the project names found in the “name” column and see if any of the inaccessible projects are listed. If you find an inaccessible project listed verify you have the right record (row in the table) by checking the value in the “prjpath” column for the project. Do not make any changes to this table. If you cannot find the inaccessible projects in the Project table, they may be in a different database or you may need to change the query to increase the number of rows returned.
If it seems you have found the correct record (row) for an inaccessible project, use Windows Explorer and go to the path specified in the “prjpath” field for that row. If this path is different than the path that Project Manager is focused on, and a project folder exists in both paths, this may explain the problem. Project folders should not be copied using Windows Explorer, only moved. The solution may be to delete the non-working folder and point Project Manager to the working folder. If the path specified in prjpath matches the path to the problem project in Project Manager, continue with the following steps.
Make a backup copy of the ect.fid file found in the project's folder.
Open the ect.fid file in a text editor such as Notepad. The first line in that file should match the value in the “id” column for the project in the Project table.
The seventh line in the ect.fid file should match the value in the "guid" column for the project's record in the database, but it probably will not, which is why the project is inaccessible. If it does not match, copy the guid value from the Project table for that project and paste it into the ect.fid file, overwriting the seventh line.
Save the ect.fid file.
Restart the Bentley application. The project should now be accessible.
If the project becomes accessible, repeat steps 7 – 12 for the remaining inaccessible projects.
When promis•e and Bentley Substation projects are stored in a ProjectWise datasource, the guid value is also stored in a third location. In addition to the ect.fid file and the "guid" column of the "Project" table, the guid is stored in the "ect_fid" ProjectWise project property for the project.
As of the 08.11.12 versions of promis•e and Bentley Substation, the guid value in all three locations must match or else the project will be inaccessible. The guid value in the ProjectWise project property may become mismatched when the user first accessing the project after an upgrade does not have permissions to change ProjectWise project attributes.
SELECTsupport TechNotes and FAQs