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