SSRS 2022 - Subscription Error when Scheduling to Run each Month on 10th 20th or 30th (Error: Invalid Days)

Unable to create/modify SSRS 2022 report subscription to run each month on the 10th, 20th or 30th.

Example Schedule settings (See screenshot below):

Schedule: Month
Months: All months selected
On calendar day(s): 20 (But is the same result if 10 or 30 is entered)

Error symbol appears and warns of "Invalid days"

Appears whenever "0" is entered into the "On calendar day(s)" field the error occurs and cannot proceed to "Apply" the subscription despite the calendar day being a valid day of the month.

We also have a SSRS 2019 environment and cannot replicate this issue there.

User's image

2 answers

ZoeHui-MSFT 37,671 Reputation points

2024-02-16T02:38:17.7866667+00:00
Hi @Gui Xiong (South Western Sydney LHD)，

It seems is a known issue and has been fixed in below release, you may upgrade it for a try.

16.0.8564.33454, 2023/06/13

(Product Version: 16.0.1114.11)

Introduced new Accessibility property that lets report authors to add accessible headers to tables and Heading levels to text boxes.

Fixed setting calendar days to a single day for monthly schedules. See Release notes for SQL Server Reporting Services (SSRS) 2017 and later

Regards，

Zoe Hui

If the answer is helpful, please click "Accept Answer" and upvote it.
Please sign in to rate this answer.
Gui Xiong (South Western Sydney LHD) 5 Reputation points

2024-05-16T01:25:39.28+00:00

This solution does not resolve issue.
See post from Robert Findlay - bug still present SSRS version 16.0.8886.1775.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
Robert Findlay 0 Reputation points

2024-05-14T18:58:38.35+00:00

The above bug is present on newest release of SSRS (16.0.8886.1775).
Please sign in to rate this answer.
Gui Xiong (South Western Sydney LHD) 5 Reputation points

2024-05-16T01:19:58.3866667+00:00

It's nice to know we're not the only one having this issue as I couldn't find many posts relating to this issue.

The only workaround we have currently is either:

Communication with end users to adjust report schedule a day forward or back (e.g. 9th or 11th instead of 10th). OR

A SQL Server Agent job that is scheduled for the "Invalid day" dates, that executes the SSRS report. Limitation is that requires a certain level of privileges that might not be afforded to all who create/edit/schedule reports on SSRS.

But neither is an actual fix to this bug.

Vig Vaidianathan 0 Reputation points

2024-07-06T13:25:52.68+00:00

I face the same issue. I'm trying the workaround to update the data directly in the ReportServer DB Table(I dont like doing this but wanna try). I have used the below query for updating it to the 10th.

update

[ReportServer].[dbo].[Schedule]

set DaysOfMonth = 512

where name = ''--add your schedule name within the quotes

Use 512 for 10th

Use 524288 for 20th

Use 536870912 for 30th

Seems like the value stored in the DB is the 2 to the power (number of days -1)(Inferred by trying various dates)

The value does get updated on the schedule

but when you edit it, it still shows the error but it does remain if you cancel it

Another 4 days and will see if it goes through. Will keep you posted
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

SSRS 2022 - Subscription Error when Scheduling to Run each Month on 10th 20th or 30th (Error: Invalid Days)

2 answers

Your answer