Windows error 0x8004D01B, -2147168229

Detailed Error Information

XACT_E_TMNOTAVAILABLE[1]

MessageThe Transaction Manager is not available.
Declared inwinerror.h

HRESULT analysis[2]

FlagsSeverityFailure
Reserved (R)false
OriginMicrosoft
NTSTATUSfalse
Reserved (X)false
FacilityCode4 (0x004)
NameFACILITY_ITF[2][1]
DescriptionThe source of the error code is COM/OLE Interface management.[2][1]
Error Code53275 (0xd01b)

Questions

11votes
3answers

Why does the SSIS Runtime fail to start the distributed transaction?

While creating an SSIS package for SQL Server 2008 i run into the following error: > Error: The SSIS Runtime has failed to start the distributed transaction due to error 0x8004D01B "The Transaction Manager is not available.". The DTC transaction failed to start. This could occur because the MSDTC Service [...] read more
sql-server
ssis
msdtc
2votes
2answers

MSDTC fails for self-hosted NServiceBus ASP.NET endpoints but not other processes

I have a Windows 2008 R2 server that hosts many back end NServiceBus endpoints. All of the services that rely on the NServiceBus.Host.exe host (installed as Windows Services) are able to interact with MSDTC perfectly, averaging a small handful of concurrent distributed transactions throughout the day. There are 2 small [...] read more
asp.net
.net
transactions
nservicebus
msdtc
1vote
1answer

NServiceBus unable to receive message

I'm following the NServiceBus getting started guide (version 5) and I get the below error. When the client sends a command to the server, the server has issues to receive the message. The code is okay, because the exact same code on another machine is working. So something is missing [...] read more
c#
nservicebus
nservicebus5
1vote
0answers

Transaction Manager Is Not Available

i am using TransactionScope Class provided by .Net However when i try to open connection it throws below exception. {System.Runtime.InteropServices.COMException (0x8004D01B): The Transaction Manager is not available. (Exception from HRESULT: 0x8004D01B) Here is my code.. using (TransactionScope scope = new TransactionScope()) { using (OleDbConnection connection1 = new OleDbConnection("Provider=MSDAORA.1;User ID=oratest2;Password=oratest2;Data Source=dr;Persist [...] read more
c#
.net
transactionscope
1vote
0answers

Why does my TransactionScope not work?

I have code that looks like this: using (TransactionScope tsTransScope = new TransactionScope()) { bcAdvertiser.SaveToTraffic(); bcAdvertiser.SaveToDb(); tsTransScope.Complete(); } The moment I do anything with the database, like open a connection, I get this error: {System.Runtime.InteropServices.COMException (0x8004D01B): The Transaction Manager is not available. (Exception from HRESULT: 0x8004D01B) at System.Transactions.Oletx.IDtcProxyShimFactory.ConnectToProxy(String nodeName, Guid [...] read more
c#
.net
database
msdtc
1vote
3answers

Has anyone installed NServiceBus onto a Microsoft clustered server?

Update: Ok, after getting past the fact that I did not have MSDTC set up as a cluster resource (doh!), I was able to run my program and all appeared well, but I was not able to successfully send messages to it. After digging I found that while the private [...] read more
nservicebus
cluster-computing
windows-clustering
1vote
2answers

Oracle Transaction under MS SSIS

I'm trying to get transactions working under SSIS (SQL Server Integration Services 2005) and Oracle with no luck. I'm using Oracle 10g. I have created a Sequence Container, set its TransactionOption to "Required" and put inside it a DataFlow Task with TransactionOption = "Supported". The server running SSIS has the [...] read more
sql-server
oracle
ssis
transactions
0votes
0answers

Need Help. Why does the SSIS Runtime fail to start the distributed transaction?

Some days ago I decided to reinstall Windows 10 and all my development tool like latest version of SQL Server 2017 and Visual Studio 2017 Professional. I also installed SQL Server Data Tool to get Business intelligence project templates like Integration services and Analysis services. Everything seems alright until I [...] read more
sql-server
visual-studio
ssis
msdtc
0votes
0answers

MSDTC.exe terminating unexpectedly everytime I run a simple code to do a distributed transaction

I am trying a very simple distributed transaction on Windows 10 PC, but MSDTC.exe keeps dying every time I run the code. I've configured everything for it from giving authorization to Network Service (User) to the folders that are related to MSDTC (dlls involved with it, app running the distributed [...] read more
oledb
distributed
msdtc
xa
0votes
0answers

SSIS: Making an Informix transaction local doesn't work

For a single SSIS task I'm trying to make its transaction local. To simplify things, I'm trying to do it like this: * create the new package * create just one Execute SQL Task * inside that task I delete some rows from destination table and issue a ROLLBACK: DELETE [...] read more
ssis
informix
0votes
1answer

TSQL SQL 2000 stored proc cursor

I'm new to this board. I have been driving myself crazy trying to find the answer to my problem. I created some TSQL code that executes some dynamic SQL in a cursor within a stored proc. The cursor fetches some data from table x, builds a query based data retrieved [...] read more
tsql

Comments

Leave a comment

(plain text only)

Sources

  1. winerror.h from Windows SDK 10.0.14393.0
  2. https://msdn.microsoft.com/en-us/library/cc231198.aspx

User contributions licensed under CC BY-SA 3.0