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

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.

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

Hi…

In the adapter setting configuration…

set the Minimum Pool Size = 0.

This must solve ur problem.

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