Home » Other » General » Failure to enlist in resource Manager
Failure to enlist in resource Manager [message #195999] Tue, 03 October 2006 10:02 Go to next message
Messages: 1
Registered: September 2006
Location: Ireland
Junior Member

I am running Stress tests on my Application using Microsofts mtsStress tool. I am using 2 Clients, 2 Application Servers and one Database Server and am using Microsofts ODBC Driver.

One error which keeps occurring reads as follows:

A Database Error has occurred. Code -2147168246 [Microsoft][ODBC driver for Oracle] Failure enlisting in Resource Manager.

This error appears to be happening much more frequently on whichever Client is started last.
The error coming back from Oracle is
ORA-02042: too many distributed transactions

Any advice would be appreciated
Re: Failure to enlist in resource Manager [message #196334 is a reply to message #195999] Thu, 05 October 2006 01:14 Go to previous message
Frank Naude
Messages: 4569
Registered: April 1998
Senior Member
If you are on 8.1.7 or below, increase distributed_transactions in your init.ora. If not:

02042, 00000, "too many distributed transactions"
// *Cause: the distributed transaction table was full because too many
//      distributed transactions were active.
// *Action: Run fewer transactions.  If you are sure you don't have too
//      many concurrent distributed transactions, this indicates an internal
//      error and support should be notified.  Instance shutdown/restart
//      would be a work-around.
Previous Topic: Pblm with OraOLEDB.Oracle provider - Multiple-step operation generated errors. Check each status val
Next Topic: Data Modification on Personal Orcale 7
Goto Forum:

Current Time: Mon Aug 02 04:50:48 CDT 2021