How to Fix Sage 50 System File Error 3111?

Sage 50 System File Error 3111 is a common error that can disrupt the connection between the server and the workstation. It may result from server issues,  an inactive PSQL product key, incomplete installations, network problems, missing Sage 50 files, or conflicts with firewall and VPN settings. Other potential causes include issues with the Actian database engine or missing related files. 

To resolve Sage 50 System File Error 3111, adjust your firewall settings, install Windows updates, restart Actian Zen on the server, or reinstall Actian Zen. First, it’s important to understand what caused this error. In this article, you will gain insights into what the Sage 50 System File Error is, its causes, and solutions to fix this error.

What is Sage 50 System File Error 3111?

This is a common issue that can be very disruptive to the functioning of Sage 50 accounting software. This error usually occurs because of various reasons, such as server malfunctions, incomplete installations, network issues, or conflicts with firewall and VPN settings. However, these are not the only causes of this Error 3111 on Sage 50. There are chances that it may also occur due to issues with the Pervasive (Actian) database engine or accidental loss of related files.

Reasons Behind The Occurrence of Sage 50 System File Error 3111

Enlisted below are the reasons why you have been encountering error 3111 in the Sage 50 file system.

• You must have turned off the server for an unknown reason. 
• The installation process of Sage Accounting software is not completed properly. 
• There must have been some connectivity issue between your workstation and the server. 
• Any other software installed, such as a firewall, has been creating a hindrance to the programming of Sage 50. 
• VPN or any other type of wireless connection is being used to maintain the connectivity. There are chances that these two are not allowing you to use Sage 50 effortlessly. 
• The Actian Zen or Pervasive session has been closed abruptly while you are using the accounting software.
• The PSQL product key is in its inactive state. 
• You must have accidentally or unintentionally removed the Sage 50-related folders saved on your computer system.

How to Fix Sage 50 System File Error 3111?

Enlisted below are the solutions to fix the Sage 50 Error 3111, along with their step-by-step guide.

Solution 1 – Change the Firewall Settings

Sometimes the settings of the antivirus you have installed or the firewall create an impact on other software installed.

• Step 1: Hit the Windows key.
• Step 2: Go ahead and search for Firewall and click on it. 
• Step 3: Now you must select the Advanced Firewall Settings. 
• Step 4: You will have to select the Inbound Rules option from the Settings window’s left side. 
• Step 5: Select the ‘Create a New Rule’ feature. 
• Step 6: You are required to add the port which can be used by you for Sage. 
• Step 7: Click on the ‘Outbound Rules’ option and then repeat the steps mentioned above.
• Step 8: At last, you are required to provide names for both the rules and save them.

Error still unresolved? Go ahead and refer to the other solutions provided below.

See More: Fix Sage 50 Email MAPI Error

Method 2 –  Latest Updates in Windows have to be installed

You may face Error 311 because the Windows installed in your computer system is not up to date. Follow the steps provided below to update Windows. 

• Step 1: Hit the Windows key.
• Step 2: You will have to navigate to the Settings area.
• Step 3: After this, you must go to the Update & Security page.
• Step 4: Check for the most recent updates for Windows.
• Step 5: If there are any such changes, a screen will appear. 
• Step 6: To install the most recent updates, click.
• Step 7: Restart the computer after you’re done. 

You can move on to another solution 2 didn’t help you resolve the error.

Solution 3 – Reboot the Actian Zen (Pervasive) on your Computer server

One of the reasons why you have been facing Sage 50 File System Error 3111 is because of the low performance of Actian Zen or Pervasive. To rectify this issue, follow the steps provided below. 

• Step 1: Enter the server as the administrator. 
• Step 2: In the box, type services.msc and click Start. 
• Step 3: To proceed, click OK.
• Step 4: Locate the Relational Engine Actian PSQL.
• Step 5: Repeat the action with a right-click and choose Stop for the Actian PSQL Transactional Engine as well.
• Step 6: Lastly, select Start with a right-click on each of these services.

If the error persists, move on to the solution provided below.

Read More: SAGE 50 Closing Due to Inactivity

Solution 4 – Delete Actian Zen or Pervasive Software and Reinstall It

If rebooting Actian or Pervasive doesn’t help you remove error 3111, you must consider reinstalling this software. So, follow the steps given below. 

• Step 1: If Sage 50 is operating in the background, close it. 
• Step 2: Press Windows and R simultaneously.
• Step 3: Enter “Control Panel” in the search box.
• Step 4: Select “OK.” Navigate to the Programs and Features area. 
• Step 5: Select and uninstall Actian PSQL v13 Workgroup R2 from the list that appears.
• Step 6: Shut down the Control Panel window.
• Step 7: Toggle Windows+R. Type C:\ in the search box. 
• Step 8: Select OK. Delete the pvsw and pvswarch directories, if they are accessible.
• Step 9: Afterwards, remove any file named PSQL_v[version number]_Install.log.
• Step 10: Navigate to C:\Windows.
• Step 11: Delete the pvsw.log file now.
• Step 12: Enter C:\ProgramData.
• Step 13: The Pervasive Software folder should be renamed as OldPervasive Software. 
• Step 14: Navigate to the C:\ location.Program Data.
• Step 15: Next, change the folder name of Actian to OLDActian. 
• Step 16: Navigate to the C:\Program Files\Typical Files. Rename the folder Actian to OLDActian.
• Step 17: Shut off the computer window.
• Step 18: Once more, press Windows+R.
• Step 19: In the search box, type regedit, then select OK.
• Step 20: Right-click on Computer and choose Export.
• Step 21: Store the Registry backup on your desktop.
• Step 22: Proceed to either HKEY_LOCAL_MACHINE\Software or HKEY_LOCAL_MACHINE\Software\Wow6432Node.
• Step 23: Now, empty the PEYX489ZK and Pervasive Software directories.
• Step 24: Lastly, click Registry Editor to close it.

Steps to Manually Reinstall Actian Zen or Pervasive

The process of reinstalling Actian Zen could be very tiring. Hence, you must go through the steps mentioned below to effortlessly reinstall Actian Zen or Pervasive.

• Step 1: Navigate to the C:\Sage\Sage50_[version] installation folder.
• Step 2: Find the PervasiveMin folder and open it.
• Step 3: Use the SetupWorkgroup32_x86.exe file if you are using Sage 2020 or later. 
• Step 4: Run the file PervasivePSQLv11WGE_x86.msi to use Sage 2019.2 and earlier versions. 
• Step 5: Select Next.
• Step 6: To accept the license agreement, click this link.
• Step 7: Select the Run as a Service tab by clicking Next.
• Step 8: Select Next.
• Step 9: Choose Complete.
• Step 10: Select Next.
• Step 11: Select Install. 
• Step 12: Select “Finish.

Conclusion

You must enhance firewall settings, Sage 50 update Windows, restart the Actian server, or reinstall Actian in order to fix this error 3111 in Sage 50. However, you must gain more insights into the causes behind this error, as it will stop you from taking actions that lead to this issue. Understanding the error’s causes, such as server issues or incomplete installations, is crucial for effective troubleshooting. If these solutions don’t work for you, then you should consider seeking additional help or checking for other potential issues in your system.

Frequently Asked Questions