Forum Discussion

Ccparkhill's avatar
Ccparkhill
Icon for Helper II rankHelper II
8 years ago

The report execution has expired or cannot be found. (rsExecutionNotFound)

I am using the October release of PBIRS, when I call an SSRS report from a URL I am getting a "The report execution has expired or cannot be found. (rsExecutionNotFound)" error, for example: http://...
Power BI Report Server
v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Ccparkhill,

 

I encountered the same error message as yours when I called the SSRS report the second time with a changed URL parameter. 

 

The first time:        http://servername/PowerBIReports/report/Report%20Project1/SSRSReport1?rs:Embed=true&rc:Toolbar=false

The second time:  http://servername/PowerBIReports/report/Report%20Project1/SSRSReport1?rs:Embed=true

 

But it looks like an occasional issue. This problem doesn't occur to other reports. And after I re-published the report to report server, I didn't come across this problem. In your scenario, please re-publish the report for a test. And try to reboot PBI report server service.

 

Regards,

Yuliana Gu

Ccparkhill's avatar
Ccparkhill
Icon for Helper II rankHelper II
8 years ago

v-yulgu-msft thanks for your reponse, it's not changing the URL parameters I'm having a problem with, it's changing the value of a report parameter via the URL when combined with &rc:Toolbar=false.  

 

First execution working: http://myserver/Reports/report/myfolder/myreport?rs:Embed=true&rc:Toolbar=false&Year=2016

Second execution not working: http://myserver/Reports/report/myfolder/myreport?rs:Embed=true&rc:Toolbar=false&Year=2017

 

Removing &rc:Toolbar=false results in both working without issue:

http://myserver/Reports/report/myfolder/myreport?rs:Embed=true&Year=2016

http://myserver/Reports/report/myfolder/myreport?rs:Embed=true&Year=2017

 

I have tried redeploying the reports but that does not solve the issue, I'm seeing this on our dev, UAT and production PBIRS installations. I also tried SSRS 2017 on another server with the same result.

 

It seems like &rc:Toolbar=false changes the behaviour of the session for some reason, is this expected?

 

I was able to work around this issue by setting UseSessionCookies to false in Advanced Server Properties via SSMS. 

 

 

  • Ccparkhill's avatar
    Ccparkhill
    Icon for Helper II rankHelper II
    8 years ago

    I was able to reproduce this at home on my laptop with default installs of SQL Server 2017 Developer and PBIRS October 2017 using:

    Adventure Works 2014 Full Database

    AdventureWorks 2012 SSRS Samples

     

    First execution working: http://localhost/reports/report/AdventureWorks%20Sample%20Reports/Sales%20Order%20Detail?rs:Embed=true&rc:Toolbar=false&SalesOrderNumber=SO50750

    Second execution not working: http://localhost/reports/report/AdventureWorks%20Sample%20Reports/Sales%20Order%20Detail?rs:Embed=true&rc:Toolbar=false&SalesOrderNumber=SO50751

     

    Removing &rc:Toolbar=false results in both working without issue:

    http://localhost/reports/report/AdventureWorks%20Sample%20Reports/Sales%20Order%20Detail?rs:Embed=true&SalesOrderNumber=SO50751

    http://localhost/reports/report/AdventureWorks%20Sample%20Reports/Sales%20Order%20Detail?rs:Embed=true&SalesOrderNumber=SO50750