how to fix an ERROR 500 on SSRS 2019 Enterprise edition

Question

The Microsoft Web SSRS portal have Error 500 time to time. 

sometimes we have the following error: The report execution 1kowwtmibuga4m45d4wt55ai has expired or cannot be found. (rsExecutionNotFound).

The SSRS is installed on Windows server 2022 datacenter. The SQL server 2019 Enterprise edition is updated with CU26(KB5035123) and installed on the same server.

we passed hours checking the load balancer, federation services and network, but the issue looks like in SSRS. We tried (extending the "report session" timeout), as soon as we configured, we stop having the error, but the page result is a blank page.

can someone help us? maybe we need to proceed with an in-place upgrade for SSRS to get the latest version? 15.0.1102.1140. It's safe to proceed with this in-place upgrade.

Here you have the following information about SSRS and SQL server.

SSRS Product version: 15.0.1102.1047

Microsoft SQL Server 2019 (RTM-CU26) (KB5035123) - 15.0.4365.2 (X64)   Mar 29 2024 23:02:47   Copyright (C) 2019 Microsoft Corporation  Enterprise Edition: Core-based Licensing (64-bit) on Windows Server 2022 Datacenter 10.0 <X64> (Build 20348: ) (Hypervisor) 

Answer 1

Error 500 is a more generic Http error, see

https://world.siteground.com/kb/internal_server_error_500/