resource delisted with TMFAIL flag, transaction marked for rollback

Hi, we got this error in our production environment couple of times on a single day and didn’t happen again. I am finding the root cause for this error, but not able to figure out why this error got occurred.
Error is:
2009-09-22 06:31:10 CDT someAdapterService [SCC.0121.0035E] resource delisted with TMFAIL flag, transaction marked for rollback. xid = /1253429900739 rxid = [FormatId=45744, GlobalId=/1253429900739, BranchQual=1] Stack trace data … e74a1fd0a5b211dea273cfb4976e9944 6d8e5fc0a76b11dea846c418f2a4a1d7 6d8fe660a76b11dea850bf053a0a9f14

server info:

Product: webMethods Integration Server
Version: 7.1.2.0
Java Version: 1.5.0_17 (49.0)
Java VM Name: Java HotSpot™ Server VM
Java Vendor: Sun Microsystems Inc.
OS: SunOS
OS: Platform sparc
OS Version: 5.10

JDBC Adapter info

Version: 6.5
Patch: JDBC_6-5_Fix15

Adapter connection Details:

Connection Properties
Transaction Type :LOCAL_TRANSACTION
DataSource Class :oracle.jdbc.pool.OracleDataSource
serverName :
user :
password :
databaseName :
portNumber :
networkProtocol
Other Properties :oracle.net.encryption_client=;
oracle.net.encryption_types_client=;
oracle.net.crypto_checksum_client=;
oracle.net.crypto_checksum_types_client=;
loginTimeout=5;url=jdbc:oracle:thin:@ (DESCRIPTION = (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = ))
(LOAD_BALANCE = no))(CONNECT_DATA =(SERVICE_NAME =
)));
TableFilter=‘’.‘’
Connection Management Properties
Enable Connection Pooling :true
Minimum Pool Size :0
Maximum Pool Size :80
Pool Increment Size :5
Block Timeout (msec) :500
Expire Timeout (msec) :60000
Startup Retry Count :1
Startup Backoff Timeout (sec) :10

I really appreciate your immediate reply, please reply me back if you need any other information.

Thanks in advance,
Ramesh

Any suggestions???

Hi Ramesh - The “TMFAIL” seems to indicate a failiure within the ART’s transaction manager. I see this intermittently in our error logs also, but have not been able to identify a root cause or how it can be replicated in a test environment.