Note: For most files, you should use the Rebuild Key Files utility. The *UFAR utility is reserved for instances where the regular rebuild process does not resolve the error or is not recovering records, due to more severe file and data corruption.

Warning: The *UFAR process does not print a list of records that are stripped from the file. It will not be possible to determine what records were lost. UFAR is not generally recommended. Another alternative may be to restore the file from backup or replace with a new file. You can also run the *UFAC utility on a file beforehand to get a list of potentially bad records. (For more information on *UFAC and Rebuild Key Files, see the Related Resources section below.)

1. Make a backup of the file to be repaired.
   (Suggestion: Copy the corrupted file into the root of the C:\ drive, then use this file to run the utility on. Once the process is complete, place it the file back by renaming the original file first, then pasting the new one in its place.)
2. Run the *UFAR utility (either of two methods):
   1. Via Windows Explorer, navigate to the "..\MAS90\HOME" directory where Sage 100 ERP is installed
   2. Right-click the Pvxwin32.exe file
   3. Select "Run as Administrator"
   4. Click OK at the ProvideX:Initialization
   5. In the ProvideX window, enter the following command at the prompt and press the Enter key:
      RUN "*UFAR"
3. Enter the name of the file to be repaired at the 'Name of Keyed/Direct file' field, with the full path to that file and press the Enter key.
   (Example: If you followed the suggestion in Step 1, and corrupted file was GL_DetailPosting.m4t, then the path would be C:\GL_DetailPosting.m4t)
4. The next screen prompts for the name of the backup file (e.g. GL_DetailPosting.B00). Make a note of 'Current # records'. Accept the default and press Enter.
5. The next screen prompts for 'Recover to Highest Active Index or Physical End of Record'. 'Active Index' is usually the correct choice. Press Enter.
6. On the next prompt, "'Is this correct for ALL records in this file?", select 'D - Wrong' and press Enter.
   • Note: D = 'Keys contain only printable characters'
   • Note: The letter options and what they describe may vary.
     • Example: Option D doesn't exist and you have to select "E - Wrong" because E = 'Keys contain only printable characters'
7. You will get the same prompt from Step 8 again without the D selection. Select 'E - Wrong' and press 'Enter'. Note: E = 'Data contains only printable characters'
8. The same screen repeats without 'D' or 'E'. Select 'Yes'.
9. UFAR will then repair the file. The next screen reads "Recovered nnn records. Clear and reload original file?". Compare the number of records recovered with 'Current number of records' noted earlier. Select 'Yes'.
10. Verify that a backup has been made in step 1. Then reply 'Yes' to 'File xxxxxx has been repaired successfully, Erase temporary file xxxxx.b00?'.
11. Type 'BYE' at the PVX ( > ) prompt to return to the 'Command' prompt.
12. If you followed the suggestion on step #1, replace this new file from the C:\ drive to its original location. Make sure to rename the original file (e.g. GL_DetailPosting.old), then place the new one in its place.

Note: It is highly recommended to make another backup after completion of the *UFAR utility on a data file. Then, if it is a Key file, run the Rebuild Key Files utility on that file.