0 Kudos

Unable to read data from the transport connection

Status: Needs Info
by Beed_monitor Visitor on ‎01-12-2017 01:14 AM

Hello,

 

Lately, we have issues with automatic update in PBI online accounts. I have 2 different reports, each has different CSV data source from our server. Almost every day the auto update fails.

 

During update one of the reports, PBI tries to update both data sources at once, do not know why. Additionaly, the update process sends 2, sometimes even more GET requests on the server at a time. First request is stopped by PBI during downloading the file. Usually, PBI sends requests, our server answers and sends the whole file successfully, but PBI do not use it and it ends with error anyway.

We have tried to check all time limits on our side, but it seems to be OK. It is the same with small and large files.

 

Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.. The exception was raised by the IDataReader interface.

Next refresh for name_of_the_file is scheduled for 01/13/2017 07:45:00.
 
Technical Information:
Activity Id: ab3448f5-857b-4cd3-8470-6f5e007d16b8
Request Id: a5c2df24-fad2-4dcd-a367-59e453eb7bdf
Refresh Start Time: 01/12/2017 07:07:01Z
Refresh End Time: 01/12/2017 07:15:58Z
Status: Needs Info
Comments
by Community Support Team
on ‎01-13-2017 12:14 AM

@Beed_monitor

 

Did this issue happen to the same two reports before? I tried to test the same scenario as you but cannot repro the same issue. Is there any special setting/configuration?

 

Best Regards,

Herbert

 

by Vicky_Song Established Member
on ‎01-13-2017 12:16 AM
Status changed to: Needs Info
 
by Beed_monitor Visitor
on ‎01-13-2017 08:49 AM

@v-haibl-msft

 

Dear Herbert,

 

We have app. 30 clients and everyone has each own free account with 2 reports = 60 autoupdates per day. Today I recieved 11/30 errors, 17/30 yesterday. Distribution is random every day. So yes, this issue happened more than once to the same reports. In late November, it was usually 1 error of this type per week in total. Nothing changed on our side since then and we use the same reports.

 

Best regards,

Jakub

by Community Support Team
on ‎01-15-2017 06:32 PM

@Beed_monitor

 

Can the report be refreshed successfully if using manual refresh instead of automatic refresh?

 

Best Regards,

Herbert

by Beed_monitor Visitor
on ‎01-15-2017 09:05 PM

@v-haibl-msft

 

Yes, but there is also 30-40 % failure rate, so I need to do that more than once.

 

Regards,

Jakub

by CamLK New Member
on ‎03-01-2017 08:15 AM

I have the same issue on some manual and scheduled refresh :

 

Data source error: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.. The exception was raised by the IDataReader interface.
Cluster URI: WABI-NORTH-EUROPE-redirect.analysis.windows.net
Activity ID: 432c4293-14d8-48a8-aa03-379d92461a0f
Request ID: 71d7169d-fdbb-aa4e-2cff-d0fc054632ab
Time: 2017-03-01 12:36:00Z

 

We no change on the report the issue occur and disapear.

by Beed_monitor Visitor
on ‎03-02-2017 12:02 AM

Good to hear we are not alone.

 

The number of errors has decreased on half last month. Nobody knows why and when it increases again. No changes in our reports as well.

 

CamLK: Wish you to find a solution.

 

Regards,

Jakub

by almostdj Occasional Visitor
on ‎05-23-2017 05:21 AM

We have the same issue.

Did anyone find solution?

Idea Statuses