Same SSRS Report scheduled multiple times produces errors in 2025.1

Kinetic ERP
, ,
1

We have several reports (standard SSRS and custom BAQ reports) that we send out multiple times to different people on a daily or weekly schedule. So for example, we schedule the standard “Labor Edit” report to run for the previous day for Dept1 and emailed to Supervisor1. Then we schedule the same “Labor Edit” report to run for the previous day for Dept2 and emailed to Supervisor2… and so on. All of these reports are on the same schedule in system agent.

This has been working great for years on every version we have upgraded to until 2025.1. Now, if we have let’s say 8 of these report in that 1 daily schedule, 3 of them will fail. The next day, 4 of them will fail (and not the same ones).
This is not the only report that this is happening on.

The errors include a variety of:
“The item ‘[path to report]’ already exists.”
“The item ‘[path to report]’ cannot be found. —>”
“An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database.”

P.S. We submitted a case with Support 3 weeks ago, but still do not have a resolution or workaround.

Is anyone having these kind of issues since 2025.1? If so, have you had any luck getting around this? I would have to think we’re not the only ones…

Thanks!
-Sharla

1 Like
2

Did you try putting them on different schedules to space them out? Do you have APR? You could try doing it with a routing rule so you only have to run the report once and break on department or whatever instead of running it multiple times.

3

Hi Alisa, thank you for the reply and suggestions.
I’m sure putting them on difference schedules would in fact work. However, I have about 100 of these types of reports currently. That is a lot of schedules to create and maintain.

We thought about using APR breaking and routing since that works well on several other reports we have. However, the above Labor Edit report is the simplest of our scenarios. When it comes to our scheduled sales reports, one person might get their report for the 3 territories they cover. The next person (like a zone manager) needs to get their report for the 20 territories that they oversee. And yet another person gets the same report for all territories, but only for a certain customer group or product group. There’s not one data point to break on.