Cluster resource 'DTC' in clustered service or application 'Cluster Group' failed.

Hi all,

I've a two node cluster with Windows Server 2008 Enterprise Edition x64 (not
R2). I've quorum type "Node and disk majority" I've theese clustered
resource:

AtlanteDTC Distributed Transaction Coordinator
AtlanteFS1 A simple file server
AtlanteFS2 An other simple file server
AtlanteSQL SQL Server 2005 Standard Edition x64 SP3 cluster
configured Active-Passive

Every one our I get this tre errors in the cluster event log:

n°1
Cluster resource 'DTC' in clustered service or application 'Cluster Group'
failed.

n°2 (one second later)
Cluster resource 'DTC' in clustered service or application 'Cluster Group'
failed.

n°3 (one other second later)
The Cluster service failed to bring clustered service or application
'Cluster Group' completely online or offline. One or more resources may be
in a failed state. This may impact the availability of the clustered service
or application.

I've inspected my DTC configuration and I've discovered a situation I can't
understand.In each node of the cluster under "Component Service ->
Computer -> My Computer -> Distributed Transaction Coordinator" I have:

Local DTC
Clustered DTCs

Under Clustered DTCs I see:
Atlante
AtlanteDTC

Under "Cluster Defaul coordinator resource name" I've set MSTDC-AtlanteDTC

Please help!

 

"Andrea Caldarone" <andrea.caldarone@poste.it> wrote in message
news:eAvjadvUKHA.4688@TK2MSFTNGP06.phx.gbl...<!--coloro:blue--><span style="color:blue <!--/coloro-->
> Hi all,
>
> I've a two node cluster with Windows Server 2008 Enterprise Edition x64
> (not R2). I've quorum type "Node and disk majority" I've theese clustered
> resource:
>
> AtlanteDTC Distributed Transaction Coordinator
> AtlanteFS1 A simple file server
> AtlanteFS2 An other simple file server
> AtlanteSQL SQL Server 2005 Standard Edition x64 SP3 cluster
> configured Active-Passive
>
> Every one our I get this tre errors in the cluster event log:
>
> n°1
> Cluster resource 'DTC' in clustered service or application 'Cluster Group'
> failed.
>
> n°2 (one second later)
> Cluster resource 'DTC' in clustered service or application 'Cluster Group'
> failed.
>
> n°3 (one other second later)
> The Cluster service failed to bring clustered service or application
> 'Cluster Group' completely online or offline. One or more resources may be
> in a failed state. This may impact the availability of the clustered
> service or application.
>
> I've inspected my DTC configuration and I've discovered a situation I
> can't understand.In each node of the cluster under "Component Service ->
> Computer -> My Computer -> Distributed Transaction Coordinator" I have:
>
> Local DTC
> Clustered DTCs
>
> Under Clustered DTCs I see:
> Atlante
> AtlanteDTC
>
> Under "Cluster Defaul coordinator resource name" I've set MSTDC-AtlanteDTC
>
> Please help!<!--colorc--><!--/colorc-->


This question is best suited for the Cluster newsgroups, not General. I have
cross-posted it for your convenience to the
microsoft.public.sqlserver.clustering and
microsoft.public.windows.server.clustering newsgroups.

Just check back here for responses. You can reply here, which will post
automatically to the cross-posted groups.

Ace

 

What are your "application or service resource group members for the DTC
group?

What is the dependency graph for that resource.

DTC typicall fails when an underlying resource won't come online.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP


"Ace Fekay [MCT]" <aceman@mvps.RemoveThisPart.org> wrote in message
news:%23cE0yPyUKHA.5208@TK2MSFTNGP05.phx.gbl...<!--coloro:blue--><span style="color:blue <!--/coloro-->
> "Andrea Caldarone" <andrea.caldarone@poste.it> wrote in message
> news:eAvjadvUKHA.4688@TK2MSFTNGP06.phx.gbl...<!--coloro:green--><span style="color:green <!--/coloro-->
>> Hi all,
>>
>> I've a two node cluster with Windows Server 2008 Enterprise Edition x64
>> (not R2). I've quorum type "Node and disk majority" I've theese clustered
>> resource:
>>
>> AtlanteDTC Distributed Transaction Coordinator
>> AtlanteFS1 A simple file server
>> AtlanteFS2 An other simple file server
>> AtlanteSQL SQL Server 2005 Standard Edition x64 SP3 cluster
>> configured Active-Passive
>>
>> Every one our I get this tre errors in the cluster event log:
>>
>> n°1
>> Cluster resource 'DTC' in clustered service or application 'Cluster
>> Group' failed.
>>
>> n°2 (one second later)
>> Cluster resource 'DTC' in clustered service or application 'Cluster
>> Group' failed.
>>
>> n°3 (one other second later)
>> The Cluster service failed to bring clustered service or application
>> 'Cluster Group' completely online or offline. One or more resources may
>> be in a failed state. This may impact the availability of the clustered
>> service or application.
>>
>> I've inspected my DTC configuration and I've discovered a situation I
>> can't understand.In each node of the cluster under "Component Service ->
>> Computer -> My Computer -> Distributed Transaction Coordinator" I have:
>>
>> Local DTC
>> Clustered DTCs
>>
>> Under Clustered DTCs I see:
>> Atlante
>> AtlanteDTC
>>
>> Under "Cluster Defaul coordinator resource name" I've set
>> MSTDC-AtlanteDTC
>>
>> Please help!<!--colorc--><!--/colorc-->
>
>
> This question is best suited for the Cluster newsgroups, not General. I
> have cross-posted it for your convenience to the
> microsoft.public.sqlserver.clustering and
> microsoft.public.windows.server.clustering newsgroups.
>
> Just check back here for responses. You can reply here, which will post
> automatically to the cross-posted groups.
>
> Ace
> <!--colorc--><!--/colorc-->

 

I think it's usefuel a short story of this installation:

I've setup Windows 2008 x64 cluster, passed all validation test
I've setup the two clustered file servers
I've setup SQL Server 2005 Standard SP2 x64 (SP3 was not available)

after that I begin to note the error entry in teh registry mentioned in my
previous post. I've read a lot of documentation and I have decided to
implement a clustered DTC, but those errors doesn't disappear. To answer
your question:

AtlanteDTC has no resource
AtlanteDTC is member of AtlanteSQL

the dependency graph shows:

Cluster: Atlante
Resource: MSDTC-AtlanteDTC
Started 23/10/2009 9.28.05
Completed 23/10/2009 9.28.06

'Cluster Disk 5' has no required dependencies.
'IP Address: 192.168.0.239' has no required dependencies.
'MSDTC-AtlanteDTC' dependencies are 'Cluster Disk 5' and 'Name: AtlanteDTC'.
'MSDTC-AtlanteDTC' required dependencies are Network Name; Storage.
'Name: AtlanteDTC' dependencies are 'IP Address: 192.168.0.239'.
'AtlanteDTC' required dependencies are IP Address.



"Geoff N. Hiten" <SQLCraftsman@gmail.com> ha scritto nel messaggio
news:erufxo3UKHA.4704@TK2MSFTNGP06.phx.gbl...<!--coloro:blue--><span style="color:blue <!--/coloro-->
> What are your "application or service resource group members for the DTC
> group?
>
> What is the dependency graph for that resource.
>
> DTC typicall fails when an underlying resource won't come online.
>
> --
> Geoff N. Hiten
> Principal SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
>
> "Ace Fekay [MCT]" <aceman@mvps.RemoveThisPart.org> wrote in message
> news:%23cE0yPyUKHA.5208@TK2MSFTNGP05.phx.gbl...<!--coloro:green--><span style="color:green <!--/coloro-->
>> "Andrea Caldarone" <andrea.caldarone@poste.it> wrote in message
>> news:eAvjadvUKHA.4688@TK2MSFTNGP06.phx.gbl...<!--coloro:darkred--><span style="color:darkred <!--/coloro-->
>>> Hi all,
>>>
>>> I've a two node cluster with Windows Server 2008 Enterprise Edition x64
>>> (not R2). I've quorum type "Node and disk majority" I've theese
>>> clustered resource:
>>>
>>> AtlanteDTC Distributed Transaction Coordinator
>>> AtlanteFS1 A simple file server
>>> AtlanteFS2 An other simple file server
>>> AtlanteSQL SQL Server 2005 Standard Edition x64 SP3 cluster
>>> configured Active-Passive
>>>
>>> Every one our I get this tre errors in the cluster event log:
>>>
>>> n°1
>>> Cluster resource 'DTC' in clustered service or application 'Cluster
>>> Group' failed.
>>>
>>> n°2 (one second later)
>>> Cluster resource 'DTC' in clustered service or application 'Cluster
>>> Group' failed.
>>>
>>> n°3 (one other second later)
>>> The Cluster service failed to bring clustered service or application
>>> 'Cluster Group' completely online or offline. One or more resources may
>>> be in a failed state. This may impact the availability of the clustered
>>> service or application.
>>>
>>> I've inspected my DTC configuration and I've discovered a situation I
>>> can't understand.In each node of the cluster under "Component Service ->
>>> Computer -> My Computer -> Distributed Transaction Coordinator" I have:
>>>
>>> Local DTC
>>> Clustered DTCs
>>>
>>> Under Clustered DTCs I see:
>>> Atlante
>>> AtlanteDTC
>>>
>>> Under "Cluster Defaul coordinator resource name" I've set
>>> MSTDC-AtlanteDTC
>>>
>>> Please help!<!--colorc--><!--/colorc-->
>>
>>
>> This question is best suited for the Cluster newsgroups, not General. I
>> have cross-posted it for your convenience to the
>> microsoft.public.sqlserver.clustering and
>> microsoft.public.windows.server.clustering newsgroups.
>>
>> Just check back here for responses. You can reply here, which will post
>> automatically to the cross-posted groups.
>>
>> Ace
>><!--colorc--><!--/colorc-->
> <!--colorc--><!--/colorc-->

 

I think that cluster DTC wich fails isn't that one I've created. I think it
is a sort of "default resource" that is hidden...