Created On:  19 November 2010

Problem:

Working folders with invalid network paths can cause performance problems. If network paths are used for working folders, it may be beneficial to review them periodically to remove paths which are no longer valid.

Resolution:

To obtain a list of folders with network working paths, execute the following SQL query against the StarTeam database:

SQL Server:
Select syn_project.Name as 'Project', syn_view.Name as 'View', syn_Folder.Name as 'Folder', syn_folder.workingfolder as 'Working Folder'
FROM syn_folder
JOIN syn_view
ON syn_view.ID=syn_folder.ViewID
JOIN syn_project
ON syn_view.ProjectID=syn_project.ID
WHERE syn_folder.workingfolder LIKE '%\\%'
Oracle:
Select syn_project.Name as Project, syn_view.Name as View, syn_Folder.Name as Folder, syn_folder.workingfolder as WorkingFolder
FROM syn_folder
JOIN syn_view
ON syn_view.ID=syn_folder.ViewID
JOIN syn_project
ON syn_view.ProjectID=syn_project.ID
WHERE syn_folder.workingfolder LIKE '%\\%'
This will return a list of working folders with network paths, and their respective projects and views:



Review the list shown and for each folder with an invalid working folder:

1. Browse to the corresponding project and view in StarTeam
2. Right click the folder and click properties
3. Edit the working folder entry to a valid local or network path (local will yield greater performance)
4. Click Apply
5. Click OK
Incident #2481937