cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ojasmaru Frequent Visitor
Frequent Visitor

Odata -Unable to read data from the transport connection: An existing connection was forcibly closed

Hi,

 

I have build few OData based PBIX files. All of the refresh fine in Power BI desktop but when refresh is schedued from PBI-RS (March 2018 Update), One of them fails with following error. Only difference between the one which refresh fine and the one which does not is that it has little larger sized datasets. However they all refresh fine in Power BI Desktop without any issue.

 

When refresh failes, following error is logged in RSPowerBI_2018_*****.log file

 

2018-05-23 16:00:05.6798|INFO|27|Processing Data Model Refresh: SessionId: db7ae921-481f-4904-998e-afcbe5fa3cff, Status: Starting Data Refresh.
2018-05-23 16:00:05.6798|INFO|27|Processing Data Model Refresh: SessionId: db7ae921-481f-4904-998e-afcbe5fa3cff, Status: Starting Retrieving PBIX AsDatabaseInfo.
2018-05-23 16:00:05.7258|INFO|27|Processing Data Model Refresh: SessionId: db7ae921-481f-4904-998e-afcbe5fa3cff, Status: Starting Verifying all the data sources are embedded.
2018-05-23 16:00:05.7258|INFO|27|Processing Data Model Refresh: SessionId: db7ae921-481f-4904-998e-afcbe5fa3cff, Status: Starting Verifying connection strings are valid.
2018-05-23 16:00:05.7328|INFO|27|Processing Data Model Refresh: SessionId: db7ae921-481f-4904-998e-afcbe5fa3cff, Status: Starting Streaming model to Analysis Server.
2018-05-23 16:00:06.2848|INFO|27|Processing Data Model Refresh: SessionId: db7ae921-481f-4904-998e-afcbe5fa3cff, Status: Starting Refreshing the model.
2018-05-23 16:02:11.2116|ERROR|27|Error Processing Data Model Refresh: SessionId: db7ae921-481f-4904-998e-afcbe5fa3cff, Status: Error Failed to refresh the model, Exception Microsoft.AnalysisServices.OperationException: Failed to save modifications to the server. Error returned: '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.
The command has been canceled.. The exception was raised by the IDataReader interface.
'.
   at Microsoft.AnalysisServices.Tabular.Model.SaveChanges(SaveOptions saveOptions)
   at Microsoft.PowerBI.ReportServer.AsServer.TOMWrapper.RefreshModel(Database database)
   at Microsoft.PowerBI.ReportServer.AsServer.AnalysisServicesServer.RefreshDatabase(String databaseName, IEnumerable`1 dataSources, String clientSessionId)
   at Microsoft.PowerBI.ReportServer.WebHost.EventHandler.AnalysisServicesDataRefresh.RefreshDatabase(AsDatabaseInfo asDatabaseInfo)
   at Microsoft.PowerBI.ReportServer.WebHost.EventHandler.DataRefreshScope.<>c__DisplayClass9.<ExecuteActionWithLogging>b__7()
   at Microsoft.PowerBI.ReportServer.WebHost.EventHandler.DataRefreshScope.<ExecuteFuncWithLogging>d__3`1.MoveNext()

On few occasions, I have noticed that my scheduled refresh from PBI-RS succeed without any error. That makes me think that it has to be related to some timeout but logs are not verbose enough to point to a specific timeout setting. I have tried play around with following rsreportserver.config settings but none has helped

 

  <Add Key="DatabaseQueryTimeout" Value="300" />
  <Add Key="RunningRequestsScavengerCycle" Value="300" />
  <Add Key="RunningRequestsDbCycle" Value="300" />
  <Add Key="RunningRequestsAge" Value="300" />

I have also added following config entries in msmdsrv.ini but again no luck

 

 <ExternalCommandTimeout>3600</ExternalCommandTimeout>
<ExternalConnectionTimeout>600</ExternalConnectionTimeout>
<ForceCommitTimeout>600000</ForceCommitTimeout>

Please let me know how can I get around this error.

Thanks...