Jump to content

Power BI - ADO.NET: R script error. Error: The report 'xx' is already running.


Recommended Posts

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 post
Share on other sites

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 post
Share on other sites

@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 post
Share on other sites

@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:

image.thumb.png.870b6862b5321c2656fe88e7054824d7.png

Report 47:

image.thumb.png.06259a30c973b4ecf889ec1d4027a629.png

Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...