Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Steve Burney]

??Hello everyone,
We have a SmartConnect map that will run for approximately 10 minutes and then gives us the message “There was an error reading from the pipe: The pipe has been ended”.

This causes the process to be halted.
We have researched this and we are trying to get a grab on what causes this certain error.

Any assistance will be appreciated.
Steve

——————————
Steve Burney
GP Administrator
Nissan Trading Corporation Americas
Franklin, TN United States
s_burney@nitco-us.com
615-821-6792
Twitter @SteveBurney
——————————

[Vinod Agrawal]

Steve,

The eConnect for Microsoft Dynamics GP Integration Service is a WCF service. A connection can remain inactive, during which no application messages are received, before it is dropped after 10 minutes. This is by default.

RESOLUTION

Add receiveTimeout=”infinite” to the Microsoft.Dynamics.GP.eConnect.Service.exe.config file for the eConnect Integration service. The binding section should resemble this:

<binding name=”eConnectNamedPipeConfig” closeTimeout=”00:10:00″ sendTimeout=”00:10:00″ receiveTimeout =”infinite” transferMode=”Buffered” hostNameComparisonMode=”StrongWildcard” maxBufferPoolSize=”2147483647″ maxBufferSize=”2147483647″ maxReceivedMessageSize=”2147483647″><readerQuotas maxDepth=”60″ maxStringContentLength=”2147483647″maxArrayLength=”2147483647″ maxBytesPerRead=”2147483647″ maxNameTableCharCount=”2147483647″ /><security mode=”Transport”><transport protectionLevel=”EncryptAndSign” /></security>
</binding>

——————————
Vinod Agrawal
Flovian it Services (P) Ltd.
http://www.flovianit.com
+1 (315) 636-4543
——————————
——————————————-

[Steve Burney]

?Thanks Vinod.
We realized that this is what we had in there previously.
When we made the previous changes then here is the error we receive now.

“The transaction associated with the current connection has completed but has not been disposed. The transaction must be disposed before the connection can be used to execute SQL statements.”

Any advice will be appreciated.
Steve

——————————
Steve Burney
GP Administrator
Nissan Trading Corporation Americas
Franklin, TN United States
s_burney@nitco-us.com
615-821-6792
Twitter @SteveBurney
——————————
——————————————-

[Blair Christensen]

?At this point you need to find out why things are timing out.  You can try to do it yourself by using SQL Profiler to find out the actual SQL statements being sent to the engine – there could be a problem in the way the transactions are crafted or it could be just a matter of sheer volume.  The other option is to contact Support and ask them for assistance.

——————————
Blair Christensen
Database Administrator
Oppenheimer Companies, Inc.
Boise ID
——————————
——————————————-

[Leh Fabros]

Hi Steve,

Here is a link that helped me resolved the same issue I had with SmartConnect.

Tech Tuesday: Importing Large Documents Using SmartConnect | eOne Solutions

It will point you to the different eConnect configuration that could be the possible caused of your issue.

I hope this helps.

Kind regards,

——————————
Leh Fabros
DXC Eclipse
New York NY
——————————
——————————————-

[Steve Burney]

?Thank you very much Leh.

I will pass this along to our IT group for them to review this solution.

Thanks again!!
Steve

——————————
Steve Burney
GP Administrator
Nissan Trading Corporation Americas
Franklin, TN United States
s_burney@nitco-us.com
615-821-6792
Twitter @SteveBurney
——————————
——————————————-