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