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

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

    • Actian PSQL Not Started Automatically After Server Reboot

      Release Date: 12/14/2017 Q - I restarted the server and for whatever reason the relational and transactional engines do not start, even though they are set to automatic. Have any idea why this is happening? A - Go to PSQL services –properties -- and ...

    • Btrieve Error 161 on Password File When Starting Up Elliott

      Q - We are receiving an Error 161: The maximum number of user count licenses has been reached. This happens to all users when starting up Elliott. We have rebooted all office computers and the PSQL server. There is no one is in Elliott. Yet we are ...

    • Inconsistent Elliott Error on Terminal Server

      Q - We occasionally run into an issue with our terminal server where Elliott crashes after entering the username/password. After clicking on the shortcut, it prompts for the username / password. After clicking OK, it crashes. We are confused because ...

    • Hardware Recommendations for Your PSQL Database Server

      Release Date: 10/10/2017 This article was written by Bill Bach and is provided at the courtesy of Goldstar Software. Recommendations for hardware for your PSQL database environment One of the most common questions we get is “What kind of hardware ...