Forum Discussion
Report Server September 2023 - data-driven subscriptions with email sending doesn't work anymore
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
6 Replies
I think you should probably raise a ticket with Microsoft support for this sort of issue.
In the meantime we found out a workaround.
Details here: Data driven subscriptions with email - workaround
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)
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.
