Using the Sage 50 Database Repair Utility

Caution: If you are trying to create a new data path refer to How to create a new data path with the Database Repair Utility first.  
   
This is a step by step tutorial on how to use the Sage 50 Database Repair Utility. The Sage 50 Database Repair Utility gives users the ability to quickly determine whether or not an issue a customer is experiencing is caused by the following:  

• A damaged or improperly patched instance of the Pervasive Database Engine
• Missing, damaged, and/or outdated files in the data path
• Issues connecting to the data path across the network

   
 

Starting with R2020, the Pervasive component has been renamed to be Actian Zen. In R2020 and higher versions of the Database Repair Utility (DBRU), the Install and Remove options refer to Actian Zen; the instructions below are still valid for Actian Zen. Treat "Pervasive" and "Actian Zen" or just "Actian" as synonyms.

Start the Tool

1. When the tool is started, all of the files necessary for the tool to function will be extracted.
   
   
2. In the following message you can select the link to view a Sage Knowledgebase article if you want to find out more about this tool.
   
   
3. Read the End User License Agreement - click Agree if you agree to all terms and conditions to start using the tool.
   
   
4. You have three available options within the tool:
   • Remove Actian, see Section 1 below
   • Install Actian, see Section 2 below
   • Create New Local Data path, see Section 3 below
   

SECTION 1: Remove Actian

The Remove Actian Zen utility will uninstall Pervasive from the local computer. This utility is usually used in conjunction with the Install Actian Zen utility. It is important to ensure that all users have logged out and closed Sage 50 before using this utility - upon starting this utility; a message will provide a reminder:

Note: The initial attempt to uninstall Actian will usually fail. This is normal and is caused by Actian being started during the uninstall process. Just run the process again to successfully uninstall Actian.


SECTION 2: Install Actian

The Install Actian utility will install Pervasive to the local computer and automatically patch it with necessary updates. This utility is usually used in conjunction with the Remove Actian Zen utility. It is important to ensure that all users have logged out and closed Sage 50 before using this utility - upon starting this utility; a message will provide a reminder:



Note: If the install process fails more than twice, there is a high probability that there is a registry issue and you are getting Error 1402 - follow Error: "1402.Could not open key: UNKNOWN\CLSID\.....". The tool suppresses this error.

SECTION 3: Create New Local Data path

The Create New Local Data path utility generates a new Sage 50 data path directory with factory-default files. This provides a clean set of files for Sage 50 to work with to troubleshoot issues with the existing data path. You can also copy a Sage 50 company into the new data path directory to test an existing company with the new data path.

Note: The Create New Local Data path utility is an advanced option, so we recommend that you only use it with the guidance of Sage 50 Customer Support.

1. Verify the location of the new data path, It should be in a location that previously did not exist on the PC.
   
   
2. Company to Copy feature will move the entire directory from the previous data path to the newly created data path. If the copy feature fails, it is due to SmartPosting and / or Pervasive running on the PC. You may need to manually stop these services by going to Services.msc.
   
   Note: When copying a company to the new data path it will copy the entire directory, including backups, attachments, etc. This process could take a long time depending on the size of the directory and the speed of the computers / network doing the file transfer.
3. Manage INI Files allows you to revert back to the initial data path. Select the original data path and select Make Active. Then Close out of the Database Repair Tool.
   
   

If the newly created data path is working and you desire to use it permanently moving forward, you will also need to complete the following steps to ensure future updates will function correctly:

1. Navigate to the following registry key (replace with 28 for 2021, 27 for 2020, etc.).
2. 64-bit machine - HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Peachtree\Version\ \Online Update.
3. 32-bit machine - HKEY_LOCAL_MACHINE\SOFTWARE\Peachtree\Version\ \Online Update.
4. Update the String Values for "Path" and "UpdatePath" to match the new data path that you have chosen above.
5. Reinstall the latest Sage 50 Service Release. How to manually download updates.

Chat with support