Upgrade failure - Trying to start PostgresSQL server failed
Traces within the logs:
[SYSERR] [INFO] : java.lang.Exception: java.net.ConnectException: Trying to start PostgresSQL server failed
Please follow the steps below to address the same :
1. Stop the ServiceDesk Plus MSP service.
2. Open the command prompt in administrator mode. Go to ManageEnigne\ServiceDeskPlus MSP\bin and execute the shutdown.bat to shutdown properly.
3. In the same location executed the stopDb.bat to stop database properly if running.
4. Checked the task manager there should NOT be any postgres related to the product in running state. You can check this by right clicking the task->Open file location.
5. Provide FULL Control permission for the user "Everyone" to the ManageEnigne\ServiceDeskPlus MSPPGSQL folder.
6. Invoke the upgrade process now, that should work.
New to ADSelfService Plus?
Related Articles
10.5 Linux Upgrade failure and solutions
Traces in logs : 1. java.lang.Exception: InitPgsqlScript exited with value :: 1 at com.adventnet.persistence.PostgresPreProcessor.executeInitPgsqlScript(PostgresPreProcessor.java:1733) 2. PGSQL Permission related errors. 3. SDP MSP installed as root ...Startup issue in Linux after fresh installation_Error code 10001
In certain scenario, the application cannot be started just after the fresh install. Below are the error traces, [06:24:57:427]|[10-11-2021]|[pglog]|[INFO]|[18]: -sh: 1: /root/ManageEngine/ServiceDeskPlus-MSP/pgsql/bin/pg_ctl: Permission denied| ...Unable to start the application due to Pgsql privilege issue
ISSUE: Application does not start via both services and command prompt. ERROR TRACE: Serverout: [16:26:36:443]|[05-10-2023]|[com.adventnet.db.adapter.postgres.PostgresDBAdapter]|[SEVERE]|[27]: Exception occurred while obtaining mode of the database| ...Upgrade Failed -> Reverting steps
This article covers 2 areas : a) Analysis stage b) Reversion steps (rollback) a) Analysis stage Please send the below files to our support for analysis: 1. Zip the complete log folder present under <servicedesk plus msp home>/server/default or from ...Unable to start the application after power failure
Issue: In certain cases, after a power failure, when the server restarts, the application fails to start and we could see indexoutofboundsexception in the log traces. Cause: This error occurs because the license file gets corrupted which may be due ...