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

• JMSM

  SSCertifiable

  Points: 5440

  More actions

  July 1, 2008 at 8:51 am

  #193399

  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].