topic Re: PBRS Oct/2020 Release update causes errors in Scheduled Refresh in Report Server

PBRS Oct/2020 Release update causes errors in Scheduled Refresh

Anonymous — Thu, 29 Oct 2020 18:31:41 GMT

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: COM error: System.Core, A sequência não contém elementos.
[1] -1055784828: The database operation was cancelled because of an earlier failure.

The same report in May/2020 version is refreshing normally.

I already opened the report in Desktop October versioon, refresh all, save again e nothing changes.

Could be a bug in the release?

Thanks.

Re: PBRS Oct/2020 Release update causes errors in Scheduled Refresh

Anonymous — Thu, 29 Oct 2020 19:20:49 GMT

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

Re: PBRS Oct/2020 Release update causes errors in Scheduled Refresh

Anonymous — Thu, 29 Oct 2020 19:35:51 GMT

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

Re: PBRS Oct/2020 Release update causes errors in Scheduled Refresh

Anonymous — Thu, 29 Oct 2020 19:55:36 GMT

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

Re: PBRS Oct/2020 Release update causes errors in Scheduled Refresh

Anonymous — Thu, 29 Oct 2020 20:05:46 GMT

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

Re: PBRS Oct/2020 Release update causes errors in Scheduled Refresh

Anonymous — Thu, 29 Oct 2020 20:33:34 GMT

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

Re: PBRS Oct/2020 Release update causes errors in Scheduled Refresh

Anonymous — Thu, 29 Oct 2020 20:44:06 GMT

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

Re: PBRS Oct/2020 Release update causes errors in Scheduled Refresh

Anonymous — Thu, 29 Oct 2020 21:20:32 GMT

Lucio,

Refresh for html datasources are not supported, was this something that was working in the previous release and started failing after you upgraded to october?

To be clear, refreshes from html would have your M expression as "Web.Page", "Web.BrowserContents". This is different than if you are fetching a csv file from a web location, which is indeed supported (in this case the M expression is Web.Contents).

Thanks

-gboreki

Re: PBRS Oct/2020 Release update causes errors in Scheduled Refresh

Anonymous — Fri, 06 Nov 2020 21:16:17 GMT

We are seeing the same thing when we try and refresh. We will revert the desktop back to the May 2020 release. Please fix ASAP.

Re: PBRS Oct/2020 Release update causes errors in Scheduled Refresh

AdEzone — Mon, 09 Nov 2020 00:37:11 GMT

The workaround will only work if you have not used the October 2020 Desktop version to open-edit-save the .pbix file directly in the server.

The May2020 will refuse to open the file as it has been updated to the Enhanced Dataset Metadata Format..... Too late...

Furthermore, you better have saved a copy of your reports already in production... If so, just LOAD from the server your previous .pbix file and it will run scheduled updates again.

Then you can use May2020 version to make changes.

Please fix the issue ASAP.... These things should have been tested before releasing the update....

It is better to wait some more when structural changes are done better than this...

Re: PBRS Oct/2020 Release update causes errors in Scheduled Refresh

jlwkok — Mon, 23 Nov 2020 11:52:06 GMT

This has been fixed by Microsoft, see https://community.powerbi.com/t5/Report-Server/Power-BI-Report-Server-October-2020-update-has-been-released/td-p/1503433