Sage 50 2024 Backup Failure When Using Remote Data Access (RDA)

Sage 50 utilizes Remote Data Access (RDA) to enable users to access accounting data from anywhere. Typically, the RDA feature is compatible with any internet-enabled device. Hence, any issues with this feature impact real-time data sharing and adversely impact business workflow.

The issue “The Company backup failed to upload to Remote Data Access” is one such error. It arises when Sage 50 Accounts fails to take a backup while using the RDA feature. Typically, this issue occurs because of file corruption, internet problems, inadequate user permissions, etc.

In this guide, complete information about the Sage 50 2024 backup failure issue has been shared. This guide lists the causes along with simple and easy-to-follow solutions to resolve this issue.

What is Sage 50 Remote Data Access?

Sage 50 Remote Data Access enables users to access the company data from various locations. It links users with the same file and facilitates real-time teamwork.

Furthermore, this feature assists businesses with remote teams in minimizing regular travel requirements. It connects devices via the internet. Every modification upgrades the data for the users. This setup provides reliable, real-time access to business records from any location.

What causes the Sage 50 2024 Backup Failure When Using Remote Data Access error?

Multiple factors can give rise to this issue. Here is the list of the most likely causes that trigger this error:

• The Remote Data Access connection is restricted by the system firewall.
• Corrupted or damaged files in the company data path or directory.
• The network type is configured as Public rather than Private.
• In the Internet Option, the “Sage.com” domain is not added as a reliable site.
• The user attempts to share the company files again, minus owner rights.
• Inconsistent or unavailable internet connection.
• The Actian database service is dormant and requires a reboot.
• On the device, the Airplane Mode is running.

Every reason stated above disrupts the safe data syncing process. Recognizing the right causes is the first step in fixing this issue.

How to resolve the Sage 50 2024 Backup Failure When Using Remote Data Access error?

Here are the steps to fix the Sage 50 Remote Data Access upload failure:

1. Sign in as the Data Owner

Company files can be reshared only by a data owner. Here are the steps to follow:

• Run the Sage 50 accounts.
• Head to the “File” option and then click the “Remote Data Access” option.
• Open the email beside the option “Logged in as”. The email must match the one registered to the data owner.
• In case it fails to match, press the option “Switch User”. Now click the “OK” button.
• Press the option, “Use a different email address”. Now press the “OK” button.
• Sign in with the credentials of the data owner. Now press the “OK” button.
• Now, run the company file. Now, try sharing the company file again.

2. Uninstall Actian Zen and then Reinstall Actian Zen

A damaged Actian database engine is stopping file sharing. Hence, execute a complete reinstall using these steps:

1. Delete Actian Zen

• Shut down Sage 50 accounts. Make sure all the users have logged out.
• Click the keys “Windows+R”. Now enter AppWiz.cpl. Now press the “OK” button.
• Now, remove all installed versions of Actian Zen Workgroup.
• Click the keys “Windows+R” together and enter C:. Now press the “OK” button.
• In case the files named “pvswarch” and “pvswarch” are present, erase them.
• Erase any ActianZen_v[version]_Install.log or Patch.log files.
• Head to C:\Windows. Erase the pvsw.log file available.
• Head to C:\ProgramData. Make sure the files remain hidden. Now, change the Actian folder to OldActian.
• Head to C:\Program Files (x86) or C:\Program Files. Change the name of the Actian folders to OLDActian.
• Head to C:\Program Files\Common Files or (x86). Change the name of the Actian folders to OLDActian.
• Click the keys “Windows + R” and enter Regedit. Now press the “OK” button.
• Hit right-click on the “Computer” option and press the “Export” option. Now, create a registry backup and save it to the desktop.
• Head to:
  • HKEY_LOCAL_MACHINE\Software
  • HKEY_LOCAL_MACHINE\Software\Wow6432Node
• Erase the following keys if they are available:
  • Pervasive Software
  • Actian
  • PEYX489ZK
• Shut down the Registry Editor

2. Install Actian Zen again.

• Run the File Explorer
• Run the “Program Path” to find the PeachtreeInstaller20xx folder or head to C:\Sage\Sage50_[version].
• Run the PervasiveMin folder.
• Run the SetupWorkgroup32_x86.exe file by double-clicking it.
• Now press the “Next” option.
• Acknowledge the license agreement and press the “Next” button.
• Choose the option “Run as a Service” and then press the “Next” button.
• Choose the “Complete” option and press the “Next” button.
• Now click the “Install” button.
• Press the “Finish” button once installation is over.

3. Perform a cleanup of the Company Folder.

Clearing the company folder helps eliminate corrupted and unneeded files. Hence, take a backup before starting.

This procedure may erase certain program data that is non-crucial or unwanted. Such files include alerts, Track-IT statuses, and connected attachments. While using Microsoft 365, change the name of the actual folder and make a new one. Take the help of the same name.

Note: Microsoft 365 connects data to the system ID and folder name.

1. Prepare a Clean Data Folder

• Allow hidden files and file extensions.
• Categorize the present data file path directory.
• Find the program path and data path.
• Head to the data path in File Explorer.
• Hit right-click on an open space. Choose the option “New”. Now, click the “Folder” option.
• Change the name of the folder to a new name.
• Run the original company data folder. Copy and paste the following files into the new folder:
  • All .DAT files
  • Version.txt
  • KMSKeys.xml
  • KeysBackup folder
  • ATTACHMENTS folder
• Run the company file with this new folder.
• Head to the “File” option and then click the “Open Company” option.
• Check if the file opens without any issues.
• In case the issue still exists, move to the next step.

2. Erase Expendable Files

• Run the clean data folder.
• Erase the following folders and files:
  • SQL
  • CopyEdit
  • ADVDATA.DAT
  • ADVHIST.DAT
  • ALARM.DAT
  • ALERT.DAT
  • ATMNTBDL.DAT
  • ATTCHMNT.DAT
  • AUDITTR.DAT
  • COSESS.DAT
  • EVENTLOG.DAT
  • Evntcls.dat
  • Jrnlcls.dat
  • RPTDATA.DAT
  • UserPref.DAT
  • ATTACHMENTS folder
  • All files starting with “old” or ending with .old
  • All .MKD files
  • All .PTR files
• Run the company folder.
• Select the “Yes” button when notified to prepare new files.
• Confirm that the company opens without any issues.

4. Verify Internet Configuration

Here are the steps to check the Internet settings:

• Open the Control Panel and press the tab “Internet Options”.
• Head to the “Security” tab. Press the option “Trusted Sites”.
• Press the option “Sites”. Include *.sage.com.
• Press the “OK” button.
• Head to the “Privacy” tab. Press the option “Sites”.
• Include sage.com. Press the “Allow” button. Now press the “OK” button twice.
• Now, try sharing the company file once more.

5. Additional Solution Tips

Perform the following checks to fix the problems that prohibit Remote Data Access uploads successful:

• Enable port 5222 via the firewall. Get in touch with the network administrator if required.
• The issue is with the actual company file when the test company is successful in uploading.
• Confirm the network type. Adjust it to Private or Work if currently set to Public.
• Check if the internet connection is strong and fast.
• Prepare a new test company and try to share it. Ensure not to use sample companies.
• Ensure that the Airplane Mode is disabled. Restart the system.

Note: These steps are designed to rule out network or configuration problems.

How to Prevent Future Issues in Sage 50 Remote Access Data?

Here are the steps that must be implemented to minimize the possibility of future errors:

1. Conduct Daily Software Updates

Ensure that all Sage 50 updates are completed at the earliest. Such updates include crucial defect fixes and better system performance.

2. Conduct training sessions for every user.

Every user should be trained on how to use Sage 50 in the right manner. The right use of features and configurations minimizes the possibility of data entry issues and improper use.

3. Take data backups regularly.

To save company data daily, use the built-in backup tools provided by Sage 50. Create a backup securely to prevent loss of data due to system crashes or corrupted data.

4. Track System Performance

Monitor system efficiency and network usage. Fix performance problems quickly to avoid any interruption in remote access and data management.

Final Words

Sage 50 Remote Data Access offers safe and seamless access to accounting information. It aids in remote workflows. However, often backup failure is one issue that is experienced while using the remote access feature.

In this guide, complete information on this backup failure issue is shared. Still, for any kind of confusion or query, feel free to reach out to us. Our team of Sage 50 experts and professionals can help you out. Our professionals have expertise with Sage 50 Remote Data Access issues.

Frequently Asked Questions