Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

PBRS Oct/2020 Release update causes errors in Scheduled Refresh

  Hi all,   After install the new release update of PBRS in a DEV Server, some reports are not beeing refresh with successfully:   SessionID: 12a473d7-3e18-4071-b4d4-3145543d99ff [0] -1056505856...
refresh error
Refresh Schedule Error
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Luanrad,

 

Can you let me know what is the type of datasource used by your report and the connection string(with identifying info removed).

 

thanks

Boreki

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Boreki,

 

thanks for you reply.

The report source is MSSQL databases. 1 is ReportServer and the second is other with employees information, to merge UserDC information.

 

 

Detailed error log:

 

2020-10-29 16:15:07.6046|ERROR|8|Error Processing Data Model Refresh: SessionId: 2f160d21-7e95-421f-9ef1-323fa962cb66, Status: Error Failed to refresh the model, Exception Microsoft.AnalysisServices.OperationException: Failed to save modifications to the server. Error returned: 'COM error: System.Core, A sequência não contém elementos.
The current operation was cancelled because another operation in the transaction failed.
COM error: mscorlib, Já foi adicionado um item com a mesma chave..
'.
   em Microsoft.AnalysisServices.Tabular.Model.SaveChangesImpl(SaveOptions options)
   em Microsoft.PowerBI.ReportServer.AsServer.TOMWrapper.RefreshModel(Database database)
   em Microsoft.PowerBI.ReportServer.AsServer.AnalysisServicesServer.RefreshDatabase(String databaseName, IEnumerable`1 dataSources, IEnumerable`1 parameters, String clientSessionId)
   em Microsoft.PowerBI.ReportServer.WebHost.EventHandler.AnalysisServicesDataRefresh.RefreshDatabase(AsDatabaseInfo asDatabaseInfo)
   em Microsoft.PowerBI.ReportServer.WebHost.EventHandler.DataRefreshScope.<>c__DisplayClass34_0.<ExecuteActionWithLogging>b__0()
   em Microsoft.PowerBI.ReportServer.WebHost.EventHandler.DataRefreshScope.<ExecuteFuncWithLogging>d__33`1.MoveNext()

 

BR.

 

Lúcio

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Lúcio!

     

    Would you please also check the log prefixed with "asmanagedroot" for any exceptions around the same time and share here if possible?

     

    Thanks

    gboreki

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Boreki,

       

      I saw the "asmanagedroot" log and there is no "ERROR" log register in the same period, just |INFO| registers. I wouldn't share the log here because the file has a lot of sensetive data.

       

      BR.

       

      Lúcio

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Are you having issues with other reports? or just this one? Anything different as it related to datasources connectivity here?