ERROR USING DISTRIBUTED TRANSACTION........

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » ERROR USING DISTRIBUTED TRANSACTION........

ERROR USING DISTRIBUTED TRANSACTION........

Rate Topic

Display Mode

Topic Options

Author

Message

JMSM

Posted Tuesday, July 01, 2008 8:51 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 5:03 AM
Points: 185, Visits: 751

Hello,

I’ve got the following error when executing the following query using distribute transaction (Q1).
The point is that i checked the msdtc service on that host and the service was STOPPED (SOL1). I start the service expecting that the query made before gives a result but the error appears again(QFINAL).
Can anyone help me with this point? What should I check? What services should I check?

Once more thanks a lot.
Regards,
JMSM ;)

-- HOSTNAME –

Q1:

Set xact_abort ON
GO
USE SGFE
GO
BEGIN DISTRIBUTED TRANSACTION
SELECT * FROM [HOSTNAME].SGFE.mswait.entidade
COMMIT TRAN
GO

Server: Msg 7391, Level 16, State 1, Line 2
The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction.
[OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator. ]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x8004d00a].

Q2:
When I made the same query without the distributed transaction the result appears(Q2)

SELECT * FROM [HOSTNAME].SGFE.mswait.entidade
GO

A
--
1

SOL1:

C:\>sc \\HOSTNAME query msdtc

SERVICE_NAME: msdtc
TYPE : 10 WIN32_OWN_PROCESS
STATE : 1 STOPPED
(NOT_STOPPABLE,NOT_PAUSABLE,IGNORES_SHUTDOWN)
WIN32_EXIT_CODE : 0 (0x0)
SERVICE_EXIT_CODE : 0 (0x0)
CHECKPOINT : 0x0
WAIT_HINT : 0x0

C:\>sc \\HOSTNAME start msdtc

SERVICE_NAME: msdtc
TYPE : 10 WIN32_OWN_PROCESS
STATE : 2 START_PENDING
(NOT_STOPPABLE,NOT_PAUSABLE,IGNORES_SHUTDOWN)
WIN32_EXIT_CODE : 0 (0x0)
SERVICE_EXIT_CODE : 0 (0x0)
CHECKPOINT : 0x0
WAIT_HINT : 0x7d0
PID : 436
FLAGS :

C:\>sc \\HOSTNAME query msdtc

SERVICE_NAME: msdtc
TYPE : 10 WIN32_OWN_PROCESS
STATE : 4 RUNNING
(STOPPABLE,NOT_PAUSABLE,ACCEPTS_SHUTDOWN)
WIN32_EXIT_CODE : 0 (0x0)
SERVICE_EXIT_CODE : 0 (0x0)
CHECKPOINT : 0x0
WAIT_HINT : 0x0

QFINAL:

Set xact_abort ON
GO
USE SGFE
GO
BEGIN DISTRIBUTED TRANSACTION
SELECT * FROM [HOSTNAME].SGFE.mswait.entidade
COMMIT TRAN
GO

Server: Msg 7391, Level 16, State 1, Line 2
The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction.
[OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator. ]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x8004d00a].

Post #526706

« Prev Topic | Next Topic »

Permissions