Forum Discussion

stretcharm's avatar
stretcharm
Memorable Member
8 years ago

October RS Refresh Failure

Hi,   Is anyone getting a refresh failure from the new Oct PowerBI RS?   I have a couple of small powerbi docs with odata and sql server connections and they refresh fine. However I have a more ...
On Prem
ReportServer
valeriy87's avatar
valeriy87
Frequent Visitor
8 years ago
I have the same problem. Stack trace from logs:
 
2017-11-03 15:40:35.5103|ERROR|11|Error Processing Data Model Refresh: SessionId: 612d9568-1afb-4eea-aaa4-5e1d4eebbaf1, Status: Error Failed to refresh the model, Exception System.ArgumentException: An item with the same key has already been added.
   в System.ThrowHelper.ThrowArgumentException(ExceptionResource resource)
   в System.Collections.Generic.Dictionary`2.Insert(TKey key, TValue value, Boolean add)
   в Microsoft.PowerBI.ReportServer.AsServer.Mashup.MashupProviderManager.GenerateDataSourceSettings(String mashupConnectionString, Dictionary`2 serverDataSourcesDictionary)
   в Microsoft.PowerBI.ReportServer.AsServer.Mashup.MashupProviderManager.UpdateConnectionStringWithCredentials(String connectionString, IEnumerable`1 dataSources)
   в Microsoft.PowerBI.ReportServer.AsServer.Mashup.MashupProviderManager.CreateCredentials(ProviderDataSource providerDataSource, IEnumerable`1 dataSources)
   в Microsoft.PowerBI.ReportServer.AsServer.AnalysisServicesServer.SetCredentials(TOMWrapper asWrapper, String databaseName, IEnumerable`1 dataSources)
   в Microsoft.PowerBI.ReportServer.AsServer.AnalysisServicesServer.RefreshDatabase(String databaseName, IEnumerable`1 dataSources, String clientSessionId)
   в Microsoft.PowerBI.ReportServer.WebHost.EventHandler.AnalysisServicesDataRefresh.RefreshDatabase(AsDatabaseInfo asDatabaseInfo)
   в Microsoft.PowerBI.ReportServer.WebHost.EventHandler.DataRefreshScope.<>c__DisplayClass9.<ExecuteActionWithLogging>b__7()
   в Microsoft.PowerBI.ReportServer.WebHost.EventHandler.DataRefreshScope.<ExecuteFuncWithLogging>d__3`1.MoveNext()
2017-11-03 15:40:35.5103|ERROR|11|Error Processing Data Model Refresh: SessionId: 612d9568-1afb-4eea-aaa4-5e1d4eebbaf1, Status: Error Failed Data Refresh, Exception System.ArgumentException: An item with the same key has already been added.
   в Microsoft.PowerBI.ReportServer.WebHost.EventHandler.DataRefreshScope.ExecuteActionWithLogging(Action methodToExecute, String description, String localizedDescription, String messageInFailure, RefreshInfo refreshInfo, DataAccessors dataAccessors, ReportEventType operation, Boolean isDataRetrieval, Boolean showInExecutionLog, Boolean sendToTelemetry)
   в Microsoft.PowerBI.ReportServer.WebHost.EventHandler.AnalysisServicesDataRefresh.RefreshData(RefreshInfo refreshInfo)
   в Microsoft.PowerBI.ReportServer.WebHost.EventHandler.DataRefreshScope.<>c__DisplayClass9.<ExecuteActionWithLogging>b__7()
   в Microsoft.PowerBI.ReportServer.WebHost.EventHandler.DataRefreshScope.<ExecuteFuncWithLogging>d__3`1.MoveNext()