IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
Back to discussions
Expand all | Collapse all

Adapter Notification error -- \"Closed Connection \&quo

  • 1.  Adapter Notification error -- \"Closed Connection \&quo

    Posted Thu June 30, 2005 11:09 AM

    Hi All,

    We are facing a severe problem with database connection. Please see below the errors

    <<
    [SCC.0121.0035E] resource delisted with TMFAIL flag, transaction marked for rollback. xid = <Server_name>/1119537951421 rxid = [FormatId=45744, GlobalId=<Server_name>/1119537951421, BranchQual=1]

    [ART.116.3001] Adapter Runtime (Notification): Notification error during execution of . Error: [ADA.1.316] Cannot execute the SQL statement <Sql_statement>. " (17008) Closed Connection" Closed Connection. [ADA.1.316] Cannot execute the SQL statement “<Sql_Statement>”. " (17008) Closed Connection" Closed Connection

    Closed Connection

    We know to disable and re-enable the connection, solve this issue but again it shows same error (�Closed Connection�). I want to solve this permanently and would like to know the root cause of this error.

    I will be grateful if anybody helps in this regards.


    #webMethods
    #Integration-Server-and-ESB
    #webMethods-General


  • 2.  RE: Adapter Notification error -- \"Closed Connection \&quo

    Posted Fri July 01, 2005 05:56 AM

    Hi,

    can you provide us with the following informations:

    • Version of IS (& installed Fixes)
    • Version of JDBC Adapter
    • Version of Database & JDBC-Driver
    • Settings of your JDBC-Connection
    • Is there a Firewall involved in this communication

    There are some known issues related to this.

    Regards,
    Holger


    #webMethods
    #webMethods-General
    #Integration-Server-and-ESB


  • 3.  RE: Adapter Notification error -- \"Closed Connection \&quo

    Posted Tue July 05, 2005 01:40 AM

    Hi…

    In the adapter setting configuration…

    set the Minimum Pool Size = 0.

    This must solve ur problem.


    #webMethods-General
    #Integration-Server-and-ESB
    #webMethods


  • 4.  RE: Adapter Notification error -- \"Closed Connection \&quo

    Posted Wed July 06, 2005 09:09 AM

    Hi Holger,

    Please see below detail information you have required.

    • Version of IS >>6.1

    Installed fixes in updates folder:

    IS_6-1_FP2_Fix3
    IS_6-1_FP2_Fix2
    IS_6-1_FP2_Fix1
    IS_6-1_FP2
    TNS_6-1_Fix11
    TNS_6-1_Fix4
    WmPRT_6-1_Fix21
    TNS_6-1_Fix15
    IS_6-1_FP2_Fix16
    TNS_6-1_Fix3
    TNS_6-1_Fix12
    TNS_6-1_Fix18
    IS_6-1_SP1
    TNS_6-1_Fix6
    TNS_6-1_Fix2
    TNS_6-1_Fix10

    • Version of JDBC Adapter >> 6.0.3

    • Version of Database >> Oracle-8.1.7 & JDBC-Driver >> Oracle JDBC Thin Driver

    • Settings of your JDBC-Connection

    Transaction Type → LOCAL_TRANSACTION
    DataSource Class → oracle.jdbc.pool.OracleDataSource
    networkProtocol
    Other Properties → driverType=thin

    Connection Management Properties

    Enable Connection Pooling true
    Minimum Pool Size 0
    Maximum Pool Size 10
    Pool Increment Size 1
    Block Timeout (msec) 60000
    Expire Timeout (msec) 60000
    Startup Retry Count 1
    Startup Backoff Timeout (sec) 60

    • Is there a Firewall involved in this communication >> No

    Thanx

    Joydeep


    #webMethods-General
    #Integration-Server-and-ESB
    #webMethods


Related Content