A lot of small, medium, as well as large scale business owners are using the Sage 50 software for their finance and accounting works. The software and the tools and services it provides makes work faster and smoother. Also, the software is extremely user-friendly which makes it convenient for anyone to learnt how to operate it. However, there are certain situations where you may face a technical problem if Sage 50 cannot be started when Pervasive PSQL is not running while you are working on the software.
Situations you may Experience while using the Sage 50 Application:
- Need to reboot the software if it is not working
- Sage 50 accounting cannot be started so you have to try again
- The software cannot be started if the Pervasive PSQL is not running
- An error because of or after a power failure
- Sage 50 opens at times, and you see the error after you restart the computer
- Following messages on the event viewer:
- Source: Pervasive PSQL
- General: The grace period for error creating a record: -2147024891
- The program crashes instantly after you open it on the server
Also Read: How to Fix Sage 50 Address Generic Com Error
Causes of Sage 50 Error when Pervasive PSQL is not Running and Needs to be Restarted?
There are several reasons that can cause the errors mentioned above. You need to know about these causes so you can figure out the correct one that lead to the problem. This is important to find the most accurate solution.
Common and Significant Reasons that Cause the Error:
💠 Pervasive PSQL does not run on the host computer
💠 Pervasive PSQL doesn’t start after resuming the PC
💠 Pervasive PSQL doesn’t start after update installations
💠 Pervasive PSQL is suspended
💠 Pervasive is stopped
💠 Operating System is upgraded
💠 Workstation crashes down ending Pervasive on server
💠 Updates performed by Windows 10
How to Fix Sage 50 Error Cannot Start when Pervasive PSQL is not Running or Needs to be Restarted?
Once you have analyzed the causes behind the error, it is time for you to try and resolve it and make sure that everything works fine. Follow the steps mentioned below one by one in exact order:
Step 1: Setting up in stand-alone way:
💠 In a stand-alone setup, rebooting your system can help you quickly eliminate the problem
💠 Once it is rebooted, restart the computer
💠 Now, resume Pervasive PSQL
Step 2: If you are using Sage on a network, first ensure that it is closed on all the systems on that network and then go through the following steps on the server computer:
💠 Press Windows +R key on the keyboard
💠 Type in service.msc
💠 Now, right-click “Pervasive PSQL Workgroup Engine” and restart your computer (In case, you don’t see the restart option, then press “start”)
💠 Next, double-click on the Pervasive PSQL workgroup engine
💠 Press the recovery tab
💠 Select the option that says ‘Restart the Service’ in the first failure and ‘Drop Down Boxes’ in the second failure
💠 After, make sure that the Reset Fail Count is set to reset the PC after 1 day
💠 Press ‘OK’
💠 Verify that the Sage 50 software opens on the server without any concerns
Step 3: Ensure that your Windows 10 is updated successfully:
Important note: Once you reboot the computer after undergoing all the aforementioned steps, you will need to start the services manually as they do not start automatically.
➤ How can I Completely Remove and Reinstall Pervasive PSQL?
Let us look at the removal and reinstallation of Pervasive PSQL in two parts.
➤ Part 1: Uninstall/Remove Pervasive PSQL
↳ Start by closing Sage 50
Note: If you are using the software on a network, you have to ensure that it is closed on all systems before trying to remove and removing Pervasive PSQL.
↳ Hit Windows+R keys on your keyboard
↳ Type in Control Panel, and press OK
↳ Choose Programs & Features
↳ Uninstall any listed version of Pervasive PSQL Workgroup Engine
↳ Close Control Panel
↳ Again, press Windows+R keys on the keyboard
↳ Key in C:\ and press OK
↳ Erase the folder “pvsw” and “pvswarch” (if they exist)
↳ Next, remove any file named PSQL_v[version number]_Install.log (if it exists)
↳ Now, go to C:\Windows
↳ Delete “pvsw.log: (if it exists)
↳ Go to C:\ProgramData
↳ Rename any folder that says “Pervasive Software folder” to “OldPervasive Software”
↳ Now, go to C:\Program Files or C:\Program Files (x86)
↳ Repeat step 14
↳ Go to C:\Program Files\Common Files or C:\Program Files (x86)\Common Files
↳ Repeat step 14
↳ Now, restart your computer
↳ Press Windows+R keys
↳ Type in regedit
↳ Press OK
↳ Now, right-click on Computer> Export> Save backup of Registry to the Desktop of the computer
↳ Go to HKEY_LOCAL_MACHINE\Software or HKEY_LOCAL_MACHINE\Software\Wow6432Node
Important note: Under any circumstances, DON’T DELETE the Wow6432Node folder.
↳ Erase Pervasive Software and PEYX489ZK (if it exists)
↳ Finally, shut down the Registry Editor
➤ Part II: Manually Reinstall Pervasive PSQL:
↳ Go to the installation folder typically located at C:\Sage\Sage50_[version]or browse to Program Path.
↳ Open Pervasive Min folder
↳ Run SetupWorkgroup32_x86.exe if you have the 2020 version or PervasivePSQLv11WGE_x86.msi if it’s the ↳ 2019.2 or older
↳ Click Next
↳ Accept the license agreement and press Next
↳ Choose Run as a Service and press Next
↳ After, press Complete and click Next again
↳ Now, click Install
↳ Finally, press Finish.
Important note: If the Pervasive installer gets stuck and shows you the message: “Please wait, Executing PSQL post-install configuration actions”, you will have to eject the DVD.
If you have followed all the troubleshooting guidance provided above and still aren’t able to address the problem of Sage 50 not starting when Pervasive PSQL is noy running or getting started, you must get in touch with our round-the-clock technical support team through telephone or email. Our brilliant team of expert technical support professionals who will help you fix all your problems in no time.
🔔 Frequently Asked Questions
Q1. How can I restart Pervasive PSQL in Sage 50?
Ans: The process is very simple. To restart Pervasive PSQL in Sage 50, you have to double-click on “Administrative Tools” and press “Services”. Now, choose the “Pervasive PSQL Work Group Engine” from the right-side pane. Next, press “stop” and then “action”. Finally, from the “Action” menu, select “Restart”.
Q2. How do I restart the Pervasive Database Engine or Pervasive services on a server or workstation?
Ans: To restart the Pervasive Database Engine or the services on a server or workstation, you need to first ensure that all users are logged off from Sage. If you don’t, you can risk data corruption. Once everyone is logged off, attempt the Have all Sage 300 Construction and Real Estate and Sage Estimating users everywhere log off the software.
NOTE: Failure to do so may result in data corruption.
💠 Go to Start>Search programs and features
💠 Now, type inservices.msc
💠 Press OK/Open
💠 Scroll down the list and find Pervasive PSQL Workgroup Engine.
Note: Various versions of Pervasive PSQLcould show a slightly distinctive service name.
💠 Right-click on each of the Pervasive PSQL services listed and select Stop.
💠 Right-click on each of the services again and select Start.