Forum Discussion
Scheduled refresh failed seemingly random
Looks like your data source has its own timeouts and enforces them by cutting the connection?
Hi,
Sorry for the late reply, as I was swamped with a lot of work.
This scheduled task is set to run every 5 minutes. After testing, the results varied across different versions of the report server.
- When running the same BI file on the 2024.1 version, the schedule executed without errors.
- When running the same BI file on the 2024.9 version, it occasionally failed, with a success-to-failure ratio of 1:1.
The conclusion is that the errors are likely not related to the data source. Preliminary investigation suggests that the issue might be with the configuration of the 2024.9 version. Below are the configuration screenshots for both versions.
2024.9 version: