Commerce Server General - New transaction cannot enlist in the specified transaction coordinator. CS2k2 basket.S

Author

New transaction cannot enlist in the specified transaction coordinator. CS2k2 basket.S

jhalliday

2005-01-12, 5:53 pm

Hello all,

I have read several threads here regarding this issue or similar
issues, and unfortunately have not found a solution. In my particular
situation, nothing has changed in my environment that I can
specifically pin down. It seems that this error started appearing out
of nowhere.

I get the following error and stacktrace when calling
"basket.SaveAsOrder()":

---------BEGIN ERROR & STACK TRACE--------------------
New transaction cannot enlist in the specified transaction coordinator.

Description: An unhandled exception occurred during the execution of
the current web request. Please review the stack trace for more
information about the error and where it originated in the code.

Exception Details: System.Runtime.InteropServices.COMException: New
transaction cannot enlist in the specified transaction coordinator.

[COMException (0x8004d00a): New transaction cannot enlist in the
specified transaction coordinator. ]
ADODB.ConnectionClass.Open(String ConnectionString, String UserID,
String Password, Int32 Options) +0
Microsoft.CommerceServer.Internal.Common.DBUtil.init(String&
connection_string)

[CommerceException: Could not connect to datasource]

Microsoft.CommerceServer.Internal.Common.Util.ThrowCommerceException(String
message, Exception inner, String source)
Microsoft.CommerceServer.Internal.Common.DBUtil.init(String&
connection_string)

Microsoft.CommerceServer.Interop.Orders. PrivateOrderGroupMtsTxHelperFreeThreaded
.MtsSetup(String
in_User, String in_dsn, IGenID in_GenID, Object& in_out_OrderGroupData,
Int16& in_out_exists_in_databse)

Microsoft.CommerceServer.Interop.Orders. PrivateOrderGroupMtsTxHelperFreeThreaded
.SaveAsOrderHelper(Object
in_User, Object in_dsn, Object in_GenID, Object& in_out_OrderGroupData,
Object& loaded_from, Object& in_out_exists_in_databse, Object
SavePrefix, Object& out_vtOutTrackingNumber)

[CommerceException: SaveAsOrderHelper Failed.]

System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage
reqMsg, IMessage retMsg) +264
System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData&
msgData, Int32 type) +877

Microsoft.CommerceServer.Interop.Orders. PrivateOrderGroupMtsTxHelperFreeThreaded
.SaveAsOrderHelper(Object
in_User, Object in_dsn, Object in_GenID, Object& in_out_OrderGroupData,
Object& loaded_from, Object& in_out_exists_in_databse, Object
SavePrefix, Object& out_vtOutTrackingNumber)

Microsoft.CommerceServer.Interop.Orders.OrderGroupFreeThreaded.SaveAsOrder(Object&
vtOutTrackingNumber)

[CommerceException: SaveAsOrder Failed.]

Microsoft.CommerceServer.Internal.Common.Util.ThrowCommerceException(String
message, Exception inner, String source)

Microsoft.CommerceServer.Interop.Orders.OrderGroupFreeThreaded.SaveAsOrder(Object&
vtOutTrackingNumber)
Microsoft.CommerceServer.Runtime.Orders.Basket.SaveAsOrder()

[CommerceOrderSystemException: Failed to save basket as an order.]
Microsoft.CommerceServer.Runtime.Orders.Basket.SaveAsOrder()
NEJOnlineSite.Controls.AcceptOrder.btnAccept_Click(Object sender,
EventArgs e) in
c:\inetpub\wwwroot\XYZOnlineSite\Control
s\AcceptOrder.ascx.cs:112
System.Web.UI.WebControls.Button.OnClick(EventArgs e)

System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String
eventArgument)
System.Web.UI.Page. RaisePostBackEvent(IPostBackEventHandler

sourceControl, String eventArgument)
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
System.Web.UI.Page.ProcessRequestMain()

-----------END ERROR & STACK TRACE---------------------------

I am running CS2002 and SQL Server 2000 on a Win 2k3 box, and the web
development (web server) is being done on a WinXP Pro box.

I have tried various DTC related troubleshooting tactics that I have
read about on other threads:
1. Tried DTCPing. No communication problems. The tool worked as
expected.
2. Tried opening up ports through Component Services
3. Tried editting registry and adding the RpcSecurity related key to
disable security on rpcs.

No luck on any of these tactics. I'm feeling pretty stuck right now,
so any hand would be fantasic.

Thanks again,
Jon

Zoe Hart [MVP]

2005-01-13, 7:47 am

Jon,

I had this same error when setting up a Windows 2003 environment. I didn't
have the WinXP box in the mix, but maybe the problem/solution is still the
same. The answer in my case was to ensure that both Network COM+ Access and
Network DTC Access were enabled on both the web server and data server. The
steps to do this are:

Add Remove Programs. Add Remove Windows Components. Application Server.
Details. and check "Enable network COM+ access" and "Enable network DTC
access".

Hope that helps.

Zoe

"jhalliday" <jhalliday@gmail.com> wrote in message
news:1105567531.116875.69650@z14g2000cwz.googlegroups.com...
> Hello all,
>
> I have read several threads here regarding this issue or similar
> issues, and unfortunately have not found a solution. In my particular
> situation, nothing has changed in my environment that I can
> specifically pin down. It seems that this error started appearing out
> of nowhere.
>
> I get the following error and stacktrace when calling
> "basket.SaveAsOrder()":
>
>
> ---------BEGIN ERROR & STACK TRACE--------------------
> New transaction cannot enlist in the specified transaction coordinator.
>
> Description: An unhandled exception occurred during the execution of
> the current web request. Please review the stack trace for more
> information about the error and where it originated in the code.
>
> Exception Details: System.Runtime.InteropServices.COMException: New
> transaction cannot enlist in the specified transaction coordinator.
>
>
> [COMException (0x8004d00a): New transaction cannot enlist in the
> specified transaction coordinator. ]
> ADODB.ConnectionClass.Open(String ConnectionString, String UserID,
> String Password, Int32 Options) +0
> Microsoft.CommerceServer.Internal.Common.DBUtil.init(String&
> connection_string)
>
> [CommerceException: Could not connect to datasource]
>
>
Microsoft.CommerceServer.Internal.Common.Util. ThrowCommerceException(String
> message, Exception inner, String source)
> Microsoft.CommerceServer.Internal.Common.DBUtil.init(String&
> connection_string)
>
>
Microsoft.CommerceServer.Interop.Orders.PrivateOrderGroupMtsTxHelperFreeThre
aded.MtsSetup(String
> in_User, String in_dsn, IGenID in_GenID, Object& in_out_OrderGroupData,
> Int16& in_out_exists_in_databse)
>
>
Microsoft.CommerceServer.Interop.Orders.PrivateOrderGroupMtsTxHelperFreeThre
aded. SaveAsOrderHelper(Object

> in_User, Object in_dsn, Object in_GenID, Object& in_out_OrderGroupData,
> Object& loaded_from, Object& in_out_exists_in_databse, Object
> SavePrefix, Object& out_vtOutTrackingNumber)
>
> [CommerceException: SaveAsOrderHelper Failed.]
>
> System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage
> reqMsg, IMessage retMsg) +264
> System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData&
> msgData, Int32 type) +877
>
>
Microsoft.CommerceServer.Interop.Orders.PrivateOrderGroupMtsTxHelperFreeThre
aded. SaveAsOrderHelper(Object

> in_User, Object in_dsn, Object in_GenID, Object& in_out_OrderGroupData,
> Object& loaded_from, Object& in_out_exists_in_databse, Object
> SavePrefix, Object& out_vtOutTrackingNumber)
>
>
Microsoft.CommerceServer.Interop.Orders.OrderGroupFreeThreaded.SaveAsOrder(O
bject&
> vtOutTrackingNumber)
>
> [CommerceException: SaveAsOrder Failed.]
>
>
Microsoft.CommerceServer.Internal.Common.Util. ThrowCommerceException(String
> message, Exception inner, String source)
>
>
Microsoft.CommerceServer.Interop.Orders.OrderGroupFreeThreaded.SaveAsOrder(O
bject&
> vtOutTrackingNumber)
> Microsoft.CommerceServer.Runtime.Orders.Basket.SaveAsOrder()
>
> [CommerceOrderSystemException: Failed to save basket as an order.]
> Microsoft.CommerceServer.Runtime.Orders.Basket.SaveAsOrder()
> NEJOnlineSite.Controls.AcceptOrder.btnAccept_Click(Object sender,
> EventArgs e) in
> c:\inetpub\wwwroot\XYZOnlineSite\Control
s\AcceptOrder.ascx.cs:112
> System.Web.UI.WebControls.Button.OnClick(EventArgs e)
>
>
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePo
stBackEvent(String
> eventArgument)
> System.Web.UI.Page. RaisePostBackEvent(IPostBackEventHandler

> sourceControl, String eventArgument)
> System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
> System.Web.UI.Page.ProcessRequestMain()
>
>
> -----------END ERROR & STACK TRACE---------------------------
>
> I am running CS2002 and SQL Server 2000 on a Win 2k3 box, and the web
> development (web server) is being done on a WinXP Pro box.
>
> I have tried various DTC related troubleshooting tactics that I have
> read about on other threads:
> 1. Tried DTCPing. No communication problems. The tool worked as
> expected.
> 2. Tried opening up ports through Component Services
> 3. Tried editting registry and adding the RpcSecurity related key to
> disable security on rpcs.
>
> No luck on any of these tactics. I'm feeling pretty stuck right now,
> so any hand would be fantasic.
>
> Thanks again,
> Jon
>

jhalliday

2005-01-13, 5:51 pm

Zoe,

Thanks for responding. I did just go and confirm that these were
enabled. If it helps any, a colleague of mine is running the same
setup - A Windows XP local web server connected to the same Win2k3
commerce/database server as me. He isn't currently having any problems
with his setup, which leads me to believe it's something on my XP box
and not Win2k3 box. Any other possible ideas would be greatly
appreciated as I'm pretty much spinning my wheels at the moment.

--Jon

Nihit Kaul [MSFT]

2005-01-13, 5:51 pm

Hi Jon,

Have you tried DTCPing?

You should read and try out the steps listed in the followng KB article to
debug this issue:
http://support.microsoft.com/defaul...kb;EN-US;306843

Thanks,

Nihit Kaul[MSFT]
Commerce Server
http://blogs.msdn.com/nihitk

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

--------------------
From: "jhalliday" <jhalliday@gmail.com>
Newsgroups: microsoft.public.commerceserver.general
Subject: Re: New transaction cannot enlist in the specified transaction
coordinator. CS2k2 basket.SaveAsOrder()
Date: 13 Jan 2005 06:08:45 -0800
Organization: http://groups.google.com
Lines: 12
Message-ID: <1105625325.191993.198210@c13g2000cwb.googlegroups.com>
References: <1105567531.116875.69650@z14g2000cwz.googlegroups.com>
<u8wxSMX#EHA.2112@TK2MSFTNGP14.phx.gbl>
NNTP-Posting-Host: 63.170.158.133
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1105625329 30280 127.0.0.1 (13 Jan 2005
14:08:49 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 13 Jan 2005 14:08:49 +0000 (UTC)
In-Reply-To: <u8wxSMX#EHA.2112@TK2MSFTNGP14.phx.gbl>
User-Agent: G2/0.2
Complaints-To: groups-abuse@google.com
Injection-Info: c13g2000cwb.googlegroups.com; posting-host=63.170.158.133;
posting- account=3li2HA0AAADm26Rp7c1lqMZXerkuEtLT

Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTFEED02.phx.gbl!tornado.fas
twebnet.it!tiscali!newsfeed1.ip.tiscali.net!news.maxwell.syr.edu!postnews.go
ogle.com!c13g2000cwb.googlegroups.com!not-for-mail
Xref: cpmsftngxa10.phx.gbl microsoft.public.commerceserver.general:15435
X-Tomcat-NG: microsoft.public.commerceserver.general

Zoe,

Thanks for responding. I did just go and confirm that these were
enabled. If it helps any, a colleague of mine is running the same
setup - A Windows XP local web server connected to the same Win2k3
commerce/database server as me. He isn't currently having any problems
with his setup, which leads me to believe it's something on my XP box
and not Win2k3 box. Any other possible ideas would be greatly
appreciated as I'm pretty much spinning my wheels at the moment.

--Jon

jhalliday

2005-01-14, 5:50 pm

I did end up solving the issue - it ended up being an obscure active
directory problem that was not necessarily Commerce Server related. In
the end I had to change my computer name to re-establish communication
from the Commerce Server box to my Web Server.

Thanks for all your help guys - your suggestions are what lead me to
start looking down the box-to-box communication avenue.

--Jon