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