m.vandun Posted November 17, 2020 Share Posted November 17, 2020 Hi @Steve G, When refreshing the Power BI query I constantly get the following error which halts the import. When rerunning the refresh multiple time it sometimes goes through. ADO.NET: R script error. Error: The report '47' is already running. Please wait for it to complete before attempting to re-run the same report. Execution halted Any advise on how to resolve this? Already disabled some old queries which are not updated anymore to minimize the reports generated. Also adjusted suspendSeconds to a higher number but still no affect. # Suspend for X amount of seconds between checks to see if the report is complete suspendSeconds <- 10 Rind regards, Mark Link to comment Share on other sites More sharing options...
Steve G Posted November 17, 2020 Share Posted November 17, 2020 Hi @m.vandun, This message just means that the report is already being run on your Hornbill instance, either from the admin tool or a script that has executed it. You can check the running status of a report in the admin console - it's on the Status column in the Report History tab. You (or your automated scripts) will need to wait until the current report run is complete before firing off another request. Cheers, Steve Link to comment Share on other sites More sharing options...
m.vandun Posted November 18, 2020 Author Share Posted November 18, 2020 @Steve G, I understand this but there is no report running, at least not that I can see in the report overview. Even if I run this the first time on a new day I get this error(last refresh try is has been more than 24 hours ago). This should be plenty time for any report to finish. Link to comment Share on other sites More sharing options...
m.vandun Posted November 20, 2020 Author Share Posted November 20, 2020 @Steve G Just tried refreshing again and still the same error. The last refresh I tried was yesterday and completed after a few tries. Checked the report section but there does not seem to be a report generated. The last reports are from 11-11 and 12-11 in the overview. report 46: Report 47: Link to comment Share on other sites More sharing options...
m.vandun Posted November 27, 2020 Author Share Posted November 27, 2020 Hi @Steve G Any updates on this? I'm still having these issues. Link to comment Share on other sites More sharing options...
Steve Giller Posted November 27, 2020 Share Posted November 27, 2020 @m.vandun PowerBI just asks your Instance to run the report - if it gets the message the report is running, that's what your Instance is responding with. What happens if you run the report manually from the UI? Link to comment Share on other sites More sharing options...
m.vandun Posted December 4, 2020 Author Share Posted December 4, 2020 @Steve Giller Tried running the report manualy from the administrator, this works properly. Link to comment Share on other sites More sharing options...
Joyce Posted December 4, 2020 Share Posted December 4, 2020 Yes, getting this more often after changing of the R Script. It usually complete running after a while ( even if the report itself is very small with less than 50 rows). I have also notice, that since changing of R Script, the reports are taking too long to run and load in PowerBI Link to comment Share on other sites More sharing options...
m.vandun Posted January 6, 2021 Author Share Posted January 6, 2021 @Steve Giller Any updates on this? I'm still getting the same issue. Link to comment Share on other sites More sharing options...
m.vandun Posted January 22, 2021 Author Share Posted January 22, 2021 @Steve Giller @Steve G Any updates? Still having this issue, can't run a report in this way. Link to comment Share on other sites More sharing options...
SamS Posted February 5, 2021 Share Posted February 5, 2021 Hi @m.vandun, Are you the only one triggering those reports? or are more (PowerBI) users/processes (eg a dashboard or so) potentially querying that same report at (nearly) the same time? Is there a load-balancer/proxy or something going out to Hornbill which might trigger the running of the report before your connection is made? I remember once dealing with IE which hit a WebServer twice on a POST: first time with an empty payload (to trigger an expected authentication) and the second time with the payload. If, in this circumstance, a middleman sends two full payloads (i.e. triggering the report to run on the first and the "report already running" on the second) , and only passes the second response to the client (R-script), then that might account for the above behaviour. Link to comment Share on other sites More sharing options...
m.vandun Posted February 5, 2021 Author Share Posted February 5, 2021 Hi @SamS I'm the only one triggering the report. I'm currently only refreshing this via the PowerBi Desktop app. So as far as I know only one request is send, unless the python or Rscript query triggers multple queries. Link to comment Share on other sites More sharing options...
SamS Posted February 5, 2021 Share Posted February 5, 2021 Hi @m.vandun, The scripts shouldn't be triggering it multiple times, my concern is that perhaps there is a proxy/firewall layer in between which (for whatever unaccounted for reason) might be throwing a spanner in the works. Are you running with "deleteReportInstance" set to true? if so, please set to to false, so we can confirm whether a report was triggered by the PowerBI. Another option would be to increase/set "suspendSeconds". Also, what are the results if you run a(n existing) "HistoricReport"? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now