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