No announcement yet.

Closed Connection Error

  • Filter
  • Time
  • Show
Clear All
new posts

  • Closed Connection Error


    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))


    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,


  • #2
    Re: Closed Connection Error


    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:

    This website is for sale! is your first and best source for all of the information you’re looking for. From general topics to more of what you would expect to find here, has it all. We hope you find what you are searching for!



    • #3
      Re: Closed Connection Error

      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.

      Stefano Giommi

      e: [email protected]