Report Server September 2023 - data-driven subscriptions with email sending doesn't work anymore

[Vosaxalo90]

We have found out that our existing paginated reports with a data-driven subscription and email sending doesn't work anymore.
Here the extract of a log "ReportingServicesService.log":

the data-driven subscription starts
library!ReportServer_0-3!bd8!11/02/2023-11:26:39:: i INFO: Call to GetItemTypeAction(TUI_ATTRIBUITE_A_UTPG). User: xx\xxxxxx.
library!ReportServer_0-3!bd8!11/02/2023-11:26:39:: i INFO: Call to GetReportParametersAction(TUI_ATTRIBUITE_A_UTPG). User: xx\xxxxxx.
schedule!WindowsService_4!14a4!11/02/2023-11:26:40:: i INFO: Handling event with data: TimeEntered: 11/02/2023 11:26:40, Type: Event, EventType: TimedSubscription, SubscriptionID: 91337b4d-432c-49fc-b31e-c1627bcd4e33.
library!WindowsService_4!14a4!11/02/2023-11:26:40:: i INFO: Schedule b658628a-fc2e-4c60-96c1-4c6b25bc514b executed at 11/02/2023 11:26:40.

email message preparation
schedule!WindowsService_4!14a4!11/02/2023-11:26:40:: i INFO: Creating Time based subscription notification for subscription: 91337b4d-432c-49fc-b31e-c1627bcd4e33
library!WindowsService_4!14a4!11/02/2023-11:26:40:: i INFO: Schedule b658628a-fc2e-4c60-96c1-4c6b25bc514b execution completed at 11/02/2023 11:26:40.
schedule!WindowsService_4!14a4!11/02/2023-11:26:40:: i INFO: Handling event with data: TimeEntered: 11/02/2023 11:26:40, Type: Event, EventType: DataDrivenSubscription, SubscriptionID: 91337B4D-432C-49FC-B31E-C1627BCD4E33.
library!WindowsService_4!2f2c!11/02/2023-11:26:40:: i INFO: Handling data-driven subscription 91337b4d-432c-49fc-b31e-c1627bcd4e33 to report TUI_ATTRIBUITE_A_UTPG, owner: xx\xxxxxx, delivery extension: Report Server Email.
dataextension!WindowsService_4!2f2c!11/02/2023-11:26:41:: i INFO: Opening SqlConnection with ClientConnectionId 129b93a7bade4bdb9d18e4c1c1bb33d1
notification!WindowsService_4!2f2c!11/02/2023-11:26:41:: i INFO: Handling subscription 91337b4d-432c-49fc-b31e-c1627bcd4e33 to report TUI_ATTRIBUITE_A_UTPG, owner: xx\xxxxxx, delivery extension: Report Server Email.

error sending the email message (subscription failure)
emailextension!WindowsService_4!2f2c!11/02/2023-11:26:41:: e ERROR: Error sending email. Exception: System.NullReferenceException: Object reference not set to an instance of an object. at Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification).
Additional Information:
notification!WindowsService_4!2f2c!11/02/2023-11:26:44:: e ERROR: Error occurred processing subscription 91337b4d-432c-49fc-b31e-c1627bcd4e33: Failure sending mail: Object reference not set to an instance of an object.Mail will not be resent.
notification!WindowsService_4!2f2c!11/02/2023-11:26:44:: i INFO: Notification 277758e6-ade7-4d4c-b9d4-73e6c39532d6 completed. Success: False, Status: Failure sending mail: Object reference not set to an instance of an object.Mail will not be resent., DeliveryExtension: Report Server Email, Report: TUI_ATTRIBUITE_A_UTPG, Attempt 0

[josef78]

Which build of Sep23 release you have installed?

1.18.8668.33514(build 15.0.1113.162)

1.18.8683.7488(build 15.0.1113.165)

1.18.8702.6380(build 15.0.1113.169) 

[Vosaxalo90]

Just upgraded one server to the last build (1.18.8702.6380(build 15.0.1113.169) ).

Sadly no one of the builds is able to solve the issue.

[Vosaxalo90]

This one:

1.18.8683.7488(build 15.0.1113.165)

I didn't even know that it is available a new build.

On this site: Report Server changelog the last build is still the 15.0.1113.165.

[d_gosbell]

I think you should probably raise a ticket with Microsoft support for this sort of issue.

[Vosaxalo90]

We have opened a support ticket to Microsoft, and currently they are investigating the issue.

[Vosaxalo90]

In the meantime we found out a workaround.

Details here: Data driven subscriptions with email - workaround