Discussion:
eConnect error -
(too old to reply)
sushil singh
2004-10-04 15:07:02 UTC
Permalink
I want to use eConnect for the purpose of inserting Orders into Great Plains
via a storefront application, but I am running into a couple of issues. I am
new to eConnect and had some difficulties installing the eConnect .Net
Incoming Service, but was finally able to install it. I tried using the
"CSharp eConnect Sales Order Example" article from MSDN to see if I could
properly insert a simple order into the TWO database.

I read and looked through several of the posts, but I can't find a solution
to the error that I am receiving. When ever I call eConnect_EntryPoint in the
line below, I receive an exception.

eConCall.eConnect_EntryPoint(strConn,
EnumTypes.ConnectionStringType.SqlClient, strSalesOrderDoc,
EnumTypes.SchemaValidationType.None, "");

Exception : "The transaction has already been implicitly or explicitly
committed or aborted"
StackTrace : [COMException (0x8004d00e): The transaction has already been
implicitly or explicitly committed or aborted]
System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage
reqMsg, IMessage retMsg) +264
System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData&
msgData, Int32 type) +877
Microsoft.eConnect75.eConnectMethods.eConnect_EntryPoint(String
ConnectionString, ConnectionStringType ConnectionType, String sXML,
SchemaValidationType ValidationType, String eConnectSchema)
eConnectSample.Order.Button1_Click(Object sender, EventArgs e) in
c:\inetpub\wwwroot\econnectsample\order.aspx.cs:186
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()

One of the sticky points in our scenario is that the server where Great
Plains resides is on a different domain than the development machine that I'm
using to
try to insert the order. Reading from various posts, it seems that this has
caused some people issues, but there were no solutions given to resolve it.

I've also tried to use the applicatiosn provided in the eConnect Samples
directory of the eConnect install, but am also receiving error. This is an
error that I received from running the "eConnect Document Sending Utility"
with the same XML file from the "CSharp eConnect Sales Order Example" MSDN
article.

Return Codes from "eConnect Document Sending Utility"
Version=7.5.2.0
Unique MessageId =
Error Number = -2147168246 Error Description = New transaction cannot
enlist in the specified transaction coordinator. Error Source = Microsoft
OLE DB Provider for SQL Server Line Number=8120

Version=7.5.2.0
Unique MessageId =
Error Number = 2303 Error Description = The registration failed for
eConnect. Please insure that valid registration keys where entered for
eConnect. Error Source = ExecProcsXML.ExecStoredProc.Registration Line
Number=1160

Is there anything that I'm do that is fundamentally wrong? Can you please
provide any suggestions that might help me resolve the issues that I'm having.
Thanks.
Allen
2004-10-05 20:34:26 UTC
Permalink
I cam across this same issue only after I installed WinXP Service Pack 2.
And I found the solution here at the link posted below. I'm not saying this
is the 100% best solution but this got me up and running. If you havn't
already got the solution.

<http://dotnetjunkies.com/WebLog/jlynch/archive/2004/08/23/23022.aspx>
Post by sushil singh
I want to use eConnect for the purpose of inserting Orders into Great Plains
via a storefront application, but I am running into a couple of issues. I am
new to eConnect and had some difficulties installing the eConnect .Net
Incoming Service, but was finally able to install it. I tried using the
"CSharp eConnect Sales Order Example" article from MSDN to see if I could
properly insert a simple order into the TWO database.
I read and looked through several of the posts, but I can't find a solution
to the error that I am receiving. When ever I call eConnect_EntryPoint in the
line below, I receive an exception.
eConCall.eConnect_EntryPoint(strConn,
EnumTypes.ConnectionStringType.SqlClient, strSalesOrderDoc,
EnumTypes.SchemaValidationType.None, "");
Exception : "The transaction has already been implicitly or explicitly
committed or aborted"
StackTrace : [COMException (0x8004d00e): The transaction has already been
implicitly or explicitly committed or aborted]
System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage
reqMsg, IMessage retMsg) +264
System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData&
msgData, Int32 type) +877
Microsoft.eConnect75.eConnectMethods.eConnect_EntryPoint(String
ConnectionString, ConnectionStringType ConnectionType, String sXML,
SchemaValidationType ValidationType, String eConnectSchema)
eConnectSample.Order.Button1_Click(Object sender, EventArgs e) in
c:\inetpub\wwwroot\econnectsample\order.aspx.cs:186
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()
One of the sticky points in our scenario is that the server where Great
Plains resides is on a different domain than the development machine that I'm
using to
try to insert the order. Reading from various posts, it seems that this has
caused some people issues, but there were no solutions given to resolve it.
I've also tried to use the applicatiosn provided in the eConnect Samples
directory of the eConnect install, but am also receiving error. This is an
error that I received from running the "eConnect Document Sending Utility"
with the same XML file from the "CSharp eConnect Sales Order Example" MSDN
article.
Return Codes from "eConnect Document Sending Utility"
Version=7.5.2.0
Unique MessageId =
Error Number = -2147168246 Error Description = New transaction cannot
enlist in the specified transaction coordinator. Error Source = Microsoft
OLE DB Provider for SQL Server Line Number=8120
Version=7.5.2.0
Unique MessageId =
Error Number = 2303 Error Description = The registration failed for
eConnect. Please insure that valid registration keys where entered for
eConnect. Error Source = ExecProcsXML.ExecStoredProc.Registration Line
Number=1160
Is there anything that I'm do that is fundamentally wrong? Can you please
provide any suggestions that might help me resolve the issues that I'm having.
Thanks.
r***@gmail.com
2013-03-05 16:52:58 UTC
Permalink
how did you get the GP eConnect Incoming_Service to install. On every attempt it shows as not available? Is there a work around?
Loading...