Problem statement – Recently we upgrade our CRM Onpremise version to 18.104.22.168 and suddenly getting below error while opening any SSRS report from CRM user interface
The report execution eqaiekfzmk2snc55y0zrow55 has expired or cannot be found. (rsExecutionNotFound)
Troubleshooting steps followed –
- Restarted SQL server services
- IIS reset
- Report Query executed in SSMS looked good
- Report server logs error did not get much detailed error
After 4 hours of rough troubleshooting, we finally managed to fix this issue.
It turned out that Server where SSRS reporting is installed System Timezone was not correct and sync with other servers. After syncing the Server timezone with other servers, issue fixed and report started working.
I hope this helps!