Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

ERROR USING DISTRIBUTED TRANSACTION........ Expand / Collapse
Author
Message
Posted Tuesday, July 1, 2008 8:51 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, October 7, 2014 4:53 AM
Points: 186, Visits: 818
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 »

Add to briefcase

Permissions Expand / Collapse