Adapter notification error: "The connection is closed"

,
1

We have an adapter notification that polls very frequently (approximately 3 times a minute). This morning we noticed the integration was not running (this is a critical part of the business infrastructure and gets a lot of attention) and got an error in the IS logs saying “The connection is closed”.

What causes this? If the connection times out for a network reason, does it self-heal or do we have to manually go and re-enable the connection?

Thanks

Rob

2

Do you mean that server was shutdown and when you started it you saw this (“The connection is closed”.
) error?

3

No sorry, I mean the integration that depends on the adapter was not running. Integration Server was up the whole time.

4

this looks like a stale connection problem. happened with me in all the connections which have frequent/too many db interactions.
change ‘Minimum Pool Size’ to 0 in your connection properties. hope this works.
Let me know if it still has issues.

5

Thanks Anjni. Are you saying this would give a “This connection is closed” error? I’m not aware of a stale connection causing this?

Either way, the pool size is already 0.

What I’m thinking is that a network outage caused the connection to disable itself, and it doesn’t re-enable, which is why I’m asking whether connections can self-heal.

6

Yes I used to get these errors in my production envmnt and after changing the value to 0 it has stopped.
Usually the behavior with network outages what I have seen is it connects again when the network is back. As my envmnt is on latest fixes so this might also be a bug. :roll:

7

Can you share the complete server.log or error log… Might be the issue with DB down?

8

Hi Rob,

I suspect the high volume of transaction caused this issue. Please try to adjust watt.art.tmgr.timeout in extended setting. It signifies seconds before transaction timeout.

More available at page 243 of http://techcommunity.softwareag.com/ecosystem/documentation/webmethods/adapters_estandards/Adapters/JDBC/JDBC_6-5/6-5_JDBC_Adapter_Install_and_Users_Guide.pdf

HTH.

Thanks,
Rankesh

9

Hi Grant,
Is it a one time issue or keep repeating. If it one time, then kindly don’t do any changes in Prod. In case,if it is repeating kindly share more details to better suggest.

10

Yes please let us elaborate more on the behaviour and what is the db you have the triggers created on and notification interval set to 60 seconds?

At what situation does exact timeout errors occurring?

HTH,
RMG

11

Hi guys

The network going down is the reason the connection timed out; what I didn’t understand was why the connection didn’t re-establish correctly upon the return of the network connectivity.

12

The DB is very quick, so there won’t be problems there, and we throttle the select to be at most 200 rows at a time. Notification interval is set to provide a 10s gap between processing runs.

13

What is the minimum connection pool set on the JDBC connectin properties 0 or some thing else?

Some times even though the DB comes back there might be stale connections not released from the pool or network latency issue and this would cause mess up especially JDBC notifications and also what JDBC Adapter6.5 fix level are you on latest I assume?

HTH,
RMG

14

Yes, the connection pool size is 0. Adapter version is JDBC_6.5_Fix39.

15

Most likely this could be either network tunnel issue reaching DB or connection pool is not working as expected for the respective DB.

What is your IS version and core fixes level?

HTH,
RMG