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 folder.
-> Now initiate the upgrade.
Reference Tickets:
Issue ID:
SD-102480 (Released in 13006)
Upgrade Error Trace:
Sample 1:
16.02.2022 08:33:07 [SYSERR] [INFORMATION] : Caused by: org.postgresql.util.PSQLException: Der Verbindungsversuch schlug fehl. (The connection attempt failed)
16.02.2022 08:33:07 [SYSERR] [INFORMATION] : at org.postgresql.Driver$ConnectThread.getResult(Driver.java:416)
16.02.2022 08:33:07 [SYSERR] [INFORMATION] : at org.postgresql.Driver.connect(Driver.java:271)
16.02.2022 08:33:07 [SYSERR] [INFORMATION] : at java.sql.DriverManager.getConnection(DriverManager.java:664)
16.02.2022 08:33:07 [SYSERR] [INFORMATION] : at java.sql.DriverManager.getConnection(DriverManager.java:247)
16.02.2022 08:33:07 [SYSERR] [INFORMATION] : at com.zoho.cp.ConnectionCreator.createConnection(ConnectionCreator.java:57)
16.02.2022 08:33:07 [SYSERR] [INFORMATION] : at com.zoho.cp.ConnectionCreator.createConnectionInfo(ConnectionCreator.java:67)
16.02.2022 08:33:07 [SYSERR] [INFORMATION] : at com.zoho.cp.ConnectionPool._getConnectionDetail(ConnectionPool.java:90)
16.02.2022 08:33:07 [SYSERR] [INFORMATION] : ... 40 more
16.02.2022 08:33:07 [SYSERR] [INFORMATION] : Caused by: java.net.SocketException: Connection reset
16.02.2022 08:33:07 [SYSERR] [INFORMATION] : at java.net.SocketInputStream.read(SocketInputStream.java:210)
16.02.2022 08:33:07 [SYSERR] [INFORMATION] : at java.net.SocketInputStream.read(SocketInputStream.java:141)
Sample 2:
Feb 5, 2022 1:49:17 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : isServerStopped method returning status ::: true
Feb 5, 2022 1:49:17 PM [com.manageengine.servicedesk.updatemgr.util.SDPrePostExtensionHandler] [SEVERE] : Exception while creating pg_stat_statments and pg_trgm extension in postprocessor
Feb 5, 2022 1:49:17 PM [SYSERR] [INFO] : org.postgresql.util.PSQLException: Connection attempt timed out.
Feb 5, 2022 1:49:17 PM [SYSERR] [INFO] : at org.postgresql.Driver$ConnectThread.getResult(Driver.java:429)
Feb 5, 2022 1:49:17 PM [SYSERR] [INFO] : at org.postgresql.Driver.connect(Driver.java:271)
Feb 5, 2022 1:49:17 PM [SYSERR] [INFO] : at java.sql.DriverManager.getConnection(DriverManager.java:664)
Feb 5, 2022 1:49:17 PM [SYSERR] [INFO] : at java.sql.DriverManager.getConnection(DriverManager.java:247)
Feb 5, 2022 1:49:17 PM [SYSERR] [INFO] : at com.manageengine.servicedesk.updatemgr.util.SDPrePostExtensionHandler.install(SDPrePostExtensionHandler.java:52)
Feb 5, 2022 1:49:17 PM [SYSERR] [INFO] : at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
Feb 5, 2022 1:49:17 PM [SYSERR] [INFO] : at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
Feb 5, 2022 1:49:17 PM [SYSERR] [INFO] : at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
Feb 5, 2022 1:49:17 PM [SYSERR] [INFO] : at java.lang.reflect.Method.invoke(Method.java:498)
Feb 5, 2022 1:49:17 PM [SYSERR] [INFO] : at com.adventnet.tools.update.installer.Unzipper.contextPostInstallation(Unzipper.java:1716)
Feb 5, 2022 1:49:17 PM [SYSERR] [INFO] : at com.adventnet.tools.update.installer.Unzipper.invokePostInstallationClasses(Unzipper.java:1505)
Feb 5, 2022 1:49:17 PM [SYSERR] [INFO] : at com.adventnet.tools.update.installer.ApplyPatch.installPatch(ApplyPatch.java:420)
Feb 5, 2022 1:49:17 PM [SYSERR] [INFO] : at com.adventnet.tools.update.installer.ApplyPatch.run(ApplyPatch.java:270)
New to ADSelfService Plus?
Related Articles
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 ...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. ...