Error in adapter connection - \"Close Connection\"

, ,
1

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�). Is there any permanent solution to resolve this issue or Any patch that may refresh the adapter conections?

Please see below the informations that may required.

  • Version of IS >>6.1
  • Version of JDBC Adapter >> 6.0.3
  • Version of Database >> Oracle-8.1.7 & JDBC-Driver >> Oracle JDBC Thin Driver
    No Firewall is involved in the interaction with wM and DB.

Thanx for your help!

regards,

Deep

2

Hi,

please check your timeout and pool size config for the connection in doubt:

set MinPool size to 0. This will force the the Pool to destroy invalid conns and create new one.

set the expire timeout for the connection smaller than the timeout configured by DB-Server.

Check for IS 6.1 SP1 (& Fixes (incl. IS_ART_6-1_SP1_Fix1)), JDBC-Adapter 6.0.3 FP1.

Try Oracle Thin Driver from 10g (It should work with Oracle 8i as well).

Regards,
Holger