Forum Discussion
The report execution has expired or cannot be found. (rsExecutionNotFound)
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.
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