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 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?

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Yes, there is others reports with errors, and others is OK to refresh.

         

        For example, another that is with error, this was the mensage at the firts time:

         

        2020-10-29 16:01:38.6731|ERROR|5|Error Processing Data Model Refresh: SessionId: 14f19665-0ba8-4a27-85f9-94988a64d949, Status: Error Failed to refresh the model, Exception Microsoft.AnalysisServices.OperationException: Failed to save modifications to the server. Error returned: 'The module named 'Html' has been disabled in this context.. The exception was raised by the IDbCommand interface.

         

        And now, after open/edit from PBIRS in PBIDS, refresh the Data, and save again the report in PBIRS, the error is the same as the other report when trying refresh:

        *This report has MSSQL Datasource and Web/CSV.

        2020-10-29 17:38:35.4243|ERROR|23|Error Processing Data Model Refresh: SessionId: 8c3c4b42-0bc8-4a38-8e9a-31bc9c3710e7, 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 database operation was cancelled because of an earlier failure.
COM error: System.Core, A sequência não contém elementos.

         

        Lúcio