Announcement

Collapse
No announcement yet.

Closed Connection Error

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Closed Connection Error

    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

  • #2
    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/tut...-refresh-1223/

    --Chris

    Comment


    • #3
      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.
      Stefano Giommi

      e: stefano.giommi@mavenwire.com
      w: www.mavenwire.com

      Comment

      Working...
      X