• File Doctor (FD) is not fixing a missing gateway file.
• File Dr is attempting to create the missing gateway file to an incorrect directory path.
• File doctor is duplicating the company data folder path for specific files.
• Example error message on the File Doctor journal:

"Checking C:\PROGRAMDATA\SAGE\TIMBERLINE OFFICE\DATA\PM SAMPLE DATA\C:\PROGRAMDATA\SAGE\TIMBERLINE OFFICE\DATA\PM SAMPLE DATA\RECUR.GLR of Gold Coast Group
Versions: File Unknown, GLR.DCT 17.1.6, GL DLL 17.1.6, GLR Min Data 17.1.0, TS DLL 17.1.6
Potential problems discovered during file integrity check:

All data files are missing for C:\PROGRAMDATA\SAGE\TIMBERLINE OFFICE\DATA\PM SAMPLE
DATA\C:\PROGRAMDATA\SAGE\TIMBERLINE OFFICE\DATA\PM SAMPLE DATA\RECUR.GLR
Deleting C:\PROGRAMDATA\SAGE\TIMBERLINE OFFICE\DATA\PM SAMPLE DATA\C:\PROGRAMDATA\SAGE\TIMBERLINE OFFICE\DATA\PM SAMPLE DATA\RECUR.GLR
C:\PROGRAMDATA\SAGE\TIMBERLINE OFFICE\DATA\PM SAMPLE DATA\C:\PROGRAMDATA\SAGE\TIMBERLINE OFFICE\DATA\PM SAMPLE DATA\RECUR.GLR deleted"

Ask Name is selected for the file type in File Locations (File, Company Settings, File Locations)

When Ask Name (or named files) is selected for a file type that is missing its gateway file, File Doctor attempts to recreate the missing gateway file but it is building the file path by copying the company data folder path twice incorrectly.

For example, if the company data folder is \\server\PROGRAMDATA\SAGE\TIMBERLINE OFFICE\DATA\COMPANY DATA\, it will attempt to create the file to an incorrect location of \\server\PROGRAMDATA\SAGE\TIMBERLINE OFFICE\DATA\COMPANY DATA\\\server\PROGRAMDATA\SAGE\TIMBERLINE OFFICE\DATA\COMPANY DATA\.

Once it creates the missing gateway file to this location, it then detects that there is no related data files in that location, so then it deletes the gateway file it had just created.

The end result is that the related data file folder inside the PVData folder still has no gateway file.

Additional Information

Most of these cases are happening on GL Recur files (.glr), PR new files (.prt), and AP new files (.api) where named files are most commonly used, though it can happen with any file type that has Ask Name selected.

Users are likely attempting to delete the file when they are no longer using the file, but they are deleting the gateway file only. This will happen if it is deleted through Windows Explorer/File Explorer or within a browsing window instead of using File Tools to delete it. They are most likely doing this in the browsing window where they are prompted to select the file or enter the file name they want to use for the task.

This is fixed in version 24.1 of Sage 300 Construction and Real Estate.

As a workaround for versions prior to 24.1, manually create the missing gateway file then run File Doctor. Contact Sage 300 Construction and Real Estate Support for assistance with this workaround.