MSDTC: Receive Returning Out Of Resources Error

HI,

I am getting an error on my sqlserver database server. My clients are
getting kicked out of transaction, giving an error
"New transaction cannot enlist in the specified transaction coordinator"

When i saw the event log on the DB server i found the following message

************************************
Event Type: Information

Event Source: MSDTC

Event Category: CM

Event ID: 4156

Date: 6/13/2005

Time: 9:30:48 AM

User: N/A

Computer: XXXXXXX

Description:

String message: ProcID= 0x780 QMGR::Receive Returning Out Of Resources
Error.

************************************************** ***************

I am using SQLServer 2000 Advanced server, on Windows 2000 Advanced server.

Thanks for help.

Indushekar.indushekara (indushekara@.gmail.com) writes:
> I am getting an error on my sqlserver database server. My clients are
> getting kicked out of transaction, giving an error
> "New transaction cannot enlist in the specified transaction coordinator"
> When i saw the event log on the DB server i found the following message
> ************************************
> Event Type: Information
> Event Source: MSDTC
> Event Category: CM
> Event ID: 4156
> Date: 6/13/2005
> Time: 9:30:48 AM
> User: N/A
> Computer: XXXXXXX
> Description:
> String message: ProcID= 0x780 QMGR::Receive Returning Out Of Resources
> Error.
> ************************************************** ***************

I have no idea what that means, but I would try stopping and restarting
MSDTC and hope for an easy way out.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||indushekara (indushekara@.gmail.com) writes:
> I am getting an error on my sqlserver database server. My clients are
> getting kicked out of transaction, giving an error
> "New transaction cannot enlist in the specified transaction coordinator"
> When i saw the event log on the DB server i found the following message
> ************************************
> Event Type: Information
> Event Source: MSDTC
> Event Category: CM
> Event ID: 4156
> Date: 6/13/2005
> Time: 9:30:48 AM
> User: N/A
> Computer: XXXXXXX
> Description:
> String message: ProcID= 0x780 QMGR::Receive Returning Out Of Resources
> Error.
> ************************************************** ***************

I have no idea what that means, but I would try stopping and restarting
MSDTC and hope for an easy way out.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||I don't know myself, but if you haven't installed Windows SP3, then
this KB article might be relevant:

http://support.microsoft.com/defaul...kb;en-us;312947

If all else fails, you could reinstall MSDTC, but that seems rather
drastic, so it might be worth opening a case with Microsoft first.

http://support.microsoft.com/kb/279786/EN-US/

Simon|||I don't know myself, but if you haven't installed Windows SP3, then
this KB article might be relevant:

http://support.microsoft.com/defaul...kb;en-us;312947

If all else fails, you could reinstall MSDTC, but that seems rather
drastic, so it might be worth opening a case with Microsoft first.

http://support.microsoft.com/kb/279786/EN-US/

Simon