The Sage 50 Database Repair Utility Tool is an online extension offered by Sage Inc. to repair any issues related to data files or data paths while using the Sage 50 application. Common issues with the Sage application, like Corrupt Data Files or improper data paths, can be resolved using the Database Repair utility tool. While it is easy to resolve these issues through Database Utility, users sometimes face issues while using the Repair Utility application or even have no idea how to download it. Therefore, in this article, we have listed all the crucial information regarding Database Repair Utility.

Through this, you can download the Repair Utility, fix common Sage Data Files-related errors, and utilize the accounting application at its optimum to automate your work. Read the given blog post to learn how to download the Sage Database Repair Utility tool.

For US Helpline Number: +1-866-430-0630

What type of Error is Sage Application Can be fixed by Sage 50 Database Repair Utility Tool

As the name suggests, the Repair Utility Tools is available to fix common errors related to Sage files or repair any issues occurring in the data network path. Users can use that to check whether the current they are facing in their Sage Application has been caused by the following causes or not:

  • Any issues or damaged files present in the Pervasive Database Engine (now known as Actian Zen).
  • Presence of any outdated or corrupted files in the Data Path of Sage Application.
  • Any other issues related to Data Path across the network.

How do you download the Sage 50 Database Repair Utility Tool?

Users can easily access the Repair Utility Tool from the official website of Sage. The link for which to download can be located either on the official homepage or the Sage Knowledge Base. Also, the Database Repair Utility Tool can be downloaded from the official Sage Application steps for which are listed below:

Sage 50 Database Repair Utility Download

  • Open the Sage 50 Applications in your system.
  • On the homepage of the accounting application, click Sage 50 resources and then hit the option “Help.”
  • From the drop-down, select “Technical Support Utilities.”
  • Select the Sage 50 Database Repair Utility Tool which will start the downloading process.

Once the Sage Database Repair tool has been downloaded, a window will appear on the screen. Hit the option “Install” to start the installation, which will extract the necessary files for the tool to function. Another window will pop up concerning the user that using this tool might stop the Sage 50 application from working. Hit “Yes” and then “Agree” to the license agreement.

Fix Common Data-Related Errors Through the Sage Database Repair Utility Tool.

Once you have installed the Sage 50 Database Repair Utility Tool, you have the option to perform the following three actions through the tool:

Sage 50 Database Repair Utility Remove, Install or Create New

  • Remove Actian or Pervasive Database.
  • Install the Pervasive Database or Actian
  • Create a new local data path.
Remove the Pervasive Database or Actian

The Pervasive Database or Actian is the most important component of the Sage 50 application, which is important to run or execute its file. Any issue or technical glitches in this Database can lead to malfunctioning in the Sage application. Therefore, it is important to fix the Pervasive Database in order to fix any issues related to it. Through Sage Database Repair Utility Tool, it can be removed, deleted, and then reinstalled.

Once the Sage Database Repair Utility has been installed, it shows three options. Select the one to uninstall the Actian.

Install the Actian/Pervasive Database

Sage 50 Database Repair Utility Install

Once the Pervasive has been uninstalled, you need to reinstall it through the Database Repair Utility Tool. The tool will install the database along with various other updates. Installing the Database through the repair utility is very simple and easy with just one simple click. While doing this function, users need to make sure that they have closed all other applications along with Sage 50.

Once the installation has been completed, you can restart the Sage application. However, if it fails more than once, then there are chances of the occurrence of Error 1402.

Create a Local Data Path through the Sage Database Repair Utility Tool

A major error that can be fixed through the Sage 50 Repair Utility tools is the Sage Data Files error. A major way to fix it is through the Sage Database Repair Utility Tool by creating a new data path. Following is the stepwise process to create a new data path.

Create New Local Path

  • Open the Repair Utility Tool and then select the option “Create New Local Data Path.”
  • A pop-up window will appear on the screen titled “New Datapath Options.” Fill out the option for “New Data Path”. Browse the location for the new data path. Make sure the location is totally new and does not exist on the PC previously.
  • Now, in the section “Company to Copy,” browse the previous data path whose company you have to copy to the new data path. The process might take a bit longer time.
  • Afterwards, you need to hit the option “Manage INI Files” below. There, select the original data path and hit the option “Make Active.”
  • The location of the company data files is also crucial to determine while making future updates in the system.

How to Access the Sage 50 Database Repair Utility Tool

Users can easily access the Sage Database Repair Utility Tool either from the Start Menu or in the Sage 50 accounting from the Help option available in the homepage of the application.

Other Issues that can be easily be fixed by the Sage Database Repair Utility tool

While the Database repair utility is required when you need to remove and install the Pervasive Database, user can utilize this to fix a variety of issues, some of which are listed below:

Error Generates by the General Ledger

The General Ledger is the major component of accounting and business software. Through General Ledger, users generate various financial reports like Balance Sheets and Profit and Loss statements. It is common that general ledger reports generate errors that are somewhat difficult to handle. Although this error can be fixed through data verification, sometimes, that is also not effective. Therefore, using the Repair Utility Tool can be helpful in removing complicated errors that data verification cannot remove.

Changing Accounting Period

Accounting Period refers to the time span which can be a frame of reference for financial reporting. It can be usually 12 months or based on the preference of the user. Accounting application offers the amenity of changing the accounting period based on which user can generate a financial report based on their requirements. Methods to change the accounting period in Sage 50 application has been listed below:

  • Open the Sage Application and Navigate to the Task Menu. Hit the option “System” and then “Change Accounting Period.”
  • From the drop-down list, select the accounting period and then Hit OK.

Another way to change the accounting period is from the Button Control Bar. However, if users are unable to locate the option “Change Accounting Period”, then they do not have security access to this option.

While the above method is easy and simple to change the accounting period in Sage 50, the Repair Utility Tool can be used to resolve this, by fixing Data Issues which are a major cause for this accounting error.

Use Data Repair when Sage 50 Accounting Data is missing.

Missing or corrupt company files or any other important data is related to the malfunctioning of the Actian/Pervasive Database. The only resolution to fix it is through uninstalling and reinstalling the Database, for which the Repair Utility Tool is the major option.

Data Scrubbing and Data Purging
  • The majority of the Data-related errors occur due to the presence of Duplicate Files, Old Data Sets and any other unnecessary unrelated data errors.
  • The process of Data Scrubbing involves removing only specific files, which totally avoids the issues of Data loss.
  • Another method is Data Purging, which removes the data files from the system, but the major intent is to create space for new files to be added.
  • Although both techniques are effective, sometimes fixing one error can have consequences leading to triggering other errors. Therefore it is recommended to use the Database Repair Utility Tool instead of opting to data cleansing techniques.
Other Common Issues which can be fixed by the Sage Database Repair Utility tool
  • Fix various components of the Sage application.
  • Local Operating System Environment.
  • Network Connectivity Issues while working with the Sage Application.
Create a Backup of your Data before using the Sage Repair Utility Tool.

It is advisable for the users to create a backup of their data before using the repair tool. Following is the step-wise representation to create a backup of the Sage Data Files:

Create a Backup

  1. Open the Window Explorer in your system and navigate the location of the DMS Database, which is:
    • C:\Program Files (x86)\Intuit\DMS
  2. There, copy the Sage files (with the extension  .idx, .dat, and .lck ) and paste them into a new folder on the desktop.

Connect with Sage Online Solutions

While running the Database Repair Utility is easy and simple, sometimes users face difficulties, which might be due to the presence of any other error in the system. In that case, you can connect with Sage Online Solutions, where the customer support experts are available 24/7 through different means. Common ways to connect with us are listed below:

  • Sage Solution Helpline Number: This is the most preferred way through which users can interact directly with the expert and convey their issues more elaboratively. The helpline number of +1(866)430-0630, which you can dial and, within a few seconds, connect with customer support.
  • Live Chat: The chat support option can be accessed from every page of Sage Online Solution. On the right side of the page, navigate the green-coloured option “Help” and click on it. Provide your basic contact details like email ID and phone number, and fill out the message box with the issue you are having. Within a small fraction of time, a solution will appear on the screen, which you can follow to fix the Error in the Sage application.
  • Email: This can be considered as the last option due to delayed revert; the mailing option can be utilized in case users do not have much time to engage with us. Just send a mail along with your query to which you will be sent a precise solution for your issue.

Wrapping it Up

The Database Repair Utility Tool is an excellent amenity offered by Sage Enterprise to fix any data-related error. The tools is really helpful to fix complicated errors that are related to the Database as it work from the core. While simple options can be available, like installing/uninstalling Actian and creating a new data path, a variety of errors can be fixed with these simple processes. You can easily download the tool from the official website of Sage or go to the help menu on the application’s homepage and download it.  For any further issues related to Sage 50 Accounting, connect with us.

For US Helpline Number: +1-866-430-0630

Frequently Ask Questions (FAQs)

The Repair Utility is an extension of the Sage Application that offers a solution to fix various data-related errors in the accounting application. The common method used by the database repair application includes Removing and Installing Pervasive and Creating a new data path.

You need to download the Repair Utility Tool, after which it will list the three options:

  • Remove Pervasive
  • Install Pervasive
  • Create a New Data Path.

Select the option based on your issues, after which it will automatically start working.

The pervasive is a Database Management System, which is a core component of the Sage Application. Any data-related error in the Sage Application might be linked to the Pervasive Database.

Following are some of the common issues that can be fixed by the Database Repair Utility Tool:

  • File Access Issues
  • General Ledger Report-related errors.
  • Data Purging and Data Scrubbing.

Users need to remove/delete the Sage 50 application in their system and then reinstall it, during which they can select the new data file location.

Any kind of error, which includes the data file component in the accounting application, can be fixed by the Sage Repair Utility Tool. All users need to do is set up the Pervasive database.

Other error user faces apart from Data path file issues are:

  • Sage Cloud Error 3111 due to loss of internet connectivity
  • Sage Error 1603 due to virus infection, making the application crash continuously.
  • Error Code 1935 in Sage application indicating incomplete installation.
  • Application Error Code 30 due to printer inactivation.

Users can easily see the Data Path in their Workstation computer for Sage 50 through their program files. Here is a stepwise representation of that:

  1. First of all, note down the location of the new data path in a notepad from where you can fetch the location details whenever required.
  2. Now, browse the given location in your system:
    • C:\Program File\Common Files\Peach\Program Files (x86)\Common Files\Peach
  3. There, open the configuration files.
  4. Now, search for the term “DATAPATH=” where you need to paste noted down new data location.
  5. Save the changes and close the file explorer.
  6. Now, open Sage and check whether the Sage application can access the file from the given location or not.