MSDTC?

I keep getting this message on my application server.
The description for Event ID ( 0 ) in Source ( ODBC ) cannot be found. The
local computer may not have the necessary registry information or message DLL
files to display messages from a remote computer. The following information
is part of the event: Failed to enlist in DTC: SQL state 37000, native error
8501, error message [Microsoft][ODBC SQL Server Driver][SQL Server]MSDTC on
server 'PROSQL' is unavailable..
what does this mean?...thanks
-Jim
Check to see if DTC is running on PROSQL.
-Sue
On Mon, 16 Oct 2006 14:14:02 -0700, Jim
<Jim@.discussions.microsoft.com> wrote:

>I keep getting this message on my application server.
>The description for Event ID ( 0 ) in Source ( ODBC ) cannot be found. The
>local computer may not have the necessary registry information or message DLL
>files to display messages from a remote computer. The following information
>is part of the event: Failed to enlist in DTC: SQL state 37000, native error
>8501, error message [Microsoft][ODBC SQL Server Driver][SQL Server]MSDTC on
>server 'PROSQL' is unavailable..
>what does this mean?...thanks
>-Jim

MSDTC?

I keep getting this message on my application server.
The description for Event ID ( 0 ) in Source ( ODBC ) cannot be found. The
local computer may not have the necessary registry information or message DL
L
files to display messages from a remote computer. The following information
is part of the event: Failed to enlist in DTC: SQL state 37000, native error
8501, error message [Microsoft][ODBC SQL Server Driver][SQL Serv
er]MSDTC on
server 'PROSQL' is unavailable..
what does this mean?...thanks
-JimCheck to see if DTC is running on PROSQL.
-Sue
On Mon, 16 Oct 2006 14:14:02 -0700, Jim
<Jim@.discussions.microsoft.com> wrote:

>I keep getting this message on my application server.
>The description for Event ID ( 0 ) in Source ( ODBC ) cannot be found. The
>local computer may not have the necessary registry information or message D
LL
>files to display messages from a remote computer. The following information
>is part of the event: Failed to enlist in DTC: SQL state 37000, native erro
r
>8501, error message [Microsoft][ODBC SQL Server Driver][SQL Ser
ver]MSDTC on
>server 'PROSQL' is unavailable..
>what does this mean?...thanks
>-Jim

MSDTC?

I keep getting this error on my application server...what does it mean?

The description for Event ID ( 0 ) in Source ( ODBC ) cannot be found.
The local computer may not have the necessary registry information or
message DLL files to display messages from a remote computer. The
following information is part of the event: Failed to enlist in DTC:
SQL state 37000, native error 8501, error message [Microsoft][ODBC SQL
Server Driver][SQL Server]MSDTC on server 'PROSQL' is unavailable..

any help would be appreciated...thanks

-Jim
On Oct 16, 2:09 pm, "Jimbo" <jim.fer...@.motorola.comwrote:

Quote:

Originally Posted by

I keep getting this error on my application server...what does it mean?
>
The description for Event ID ( 0 ) in Source ( ODBC ) cannot be found.
The local computer may not have the necessary registry information or
message DLL files to display messages from a remote computer. The
following information is part of the event: Failed to enlist in DTC:
SQL state 37000, native error 8501, error message [Microsoft][ODBC SQL
Server Driver][SQL Server]MSDTC on server 'PROSQL' is unavailable..
>
any help would be appreciated...thanks
>
-Jim

It seems you're trying to run global/XA transactions including the
SQLServer as one resource, and in order to do XA, MS SQLServer
needs it's MSDTC running. (MS Distributed Transaction Coordinator).
Joe Weinstein at BEA Systems

MSDTC: Receive Returning Out Of Resources Error

HI,

I am getting an error on my sqlserver database server. My clients are
getting kicked out of transaction, giving an error
"New transaction cannot enlist in the specified transaction coordinator"

When i saw the event log on the DB server i found the following message

************************************
Event Type: Information

Event Source: MSDTC

Event Category: CM

Event ID: 4156

Date: 6/13/2005

Time: 9:30:48 AM

User: N/A

Computer: XXXXXXX

Description:

String message: ProcID= 0x780 QMGR::Receive Returning Out Of Resources
Error.

************************************************** ***************

I am using SQLServer 2000 Advanced server, on Windows 2000 Advanced server.

Thanks for help.

Indushekar.indushekara (indushekara@.gmail.com) writes:
> I am getting an error on my sqlserver database server. My clients are
> getting kicked out of transaction, giving an error
> "New transaction cannot enlist in the specified transaction coordinator"
> When i saw the event log on the DB server i found the following message
> ************************************
> Event Type: Information
> Event Source: MSDTC
> Event Category: CM
> Event ID: 4156
> Date: 6/13/2005
> Time: 9:30:48 AM
> User: N/A
> Computer: XXXXXXX
> Description:
> String message: ProcID= 0x780 QMGR::Receive Returning Out Of Resources
> Error.
> ************************************************** ***************

I have no idea what that means, but I would try stopping and restarting
MSDTC and hope for an easy way out.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||indushekara (indushekara@.gmail.com) writes:
> I am getting an error on my sqlserver database server. My clients are
> getting kicked out of transaction, giving an error
> "New transaction cannot enlist in the specified transaction coordinator"
> When i saw the event log on the DB server i found the following message
> ************************************
> Event Type: Information
> Event Source: MSDTC
> Event Category: CM
> Event ID: 4156
> Date: 6/13/2005
> Time: 9:30:48 AM
> User: N/A
> Computer: XXXXXXX
> Description:
> String message: ProcID= 0x780 QMGR::Receive Returning Out Of Resources
> Error.
> ************************************************** ***************

I have no idea what that means, but I would try stopping and restarting
MSDTC and hope for an easy way out.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||I don't know myself, but if you haven't installed Windows SP3, then
this KB article might be relevant:

http://support.microsoft.com/defaul...kb;en-us;312947

If all else fails, you could reinstall MSDTC, but that seems rather
drastic, so it might be worth opening a case with Microsoft first.

http://support.microsoft.com/kb/279786/EN-US/

Simon|||I don't know myself, but if you haven't installed Windows SP3, then
this KB article might be relevant:

http://support.microsoft.com/defaul...kb;en-us;312947

If all else fails, you could reinstall MSDTC, but that seems rather
drastic, so it might be worth opening a case with Microsoft first.

http://support.microsoft.com/kb/279786/EN-US/

Simon

MSDTC/SQL Server 2000/Windows Server 2003 cluster

Hi
I have to machines (SKADB01 and SKADB02) which are in a Windows 2003
Cluster. The cluster has two groups - one for Microsoft BizTalk Server
2002 and one for SQL Server 2000. The cluster is an actice/passive
cluster, and the SQL Server Group runs on one of the machines and the
BizTalk group runs on the other machine per default. If one machine
should fail, the other will take over for it.
My problem is, that BizTalk only runs if the SQL Server is running on
SKADB02. If I fail SQL Server over to SKADB01, I get errors with DTC.
"Enable Network DTC Access" is enabled on both machines, and in the
BizTalk group, there has been created an MSDTC ressource.
I do not know that much about clustering and DTC. It just seems to me,
that the errormessages point to DTC.
Does anyone have any idea?
Thanks
Jan Eliasen, representing himself and not the company he works for.
If your message is "MSDTC on server [..] is unavailable. Error 5" (access
denied) your problem may be that the MSDTC cluster resource has started after
the SQL Server Instance. This is a known problem.
"Jan Eliasen" wrote:

> Hi
> I have to machines (SKADB01 and SKADB02) which are in a Windows 2003
> Cluster. The cluster has two groups - one for Microsoft BizTalk Server
> 2002 and one for SQL Server 2000. The cluster is an actice/passive
> cluster, and the SQL Server Group runs on one of the machines and the
> BizTalk group runs on the other machine per default. If one machine
> should fail, the other will take over for it.
> My problem is, that BizTalk only runs if the SQL Server is running on
> SKADB02. If I fail SQL Server over to SKADB01, I get errors with DTC.
> "Enable Network DTC Access" is enabled on both machines, and in the
> BizTalk group, there has been created an MSDTC ressource.
> I do not know that much about clustering and DTC. It just seems to me,
> that the errormessages point to DTC.
> Does anyone have any idea?
> Thanks
> --
> Jan Eliasen, representing himself and not the company he works for.
>
|||Hi
That is not the problem I get. All my errormessages come from BizTalk,
which can not get to SQL Server sometimes.
If My BizTalk group is running on one SKADB01 and the SQL SErver group
is running on SKADB02, where should the MSDTC ressource be running?
Does it make a difference?
Jan Eliasen
On Thu, 26 Aug 2004 18:43:04 -0700, "Stephen Strong"
<StephenStrong@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>If your message is "MSDTC on server [..] is unavailable. Error 5" (access
>denied) your problem may be that the MSDTC cluster resource has started after
>the SQL Server Instance. This is a known problem.
>
>"Jan Eliasen" wrote:
Jan Eliasen, representing himself and not the company he works for.
|||MSDTC can run on any node. But Biztalk2002 is not a cluster aware
application and it is a bad idea to use Biztalk in an active/active cluster
with SQL. Biztalk is more of a group aware application. Look in to creating
a server group and addind two servers into the group if you are looking into
scaling biztalk.
"Jan Eliasen" wrote:

> Hi
> That is not the problem I get. All my errormessages come from BizTalk,
> which can not get to SQL Server sometimes.
> If My BizTalk group is running on one SKADB01 and the SQL SErver group
> is running on SKADB02, where should the MSDTC ressource be running?
> Does it make a difference?
> Jan Eliasen
>
> On Thu, 26 Aug 2004 18:43:04 -0700, "Stephen Strong"
> <StephenStrong@.discussions.microsoft.com> wrote:
>
> --
> Jan Eliasen, representing himself and not the company he works for.
>
|||Hi.
Thanks for you answer. We are running BizTalk in an active/passive
cluster - not an active/active cluster.
Jan Eliasen
On Tue, 31 Aug 2004 09:07:04 -0700, "Rony Thomas"
<rony_p_thomas@.hotmail.com> wrote:
[vbcol=seagreen]
>MSDTC can run on any node. But Biztalk2002 is not a cluster aware
>application and it is a bad idea to use Biztalk in an active/active cluster
>with SQL. Biztalk is more of a group aware application. Look in to creating
>a server group and addind two servers into the group if you are looking into
>scaling biztalk.
>"Jan Eliasen" wrote:
Jan Eliasen, representing himself and not the company he works for.
|||i just built on active-active sql cluster for biztalk servers. we have
2 biztalk servers and i plan to use each node for each biztalk server.
in case, one node is down and it can switch to another node. i set up
the DTC and move biztalks' db to the cluster. i always got error of
biztalk for the node which does have DTC.
based on your theory, it looks that my plan does not work. we don't
want group biztalk servers because one is used internally and the
other externally.
how about biztalk 2004?
thanks,
jj
On Tue, 31 Aug 2004 09:07:04 -0700, "Rony Thomas"
<rony_p_thomas@.hotmail.com> wrote:
[vbcol=seagreen]
>MSDTC can run on any node. But Biztalk2002 is not a cluster aware
>application and it is a bad idea to use Biztalk in an active/active cluster
>with SQL. Biztalk is more of a group aware application. Look in to creating
>a server group and addind two servers into the group if you are looking into
>scaling biztalk.
>"Jan Eliasen" wrote:

MSDTC, Active Diretory, DAO, And Transactions

If this is in the wrong forum, my apologies.
Here is the situation. We have a .Net application that someconsultants developed several years ago. They made use of DAO fordatabase access, using some inbuilt classes like ContextUtil to get atransation environment.
Until last weekend, the envorinment was:
Web application on IIS5 / Windows 2000 Advanced Server
Database on SQL2000 on Windows 2000 Advanced Server
We switched over to a new database server environment - a cluster oftwo Windows 2003 servers wth SQL Server 2000. This requiredActive Directory to be set up on the two database server machines.
Everything worked but this particular application - where it goes toupdate the database. It appears (but since I haven't yet beenable to rebuild the .Net solution) that the error - "Object referencenot set to an instance of object." is in fact a spurious error causedwhen the transation tries to roll back.
I have spent about 10 hours on this, and have come to the conclusionthat the fact I have MSDTC involved on a database server that is in anAD domain, while the web server that is issuing the transaction isoutside that domain is the cause of the problem. Now, I don'twant to put AD on the IIS 5 web server - we are migrating this to a newWin2k3/IIS6 server in 5 or 6 weeks time.
Any suggestions? If I have to, I can move the database for thisparticular app back to the non-clustered Windows 2000 server (which isalso outside the AD domain).
Thanks for your indulgance.
Microsoft requirement and good practice is a database Server is just a member server, it should not have anything to do with AD users. If your application is using DAO(data Access object) which was obselete in 1998 you may need MSDTC, the error could be you have not properly configured distributed transaction in SQL Server. Run a search for distributed transaction in the BOL(books online). The advice keep your application from none database users and AD. Hope this helps.

MSDTC!

I have SQL Server 7.0 installed in my Win2K Pro machine. When I
navigate to Start-->SQL Server 7.0-->MSDTC Administrative Console, I
get the "Missing Shortcut" error. Even a search on 'dac.exe' doesn't
yield any result. Does this mean that the DTC console didn't get
installed while SQL Server 7.0 was installed? How do I install it
directly from the SQL Server Setup CD or do I have to uninstall & then
reinstall SQL Server 7.0 to make use of DTC? Or is there an altogether
different Setup CD for DTC?
This is the first time I am trying to use DTC.
Thanks,
Arpan
There isn't a seperate CD/setup for DTC. I would un-install and
re-install.
ALI

MSDTC!

I have SQL Server 7.0 installed in my Win2K Pro machine. When I
navigate to Start-->SQL Server 7.0-->MSDTC Administrative Console, I
get the "Missing Shortcut" error. Even a search on 'dac.exe' doesn't
yield any result. Does this mean that the DTC console didn't get
installed while SQL Server 7.0 was installed? How do I install it
directly from the SQL Server Setup CD or do I have to uninstall & then
reinstall SQL Server 7.0 to make use of DTC? Or is there an altogether
different Setup CD for DTC?
This is the first time I am trying to use DTC.
Thanks,
ArpanThere isn't a seperate CD/setup for DTC. I would un-install and
re-install.
ALI

MSDTC!

I have SQL Server 7.0 installed in my Win2K Pro machine. When I
navigate to Start-->SQL Server 7.0-->MSDTC Administrative Console, I
get the "Missing Shortcut" error. Even a search on 'dac.exe' doesn't
yield any result. Does this mean that the DTC console didn't get
installed while SQL Server 7.0 was installed? How do I install it
directly from the SQL Server Setup CD or do I have to uninstall & then
reinstall SQL Server 7.0 to make use of DTC? Or is there an altogether
different Setup CD for DTC?
This is the first time I am trying to use DTC.
Thanks,
ArpanThere isn't a seperate CD/setup for DTC. I would un-install and
re-install.
ALI

MSDTC with Windows 2003 Server

I have installed SQL Server 2000 virtual server on my Windows 2003 Server
Active\Active Cluster. I have installed SQL Server 2000 SP3 but have not
added any databases. But I did not know about the MSDTC step.
What steps do I need to complete to add MSDTC since to the cluster and to
the database configuration?
Thanks,Must install Componant Services. Documentation included will have
information on a clustered vs non-clustered install.
"Joe K." wrote:

> I have installed SQL Server 2000 virtual server on my Windows 2003 Server
> Active\Active Cluster. I have installed SQL Server 2000 SP3 but have not
> added any databases. But I did not know about the MSDTC step.
> What steps do I need to complete to add MSDTC since to the cluster and to
> the database configuration?
> Thanks,

MSDTC with Windows 2003 Server

I have installed SQL Server 2000 virtual server on my Windows 2003 Server
Active\Active Cluster. I have installed SQL Server 2000 SP3 but have not
added any databases. But I did not know about the MSDTC step.
What steps do I need to complete to add MSDTC since to the cluster and to
the database configuration?
Thanks,
Must install Componant Services. Documentation included will have
information on a clustered vs non-clustered install.
"Joe K." wrote:

> I have installed SQL Server 2000 virtual server on my Windows 2003 Server
> Active\Active Cluster. I have installed SQL Server 2000 SP3 but have not
> added any databases. But I did not know about the MSDTC step.
> What steps do I need to complete to add MSDTC since to the cluster and to
> the database configuration?
> Thanks,

MSDTC with Windows 2003 Server

I have installed SQL Server 2000 virtual server on my Windows 2003 Server
Active\Active Cluster. I have installed SQL Server 2000 SP3 but have not
added any databases. But I did not know about the MSDTC step.
What steps do I need to complete to add MSDTC since to the cluster and to
the database configuration?
Thanks,Must install Componant Services. Documentation included will have
information on a clustered vs non-clustered install.
"Joe K." wrote:
> I have installed SQL Server 2000 virtual server on my Windows 2003 Server
> Active\Active Cluster. I have installed SQL Server 2000 SP3 but have not
> added any databases. But I did not know about the MSDTC step.
> What steps do I need to complete to add MSDTC since to the cluster and to
> the database configuration?
> Thanks,

MSDTC with SQL Server 2000

Hi,
I have a three nodes cluster with Win 2003. On that I have four SQL
intances. MSTDC is installed on the Quorum. When a failover happens, the SQL
groups start before MSDTC and that create a problem with the transactions
after. To assure a good fonctionality I have to restart my SQL Servers (Not
Funny). I can't configure a dependencies betwen groups in Cluster
Administrators.
How can avoid a human intervention so that the services start correctly
while a failover ? I means ... to assure the service MSDTC is up before SQL
instances.
This is a known issue and fixed with Windows Server 2003 SP1. Install SP1 on
both nodes
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
"Psa555" <Psa555@.discussions.microsoft.com> wrote in message
news:6043A12C-0923-4389-977F-C8DCBAADCC28@.microsoft.com...
> Hi,
> I have a three nodes cluster with Win 2003. On that I have four SQL
> intances. MSTDC is installed on the Quorum. When a failover happens, the
> SQL
> groups start before MSDTC and that create a problem with the transactions
> after. To assure a good fonctionality I have to restart my SQL Servers
> (Not
> Funny). I can't configure a dependencies betwen groups in Cluster
> Administrators.
> How can avoid a human intervention so that the services start correctly
> while a failover ? I means ... to assure the service MSDTC is up before
> SQL
> instances.
>
|||Also, it is recommended to build MS DTC resource in a Cluster Group
independent from the Quorum or SQL Server Groups.
You receive error messages when you perform a distributed transaction when
you have a SQL Server 2000 virtual server in a Windows Server 2003 clustered
environment
http://support.microsoft.com/default...b;en-us;889706
How to configure Microsoft Distributed Transaction Coordinator on a Windows
Server 2003 cluster
http://support.microsoft.com/kb/301600/
Sincerely,
Anthony Thomas

"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:uEdLa7EyFHA.3812@.TK2MSFTNGP09.phx.gbl...
> This is a known issue and fixed with Windows Server 2003 SP1. Install SP1
on[vbcol=seagreen]
> both nodes
> Cheers,
> Rod
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering Website
> http://www.msmvps.com/clustering - Blog
> http://www.clusterhelp.com - Cluster Training
>
> "Psa555" <Psa555@.discussions.microsoft.com> wrote in message
> news:6043A12C-0923-4389-977F-C8DCBAADCC28@.microsoft.com...
the[vbcol=seagreen]
transactions
>
|||Thanks ... I read about SP1 for Win2003 and that should fix my problem.
Thanks for the hint ...
Best regard ..
"Rodney R. Fournier [MVP]" a écrit :

> This is a known issue and fixed with Windows Server 2003 SP1. Install SP1 on
> both nodes
> Cheers,
> Rod
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering Website
> http://www.msmvps.com/clustering - Blog
> http://www.clusterhelp.com - Cluster Training
>
> "Psa555" <Psa555@.discussions.microsoft.com> wrote in message
> news:6043A12C-0923-4389-977F-C8DCBAADCC28@.microsoft.com...
>
>
|||That's in our plan to move MSDTC on separate group ...
Thanks ...
Best regard ..
"Anthony Thomas" a écrit :

> Also, it is recommended to build MS DTC resource in a Cluster Group
> independent from the Quorum or SQL Server Groups.
> You receive error messages when you perform a distributed transaction when
> you have a SQL Server 2000 virtual server in a Windows Server 2003 clustered
> environment
> http://support.microsoft.com/default...b;en-us;889706
> How to configure Microsoft Distributed Transaction Coordinator on a Windows
> Server 2003 cluster
> http://support.microsoft.com/kb/301600/
> Sincerely,
>
> Anthony Thomas
>
> --
> "Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
> message news:uEdLa7EyFHA.3812@.TK2MSFTNGP09.phx.gbl...
> on
> the
> transactions
>
>

MSDTC w/ Oracle 8i EventID=4156

On June 11th, we changed the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\ MSDTC\MTxOCI registry settings in order to correct the problem of failed ODBC connections to an Oracle 8.1.7 linked server.
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\MTxOC I]
"OracleXaLib"="oraclient8.dll"
"OracleSqlLib"="orasql8.dll"
"OracleOciLib"="oci.dll"
It appeared to fix our problems -- but...
After doing so, we began getting MSDTC EventID 4156 information events in the application log - String message: Session idle timeout over, tearing down the session.
Since making the registry change, 328 of these errors have occurred to date. The first one occurred ~2 hours after making the registry change.
OPENQUERY statements to the Oracle server are now intermittently requiring long access times (minutes) that used to take a split second.
Since making the registry change, 328 of these errors have occurred to date.
Are there any suggestions on how to rectify this problem?
Hello !!
I have the exact same error message. Did you find any resolution for this ?
Mirna.-
"elpepe" wrote:

> On June 11th, we changed the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\ MSDTC\MTxOCI registry settings in order to correct the problem of failed ODBC connections to an Oracle 8.1.7 linked server.
> [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\MTxOC I]
> "OracleXaLib"="oraclient8.dll"
> "OracleSqlLib"="orasql8.dll"
> "OracleOciLib"="oci.dll"
> It appeared to fix our problems -- but...
> After doing so, we began getting MSDTC EventID 4156 information events in the application log - String message: Session idle timeout over, tearing down the session.
> Since making the registry change, 328 of these errors have occurred to date. The first one occurred ~2 hours after making the registry change.
> OPENQUERY statements to the Oracle server are now intermittently requiring long access times (minutes) that used to take a split second.
> Since making the registry change, 328 of these errors have occurred to date.
> Are there any suggestions on how to rectify this problem?
|||below is the likely solution
PRB: MS DTC Event 4156: "Session Idle Timeout Over"
Article ID : 290334
Last Review : February 20, 2002
Revision : 1.0
This article was previously published under Q290334
On this Page
SYMPTOMS
CAUSE
RESOLUTION
REFERENCES
SYMPTOMS
You may see the following entry in the application event log:
String message: Session idle timeout over, tearing down the session.
CAUSE
This message indicates that the connection between a Distributed Transaction Coordinator (DTC) client and Microsoft Distributed Transaction Coordinator (MS DTC) is being torn down due to inactivity.
RESOLUTION
This message is usually just informational and can be ignored. Under normal circumstances, MS DTC tears down inactive connections after 10 minutes of idle time.
REFERENCES
For additional information, click the article numbers below to view the articles in the Microsoft Knowledge Base:
197810 FIX: Upgrading DTC to Close Idle Connections
250987 HOWTO: Reinstall MS DTC for a Nonclustered Windows NT 4.0 Server
279786 HOWTO: Reinstall MS DTC for a Nonclustered Windows 2000 Serve

Quote:

Originally posted by Mirna Da Costa
Hello !!
I have the exact same error message. Did you find any resolution for this ?
Mirna.-
"elpepe" wrote:

> On June 11th, we changed the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\ MSDTC\MTxOCI registry settings in order to correct the problem of failed ODBC connections to an Oracle 8.1.7 linked server.
> [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\MTxOC I]
> "OracleXaLib"="oraclient8.dll"
> "OracleSqlLib"="orasql8.dll"
> "OracleOciLib"="oci.dll"
> It appeared to fix our problems -- but...
> After doing so, we began getting MSDTC EventID 4156 information events in the application log - String message: Session idle timeout over, tearing down the session.
> Since making the registry change, 328 of these errors have occurred to date. The first one occurred ~2 hours after making the registry change.
> OPENQUERY statements to the Oracle server are now intermittently requiring long access times (minutes) that used to take a split second.
> Since making the registry change, 328 of these errors have occurred to date.
> Are there any suggestions on how to rectify this problem?

MSDTC w/ Oracle 8i EventID=4156

On June 11th, we changed the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\ MSDTC\MT
xOCI registry settings in order to correct the problem of failed ODBC connec
tions to an Oracle 8.1.7 linked server.
& #91;HKEY_LOCAL_MACHINE\SOFTWARE\Microsof
t\MSDTC\MTxOCI]
"OracleXaLib"="oraclient8.dll"
"OracleSqlLib"="orasql8.dll"
"OracleOciLib"="oci.dll"
It appeared to fix our problems -- but...
After doing so, we began getting MSDTC EventID 4156 information events in th
e application log - String message: Session idle timeout over, tearing down
the session.
Since making the registry change, 328 of these errors have occurred to date.
The first one occurred ~2 hours after making the registry change.
OPENQUERY statements to the Oracle server are now intermittently requiring l
ong access times (minutes) that used to take a split second.
Since making the registry change, 328 of these errors have occurred to date.
Are there any suggestions on how to rectify this problem?Hello !!
I have the exact same error message. Did you find any resolution for this '
Mirna.-
"elpepe" wrote:

> On June 11th, we changed the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\ MSDTC\
MTxOCI registry settings in order to correct the problem of failed ODBC conn
ections to an Oracle 8.1.7 linked server.
> & #91;HKEY_LOCAL_MACHINE\SOFTWARE\Microsof
t\MSDTC\MTxOCI]
> "OracleXaLib"="oraclient8.dll"
> "OracleSqlLib"="orasql8.dll"
> "OracleOciLib"="oci.dll"
> It appeared to fix our problems -- but...
> After doing so, we began getting MSDTC EventID 4156 information events in
the application log - String message: Session idle timeout over, tearing do
wn the session.
> Since making the registry change, 328 of these errors have occurred to dat
e. The first one occurred ~2 hours after making the registry change.
> OPENQUERY statements to the Oracle server are now intermittently requiring
long access times (minutes) that used to take a split second.
> Since making the registry change, 328 of these errors have occurred to dat
e.
> Are there any suggestions on how to rectify this problem?|||below is the likely solution
PRB: MS DTC Event 4156: "Session Idle Timeout Over"
Article ID : 290334
Last Review : February 20, 2002
Revision : 1.0
This article was previously published under Q290334
On this Page
SYMPTOMS
CAUSE
RESOLUTION
REFERENCES
SYMPTOMS
You may see the following entry in the application event log:
String message: Session idle timeout over, tearing down the session.
CAUSE
This message indicates that the connection between a Distributed
Transaction Coordinator (DTC) client and Microsoft Distributed
Transaction Coordinator (MS DTC) is being torn down due to inactivity.
RESOLUTION
This message is usually just informational and can be ignored. Under
normal circumstances, MS DTC tears down inactive connections after 10
minutes of idle time.
REFERENCES
For additional information, click the article numbers below to view the
articles in the Microsoft Knowledge Base:
197810 FIX: Upgrading DTC to Close Idle Connections
250987 HOWTO: Reinstall MS DTC for a Nonclustered Windows NT 4.0 Server
279786 HOWTO: Reinstall MS DTC for a Nonclustered Windows 2000 Serve
Mirna Da Costa wrote:[vbcol=seagreen]
> *Hello !!
> I have the exact same error message. Did you find any resolution for
> this '
> Mirna.-
>
> "elpepe" wrote:
>
> MSDTC\MTxOCI registry settings in order to correct the problem of
> failed ODBC connections to an Oracle 8.1.7 linked server.
> events in the application log - String message: Session idle timeout
> over, tearing down the session.
> to date. The first one occurred ~2 hours after making the registry
> change.
> requiring long access times (minutes) that used to take a split
> second.
> to date.
acsekar
---
Posted via http://www.mcse.ms
---
View this thread: http://www.mcse.ms/message808237.html

MSDTC Unavailable Windows 2003

Hi
I have a VB6 windows app which calls a VB6 COM+ application (both running on
machine CHOPGBCOM001) which in turn calls a stored procedure on a remote
machine CANSUR001 but it keeps failing with error "MSDTC on server
'CANSUR001' is unavailable". The COM+ application is configured with
Transaction Support=Required and isolation level set to the default of
serialised (the COM+
app changes it to Read Committed)
* CHOPCOM001 and CANSUR001 both have Windows 2003 SP1 and CANSUR001
is running SQL Server 2000.
* MSDTC is started on both machines
* I have Installed/enabled windows components "Enable network COM+ access"
and "Enable network DTC access" on both machines
* I have configured MSDTC in Component services to use "Network DTC access",
allow outbound and inbound on "Transaction Manager Communication" and set
to "No authentication required"
* Both machines are in the same domain
* No local firewalls are installed
* I've rebooted both machines but same result
* CANSUR001 is NOT part of a cluster
* I've tried running
BEGIN distributed transaction
select * from cansur001.leisure.dbo.member
from SQL Analyser in CHOPCOM001 but get the same result
Any help would be gratefully received
God Bless
RonanMSDTC is turned off by default in Windows 2003. Have you enabled it in
Windows?
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Ronan" <Ronan@.discussions.microsoft.com> wrote in message
news:F77ECB86-A5E1-42CC-9D02-51CEBFDED779@.microsoft.com...
> Hi
> I have a VB6 windows app which calls a VB6 COM+ application (both running
> on
> machine CHOPGBCOM001) which in turn calls a stored procedure on a remote
> machine CANSUR001 but it keeps failing with error "MSDTC on server
> 'CANSUR001' is unavailable". The COM+ application is configured with
> Transaction Support=Required and isolation level set to the default of
> serialised (the COM+
> app changes it to Read Committed)
>
> * CHOPCOM001 and CANSUR001 both have Windows 2003 SP1 and CANSUR001
> is running SQL Server 2000.
> * MSDTC is started on both machines
> * I have Installed/enabled windows components "Enable network COM+ access"
> and "Enable network DTC access" on both machines
> * I have configured MSDTC in Component services to use "Network DTC
> access",
> allow outbound and inbound on "Transaction Manager Communication" and
> set
> to "No authentication required"
> * Both machines are in the same domain
> * No local firewalls are installed
> * I've rebooted both machines but same result
> * CANSUR001 is NOT part of a cluster
> * I've tried running
> BEGIN distributed transaction
> select * from cansur001.leisure.dbo.member
> from SQL Analyser in CHOPCOM001 but get the same result
>
> Any help would be gratefully received
> God Bless
> Ronan|||Distributed Transaction Coordinator service is enabled and started on both
machines
--
Ronan
"Ronan" wrote:

> Hi
> I have a VB6 windows app which calls a VB6 COM+ application (both running
on
> machine CHOPGBCOM001) which in turn calls a stored procedure on a remote
> machine CANSUR001 but it keeps failing with error "MSDTC on server
> 'CANSUR001' is unavailable". The COM+ application is configured with
> Transaction Support=Required and isolation level set to the default of
> serialised (the COM+
> app changes it to Read Committed)
>
> * CHOPCOM001 and CANSUR001 both have Windows 2003 SP1 and CANSUR001
> is running SQL Server 2000.
> * MSDTC is started on both machines
> * I have Installed/enabled windows components "Enable network COM+ access"
> and "Enable network DTC access" on both machines
> * I have configured MSDTC in Component services to use "Network DTC access
",
> allow outbound and inbound on "Transaction Manager Communication" and s
et
> to "No authentication required"
> * Both machines are in the same domain
> * No local firewalls are installed
> * I've rebooted both machines but same result
> * CANSUR001 is NOT part of a cluster
> * I've tried running
> BEGIN distributed transaction
> select * from cansur001.leisure.dbo.member
> from SQL Analyser in CHOPCOM001 but get the same result
>
> Any help would be gratefully received
> God Bless
> Ronan|||One thing I forgot to mention is that the remote server CANSUR001 is a
Domain Contoller, anyone come across problems running distributed
transactions against
servers which are also doiman controllers?
Ronan
"Ronan" wrote:
> Distributed Transaction Coordinator service is enabled and started on both
> machines
> --
> Ronan
>
> "Ronan" wrote:
>

MSDTC unavailable / JoinTransaction returned 0x8004d01c

Hi! We have 2 database server. 1 at our company, while the other with a web
hosting company.
We wrote stored procedures to update data from tables in our company's
server to the web hosting company's server. Out of 13 of these stored
procedures, 5 failed, giving me the error message that looks like the one
below,
Server: Msg 8501, Level 16, State 1, Procedure sp_ExportCalendar, Line 9
MSDTC on server 'ORION' is unavailable.
Server: Msg 7391, Level 16, State 1, Procedure sp_ExportCalendar, Line 9
The operation could not be performed because the OLE DB provider 'SQLOLEDB'
was unable to begin a distributed transaction.
OLE DB error trace [OLE/DB Provider 'SQLOLEDB'
ITransactionJoin::JoinTransaction returned 0x8004d01c].
Can anyone help me explain what the error mean? I can post stored procedure
if required. Thanks.Hi this is one of the stored procedures that doesn't work. tsp is my user
name, server name.
CREATE PROCEDURE sp_ExportSysConf AS
BEGIN DISTRIBUTED TRANSACTION
IF EXISTS (SELECT * FROM [SysConf])
BEGIN
--Step1: Remove records that do not exist in CIM
DELETE FROM [tsp].[tsp].[tsp].[SysConf]
FROM [tsp].[tsp].[tsp].[SysConf] as C2
WHERE NOT EXISTS (SELECT [C1].[ConfName], [C1].[ConfValue],
[C2].[LastUpdate] FROM [SMSBASE].[DBO].[SysConf] as [C1] where
[C1].[ConfName] = [C2].[ConfName] and [C1].[ConfValue] = [C2].[ConfValue])
IF (@.@.error = 0)
BEGIN
-- no error --> Step 2: Insert new records from CIM
INSERT [tsp].[tsp].[tsp].[SysConf]([ConfName], [ConfValue])
SELECT [ConfName],[ConfValue]
FROM [SMSBASE].[DBO].[SysConf] as C2
WHERE NOT EXISTS (SELECT * FROM [tsp].[tsp].[tsp].[SysConf] as [C1]
where [C1].[ConfName] = [C2].[ConfName] and [C1].[ConfValue] =
[C2].[ConfValue])
IF (@.@.error = 0)
-- no error -> commit
COMMIT TRANSACTION
ELSE
-- error occurred -> rollback
ROLLBACK TRANSACTION
END
ELSE ROLLBACK TRANSACTION
END
ELSE ROLLBACK TRANSACTION
GO

MSDTC Unavailable

Hi
I have a server running Windows 2000 SP4 (PROD_COM1) running an EXE which
calls a COM+ component which in turn calls another COM+ component ( data
access module) which in turn calls a stored procedure on another machine
CANPAD001 (Win2K3 SP1) but the query fails each time with a message 'MSDTC o
n
server 'CANPAD001' is unavailable'. I've checked and MSDTC is started on bot
h
PROD_COM1 and CANPAD001. I've used the testing tool DTCPing and it works ok
in both directions. DTCtester fails with the same message as above. On the
Win2K3 machine (CANPAD001) I've set the MSDTC setting in component services
to "allow inbound" and "allow outound" and "no authentication required". I'v
e
run a BEGIN DISTRIBUTED Query in Query analyser from PROD_COM1 (using the sa
account) to CANPAD001 but again it gives the same error.
Is this perhaps a Win2K to Win2K3 MSDTC configuration error?
Any help would be much appreciated
RonanI forgot to mention there is no firewall on either machine and all the ports
are open.
I can ping CANPAD001 from PROD_COM1 so that means WINS/DNS works ok.
Ronan
"Ronan" wrote:

> Hi
> I have a server running Windows 2000 SP4 (PROD_COM1) running an EXE which
> calls a COM+ component which in turn calls another COM+ component ( data
> access module) which in turn calls a stored procedure on another machine
> CANPAD001 (Win2K3 SP1) but the query fails each time with a message 'MSDTC
on
> server 'CANPAD001' is unavailable'. I've checked and MSDTC is started on b
oth
> PROD_COM1 and CANPAD001. I've used the testing tool DTCPing and it works o
k
> in both directions. DTCtester fails with the same message as above. On th
e
> Win2K3 machine (CANPAD001) I've set the MSDTC setting in component service
s
> to "allow inbound" and "allow outound" and "no authentication required". I
've
> run a BEGIN DISTRIBUTED Query in Query analyser from PROD_COM1 (using the
sa
> account) to CANPAD001 but again it gives the same error.
> Is this perhaps a Win2K to Win2K3 MSDTC configuration error?
> Any help would be much appreciated
> --
> Ronan|||Also in the SQL Server logs for CANPAD001 I have the following message.
CANPAD001 is not part of a a cluster.
"Failed to obtain TransactionDispenserInterface: Result Code = 0x8004d01b"
Ronan
"Ronan" wrote:
[vbcol=seagreen]
> I forgot to mention there is no firewall on either machine and all the por
ts
> are open.
> I can ping CANPAD001 from PROD_COM1 so that means WINS/DNS works ok.
>
> --
> Ronan
>
> "Ronan" wrote:
>

MSDTC Unavailable

Hi
I have a server running Windows 2000 SP4 (PROD_COM1) running an EXE which
calls a COM+ component which in turn calls another COM+ component ( data
access module) which in turn calls a stored procedure on another machine
CANPAD001 (Win2K3 SP1) but the query fails each time with a message 'MSDTC on
server 'CANPAD001' is unavailable'. I've checked and MSDTC is started on both
PROD_COM1 and CANPAD001. I've used the testing tool DTCPing and it works ok
in both directions. DTCtester fails with the same message as above. On the
Win2K3 machine (CANPAD001) I've set the MSDTC setting in component services
to "allow inbound" and "allow outound" and "no authentication required". I've
run a BEGIN DISTRIBUTED Query in Query analyser from PROD_COM1 (using the sa
account) to CANPAD001 but again it gives the same error.
Is this perhaps a Win2K to Win2K3 MSDTC configuration error?
Any help would be much appreciated
Ronan
I forgot to mention there is no firewall on either machine and all the ports
are open.
I can ping CANPAD001 from PROD_COM1 so that means WINS/DNS works ok.
Ronan
"Ronan" wrote:

> Hi
> I have a server running Windows 2000 SP4 (PROD_COM1) running an EXE which
> calls a COM+ component which in turn calls another COM+ component ( data
> access module) which in turn calls a stored procedure on another machine
> CANPAD001 (Win2K3 SP1) but the query fails each time with a message 'MSDTC on
> server 'CANPAD001' is unavailable'. I've checked and MSDTC is started on both
> PROD_COM1 and CANPAD001. I've used the testing tool DTCPing and it works ok
> in both directions. DTCtester fails with the same message as above. On the
> Win2K3 machine (CANPAD001) I've set the MSDTC setting in component services
> to "allow inbound" and "allow outound" and "no authentication required". I've
> run a BEGIN DISTRIBUTED Query in Query analyser from PROD_COM1 (using the sa
> account) to CANPAD001 but again it gives the same error.
> Is this perhaps a Win2K to Win2K3 MSDTC configuration error?
> Any help would be much appreciated
> --
> Ronan
|||Also in the SQL Server logs for CANPAD001 I have the following message.
CANPAD001 is not part of a a cluster.
"Failed to obtain TransactionDispenserInterface: Result Code = 0x8004d01b"
Ronan
"Ronan" wrote:
[vbcol=seagreen]
> I forgot to mention there is no firewall on either machine and all the ports
> are open.
> I can ping CANPAD001 from PROD_COM1 so that means WINS/DNS works ok.
>
> --
> Ronan
>
> "Ronan" wrote:

MSDTC Unavailable

Hi
I have a server running Windows 2000 SP4 (PROD_COM1) running an EXE which
calls a COM+ component which in turn calls another COM+ component ( data
access module) which in turn calls a stored procedure on another machine
CANPAD001 (Win2K3 SP1) but the query fails each time with a message 'MSDTC on
server 'CANPAD001' is unavailable'. I've checked and MSDTC is started on both
PROD_COM1 and CANPAD001. I've used the testing tool DTCPing and it works ok
in both directions. DTCtester fails with the same message as above. On the
Win2K3 machine (CANPAD001) I've set the MSDTC setting in component services
to "allow inbound" and "allow outound" and "no authentication required". I've
run a BEGIN DISTRIBUTED Query in Query analyser from PROD_COM1 (using the sa
account) to CANPAD001 but again it gives the same error.
Is this perhaps a Win2K to Win2K3 MSDTC configuration error?
Any help would be much appreciated
--
RonanI forgot to mention there is no firewall on either machine and all the ports
are open.
I can ping CANPAD001 from PROD_COM1 so that means WINS/DNS works ok.
Ronan
"Ronan" wrote:
> Hi
> I have a server running Windows 2000 SP4 (PROD_COM1) running an EXE which
> calls a COM+ component which in turn calls another COM+ component ( data
> access module) which in turn calls a stored procedure on another machine
> CANPAD001 (Win2K3 SP1) but the query fails each time with a message 'MSDTC on
> server 'CANPAD001' is unavailable'. I've checked and MSDTC is started on both
> PROD_COM1 and CANPAD001. I've used the testing tool DTCPing and it works ok
> in both directions. DTCtester fails with the same message as above. On the
> Win2K3 machine (CANPAD001) I've set the MSDTC setting in component services
> to "allow inbound" and "allow outound" and "no authentication required". I've
> run a BEGIN DISTRIBUTED Query in Query analyser from PROD_COM1 (using the sa
> account) to CANPAD001 but again it gives the same error.
> Is this perhaps a Win2K to Win2K3 MSDTC configuration error?
> Any help would be much appreciated
> --
> Ronan|||Also in the SQL Server logs for CANPAD001 I have the following message.
CANPAD001 is not part of a a cluster.
"Failed to obtain TransactionDispenserInterface: Result Code = 0x8004d01b"
Ronan
"Ronan" wrote:
> I forgot to mention there is no firewall on either machine and all the ports
> are open.
> I can ping CANPAD001 from PROD_COM1 so that means WINS/DNS works ok.
>
> --
> Ronan
>
> "Ronan" wrote:
> >
> > Hi
> >
> > I have a server running Windows 2000 SP4 (PROD_COM1) running an EXE which
> > calls a COM+ component which in turn calls another COM+ component ( data
> > access module) which in turn calls a stored procedure on another machine
> > CANPAD001 (Win2K3 SP1) but the query fails each time with a message 'MSDTC on
> > server 'CANPAD001' is unavailable'. I've checked and MSDTC is started on both
> > PROD_COM1 and CANPAD001. I've used the testing tool DTCPing and it works ok
> > in both directions. DTCtester fails with the same message as above. On the
> > Win2K3 machine (CANPAD001) I've set the MSDTC setting in component services
> > to "allow inbound" and "allow outound" and "no authentication required". I've
> > run a BEGIN DISTRIBUTED Query in Query analyser from PROD_COM1 (using the sa
> > account) to CANPAD001 but again it gives the same error.
> > Is this perhaps a Win2K to Win2K3 MSDTC configuration error?
> >
> > Any help would be much appreciated
> >
> > --
> > Ronan