topic Re: PBI refresh and update error in na Report Service On-premisses in Report Server

PBI refresh and update error in na Report Service On-premisses

Anonymous — Mon, 25 Jan 2021 13:52:09 GMT

Hi,

I'm using a report service on-prem to publish the reports, we have the production and test environment. A scheduled report was published and in the production environment it does not update, while in the test environment it does. An error was found, in test environment, about IDATAREADER, but we are not using SQL.

Could anyone advise?

Re: PBI refresh and update error in na Report Service On-premisses

lbendlin — Mon, 25 Jan 2021 23:36:37 GMT

somebody was writing to the database at the same time as you were attempting to read, and you lost the rock-paper-scissors game.

Re: PBI refresh and update error in na Report Service On-premisses

Anonymous — Tue, 26 Jan 2021 11:44:40 GMT

lbendlin, All kidding aside, this error may be related to be priority of reading and writing then? Even if you are a systemic user?

Re: PBI refresh and update error in na Report Service On-premisses

lbendlin — Tue, 26 Jan 2021 13:36:34 GMT

Yes. Talk to the people writing to the database if they could use more optimistic lock settings. (Not kidding, that is a thing)

Re: PBI refresh and update error in na Report Service On-premisses

Anonymous — Mon, 01 Feb 2021 11:43:08 GMT

Thanks for the help, i will test