Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
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)
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.
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.
I think you should probably raise a ticket with Microsoft support for this sort of issue.
We have opened a support ticket to Microsoft, and currently they are investigating the issue.
In the meantime we found out a workaround.
Details here: Data driven subscriptions with email - workaround
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
16 | |
16 | |
4 | |
3 | |
2 |