Closed Connection Error

[andih]

Hi,

We've been getting the below three error message on daily basis recently from our agents. It happens to various agents. We can ensure that there is nothing wrong functionally with the agents as it works for most of the time.

java.sql.SQLException: Closed Connection

javax.transaction.HeuristicMixedException: (weblogic.jdbc.wrapper.JTSXAResourceImpl, HeuristicHazard, (javax.transaction.xa.XAException: Closed Connection))

glog.util.exception.FinderExceptionWrapper


Can anyone make some sense of the above error messages such as what is causing this and what can we do to fix it?

Thanks and Regards,

Andi

[chrisplough]

Re: Closed Connection Error

Andi,

To begin troubleshooting this, I'd check the Oracle DB server for trc (trace) files, to see if an error there is causing the DB connections to time out or get cut.

If nothing is found at that tier, then check the network devices (NICs, switches, routers, firewalls, etc) between the OTM App and DB tiers, to see if there are any network errors.

Finally - if nothing else is found, you can configuring the DB connection pool refresh in OTM, to see if that will help:

http://www.otmfaq.com/forums/f30/tutorial-otm-setup-db-connection-pool-refresh-1223/

--Chris

[Stefano]

Re: Closed Connection Error

Andi,
another fast suggestion, check with the DBA that manage your DB to be sure that for backup reason or any other un-predictable reason, switich off and switch on the DB during the night...without any OTM Services restart, sometimes this is reason of closed connection.

In any case, follows the list of checking from Chris, complete and exhaustive as usual.

Regards.