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

    • 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 ...

    • 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 ...

    • Configure PSQL Server Memory Usage

      Version: Any Release Date: 12/17/2021 Q - Can you tell us why PSQL process is taking up so much memory? Is there anything we can do? See sample screen below: A - PSQL server by default can take up about 60ish% of the server memory. This is ...