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
How to customize MailFetching Connectivity issue Notification
MailFetching connectivity issueExternal Postges - PG Extension Issue
Error: If cxs who are using external postgres(not bundled postgres) faces below error, 1. Migration fails with "Upgrade halted. Please create postgres extension pg_trgm and try again" error. (or) 2. Start-up fails with "Application startup halted. ...Email with .wav attachment is not getting extracted during mail processing due to the issue fix of SD-65175.
Email with .wav attachment is not getting extracted during mail processing due to the issue fix of SD-65175. The content-type of the attachment is APPLICATION/OCTET-STREAM. Since it is in Upper case the following condition - ...Fix jar for EWS connectivity issue
Issue: In EWS for incoming, we are facing intermittent connectivity issues like 'unexpected end of ZLIB input stream', '(503) service unavailable', 'this connection to store is dead' etc. Resolution: Apply the attached fjar (Download the build ...Upgrade Failure due to the presence of CtrlZ Failure
This issue (SD-118352) in fixed in version 14710. Post this release, these characters are handled in the migration itself. If you are planning to migrate from version less than 14610 to 14610, then you can directly migrate to 14710, to handle this ...