After Server Reboot, Elliott Stopped Working Due to PSQL Engines Not Starting

After Server Reboot, Elliott Stopped Working Due to PSQL Engines Not Starting

Release Date: 08/09/2022
Version: All

Q - Our server has been rebooted for maintenance.  Since the eboot, none of the Elliott users can use Elliott Business Software.

A - This can happen if PSQL services did not start after the server reboot.  We have seen this before. Typically this happens when PSQL services try to start, but not all required components are loaded in the server memory yet. You could go to Services and find "Actian PSQL Relational Engine" and "Actian PSQL Transactional Engine.".  Check the "Status" column to see if they are "Running."  If not, right click and choose "Start." This should resolve the problem.

If the issue was indeed due to PSQL services not being started, you can right click on both PSQL Engines and choose "Properties." Consider changing the Startup type from "Automatic" to "Automatic (Delayed Start)." See sample screen below:



* Note: PSQL version 15 or later combines both Relational and Transaction Engines and hence has only one entry in Services.

EMK


    • Related Articles

    • Use Automatic (Delay Start) if PSQL Engine Does not Start After Server Reboot

      Release Date: 04/25/2025 Version: V7.x & Up Q - There's been a few times recently that, after their server has rebooted (either from patching or just routine maintenance), the PSQL engine did not start automatically. As a result, Elliott didn't work ...

    • Elliott Report Viewer Has Stopped Working

      Q - I have a couple users that have been getting the following error when trying to do anything that launches the report viewer. See sample screen below: Description: Stopped working Problem signature: Problem Event Name: CLR20r3 Problem Signature ...

    • Can I Dynamically Adjust Elliott / PSQL 11 Server Memory?

      In the virtual server environment, it is very easy to adjust the server's memory in order to better suit your requirements and more efficiently use the server hardware. However, it is important for you to be aware that the PSQL 11 engine license can ...

    • Do I Need to Change PSQL Server Engine Default Parameters After Installing It?

      Q - I am installing a PSQL server engine for my client. Do I need to change any PSQL parameters after the installation? A - Generally speaking, you don't need to change PSQL parameters after the installation. There are two optional changes you can ...

    • Converting Elliott Physical Server to a Virtual Machine (VM)

      Release: 4/29/2021 Version: 7.5 & Up Q - We are going to move our Elliott physical server to a Virtual Machine (VM). We would like to do this with minimal effort. One tool that we are evaluating to do this is called Disk2Vhd. Have you ever ...