Sage 50 cannot be started” when Actian / Pervasive is Not Running or Needs to be Restarted

|

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.

Sage 50 cannot be started" when Actian / Pervasive is Not Running or Needs to be Restarted

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:

run

💠 Press Windows +R key on the keyboard
💠 Type in service.msc
💠 Click“OK”
💠 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.

Final Words!

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.

Summary

Sage 50 cannot be started when Pervasive PSQL is not running
Article Name: Sage 50 cannot be started” when Actian / Pervasive is Not Running or Needs to be Restarted
Description: Error: "Sage 50 cannot be started" when Pervasive PSQL is not running or needs to be restarted. Most common solution. Restart pervasive on the ...x
Author Name: Shawn
Publisher Name: Accountingguide.co

Further Reading

Phone

+18583006463

Book a meeting
Chat Now