July 1, 2008 at 8:51 am
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].
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply