Hi,

We recently reconfigured our commerce server 2007 environment.  Our
webserver is no longer in the same domain as the SQL server and has to go
thru a firewall.  Normal SQL is fine, however, when we call
Basket.SaveAsOrder we get the following error.  Clearly this is the pipeline
trying to call a COM+ call on the SQL Server to begin a remote transaction.
We have played with all The DTC settings  without any luck.  Anyone have any
thoughts?


Source File:
 c:\Inetpub\wwwroot\isg\App_Code\RetailEx
tensions\Components\OrderManagement\
TransactionContext.cs    Line: 1975
Stack Trace:

[COMException (0x8004e00f): COM+ was unable to talk to the Microsoft
Distributed Transaction Coordinator (Exception from HRESULT: 0x8004E00F)]
System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32
errorCode, IntPtr errorInfo) +0
System.EnterpriseServices.Thunk.Proxy.CoCreateObject(Type serverType,
Boolean bQuerySCInfo, Boolean& bIsAnotherProcess, String& uri) +539

System.EnterpriseServices.ServicedComponentProxyAttribute.CreateInstance(Typ
e
serverType) +161

System.Runtime.Remoting.Activation.ActivationServices.IsCurrentContextOK(Typ
e
serverType, Object[] props, Boolean bNewObj) +73
Microsoft.CommerceServer.Runtime.Orders.PurchaseOrder.Save(Boolean
deleteOrder, ITransaction trans) +4169
Microsoft.CommerceServer.Runtime.Orders.Basket.SaveAsOrder(ITransaction
trans) +150
Microsoft.CommerceServer.Runtime.Orders.Basket.SaveAsOrder() +7
Microsoft.Solutions.Applications.OrderManagement.Cart.SaveAsOrder() in
 c:\Inetpub\wwwroot\isg\App_Code\RetailEx
tensions\Components\OrderManagement\
TransactionContext.cs:1975
ISG.ISGBasket.SetBasketConfirmed(DateTime confirmDateTime) in
 c:\Inetpub\wwwroot\isg\App_Code\ISGBaske
tUtils.cs:536
ISG.ISGOrderObject.Save(String& trackingNumber, String& errorMessage) in
 c:\Inetpub\wwwroot\isg\App_Code\ISGOrder
Utils.cs:1095
UserControls_WarehouseSummary.ConfirmButton_Click(Object sender,
EventArgs e) in c:\Inetpub\wwwroot\isg\WarehouseSummary.aspx.cs:439
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +105
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
+107

System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePo
stBackEvent(String eventArgument) +7
System.Web.UI.Page. RaisePostBackEvent(IPostBackEventHandler

sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102



Paul Marcinkiewicz
Senior Technical Consultant

[ Post a follow-up to this message ]

The app pool user can access the remote machine.
DTC uses RPC to comunicate and thus requires authentication on the remote
machine.
I'd suggest to use DTC tester (http://support.microsoft.com/kb/293799) and
check event log on both machines for further messages.



"Paul Marcinkiewicz" <pmarcinkiewicz@starit.com> ha scritto nel messaggio
news:29A83B95-CDAE-4962-B104-E8A5581B0EBE@microsoft.com...
> Hi,
>
> We recently reconfigured our commerce server 2007 environment.  Our
> webserver is no longer in the same domain as the SQL server and has to go
> thru a firewall.  Normal SQL is fine, however, when we call
> Basket.SaveAsOrder we get the following error.  Clearly this is the
> pipeline
> trying to call a COM+ call on the SQL Server to begin a remote
> transaction.
> We have played with all The DTC settings  without any luck.  Anyone have
> any
> thoughts?
>
>
> Source File:
>  c:\Inetpub\wwwroot\isg\App_Code\RetailEx
tensions\Components\OrderManagemen
t\TransactionContext.cs
> Line: 1975
> Stack Trace:
>
> [COMException (0x8004e00f): COM+ was unable to talk to the Microsoft
> Distributed Transaction Coordinator (Exception from HRESULT: 0x8004E00F)]
>   System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32
> errorCode, IntPtr errorInfo) +0
>   System.EnterpriseServices.Thunk.Proxy.CoCreateObject(Type serverType,
> Boolean bQuerySCInfo, Boolean& bIsAnotherProcess, String& uri) +539
>
> System.EnterpriseServices.ServicedComponentProxyAttribute.CreateInstance(T
ype
> serverType) +161
>
> System.Runtime.Remoting.Activation.ActivationServices.IsCurrentContextOK(T
ype
> serverType, Object[] props, Boolean bNewObj) +73
>   Microsoft.CommerceServer.Runtime.Orders.PurchaseOrder.Save(Boolean
> deleteOrder, ITransaction trans) +4169
>   Microsoft.CommerceServer.Runtime.Orders.Basket.SaveAsOrder(ITransaction
> trans) +150
>   Microsoft.CommerceServer.Runtime.Orders.Basket.SaveAsOrder() +7
>   Microsoft.Solutions.Applications.OrderManagement.Cart.SaveAsOrder() in
>  c:\Inetpub\wwwroot\isg\App_Code\RetailEx
tensions\Components\OrderManagemen
t\TransactionContext.cs:1975
>   ISG.ISGBasket.SetBasketConfirmed(DateTime confirmDateTime) in
>  c:\Inetpub\wwwroot\isg\App_Code\ISGBaske
tUtils.cs:536
>   ISG.ISGOrderObject.Save(String& trackingNumber, String& errorMessage) in
>  c:\Inetpub\wwwroot\isg\App_Code\ISGOrder
Utils.cs:1095
>   UserControls_WarehouseSummary.ConfirmButton_Click(Object sender,
> EventArgs e) in c:\Inetpub\wwwroot\isg\WarehouseSummary.aspx.cs:439
>   System.Web.UI.WebControls.Button.OnClick(EventArgs e) +105
>   System.Web.UI.WebControls.Button.RaisePostBackEvent(String
> eventArgument)
> +107
>
> System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.Raise
PostBackEvent(String
> eventArgument) +7
>   System.Web.UI.Page. RaisePostBackEvent(IPostBackEventHandler

> sourceControl, String eventArgument) +11
>   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
>   System.Web.UI.Page.ProcessRequestMain(Boolean
> includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102
>
>
>
> Paul Marcinkiewicz
> Senior Technical Consultant

[ Post a follow-up to this message ]