(08S01/0) Connection reset" Connection reset

, ,
1

Hello All,

We are constantly receiving: (08S01/0) Connection reset"
Connection reset error for SQL JDBC connection.

No changes done.
Error seem to be adhoc!
In between, we saw below error log:
|The JDBC function “ISInternal”, pool alias “SQLConnection” is in fail-fast mode. The exception message is: [SoftwareAG][SQLServer JDBC Driver]Login has timed out.|

Any help why suddenly we are seeing this error.

Request urgent assistance.

Regards,
Khushaboo Shandilya

1 Like
2

Hi Khushaboo,

It is very difficult to say why it is happening but can be due any of the reasons below.

  • Transient error due to network issues.
  • Network latency causing timeouts with database.
  • Also check on the latest fixes available on IS , just to avoid any issues due to the same.
  • Check on the database server logs whenever this error happens, might be you get more info to troubleshoot this.

Regards,
Firoz N

2 Likes
3

I echo the same with Firoz and its very difficult to pinpoint as an outside user and so please work with DBA and IS admins and troubleshoot on the timeout tuning etc… and assess the resolution.

HTH,
RMG

1 Like
4

What version of IS and fix level you have? In the past, there were some issues reported related to Login has timed out. Below is the readme fragment.

When an Integration Server contains a large number of triggers for process
engine, Integration Server writes a “Login has timed out” error during start
up and shut down.

When Integration Server contains a large number of webMethods messaging triggers
for process engine and Universal Messaging is the messaging provider, the
Universal Messaging client code on Integration Server sends signals to terminate
the thread that is attempting to acquire a connection to the database. This
resulted in errors like the following during start up and shut down:

java.sql.SQLException: [SoftwareAG][Oracle JDBC Driver]Login has timed out.

This issue has been resolved by modifying the way in which Integration Server
interacts with the thread management code in the Universal Messaging client.

Regards,
-Kalpesh.

1 Like
5

Many thanks Firoz!
The error was indeed transient as we do not see it anymore.
But, we will keep monitoring and we are also checking the latest fixes.

Regards,
Khushaboo Shandilya

1 Like
6

Thank You Kalpesh!

I have echoed your response to our Admin.

Regards,
Khushaboo Shandilya

7

Good to know. Thank you.

8

Hi Khushaboo,

Please note all transient errors like this SQL timeout in this case to be carefully monitored and can be tuned by your IS/sys admins help and make sure you always maintain the environment with latest and greatest fixes and as Kalpesh also provided very valuable information from the troubleshooting consideration point of view!

HTH,
RMG