Pgsql: Connectivity issue due to pgsql driver (42.2.16) - Compatible till 13005
Why?
PostgreSQL updated the default fallback behavior in the 42.2.16 driver in a way that breaks support for PostgreSQL instances. This version of the driver was bundled into ServiceDeskplus build version less than 13006. This PostgreSQL bug will affect only certain environments which is caused due to configurations, resource constraints, version discrepancies in the hosted environment.
This Article is only applicable for build versions less than 13006
Reference Traces :
- Caused by: java.net.SocketException: Connection reset
(OR)
- org.postgresql.util.PSQLException: Connection attempt timed out.
(OR)
- invalid frontend protocol
How to resolve this issue ?
An immediate workaround for this issue is by replacing the probelamatic version of postgresql driver with the bug fixed driver which is of version "42.2.19".
- Shut Down the Application Service, If it is running.
- Navigate to "<Product_Installation_Directory> \ lib " folder and move the "postgresql-42.2.16.jar" to a different location as a backup.
- Now download the attached zip, extract it and then place the "postgresql-42.2.16.jar" extracted from the zip inside the above lib folder.
- Now try to start the database using "startDB" script present in the "<product_installation_location> \ bin".
- If the database is started, you are good to proceed with your operations.
- If it fails to start, then please report it to our support Team with the "<product_installation_location>\logs" folder.
New to ADSelfService Plus?
Related Articles
Pgsql: Connectivity issue due to pgsql driver (42.2.16) - Compatible till 13005
Please follow the below instructions: -> Go to <Installation-directory>/Servicedesk/lib folder and move the postgresql-42.2.16.jar to a different location as a backup. -> Now download the jar from the below link and then place it inside the above lib ...How to customize MailFetching Connectivity issue Notification
MailFetching connectivity issueUnable 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| ...Restore issue - java.lang.ClassNotFoundException: org.postgresql.Driver
Error: java.lang.ClassNotFoundException: org.postgresql.Driver at java.net.URLClassLoader$1.run(URLClassLoader.java:366) at java.net.URLClassLoader$1.run(URLClassLoader.java:355) Solution: 1. Install a fresh instance of the same build you are using ...How do I convert the database from PGSQL to MSSQL?
1. Stop ManageEngine ServiceDeskPlus – MSP service. 2. Take a backup of the existing data and configuration under PGSQL database by following the below steps. Open CMD as an administrator and execute command to start the data backup. ...