cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mpmsltd
Helper I
Helper I

OLE DB or ODBC error: [DataSource.Error] OData: Unable to read data from the transport connection:

Hi, I'm trying to pull a sales documents table from Dynamics BC and keep getting the error:

 

OLE DB or ODBC error: [DataSource.Error] OData: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host..

 

Does anyone have an idea of how to deal with this error?

 

Thanks,
Mariana

1 REPLY 1
OliT
Resolver I
Resolver I

Hi @mpmsltd 

>> An existing connection was forcibly closed by the remote host..

You can refer to this article, Troubleshoot PostgreSQL: ‘An existing connection was forcibly closed by the remote host’ - Microsoft...

Let’s say a client application tries to execute a query using a previously opened connection object retrieved from a connection pool. When the application attempts to use the connection object, the connection has gone “stale” and the client application throws an exception from attempting to send query data over the “open” connection.  The client-side logic catches the exception and the TCP connection is closed. 

(Although you are using Dynamics, I think this article can be used for reference)

 

The only way to understand exactly what is causing the issue is to capture network trace at the client-side at the time when the issue occurrs. Network Traces can be captured by different applications such as NetMonWireSharkFiddler, etc.

 

Regards,

OliT

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.