Operational Defect Database
BugZero found this defect 1308 days ago.
Data sources
All data on this page is proprietary to BugZero® or gathered from public sources
Microsoft SQL Server | 11281513
KB4042948 - FIX: Data-driven subscription fails after you upgrade from SSRS 2008 to SSRS 2016 - Microsoft Support
Last update date:
6/21/2022
Affected products:
SQL Server 2016 Enterprise Core - duplicate (do not use)
SQL Server 2016 Enterprise - duplicate (do not use)
SQL Server 2016 Developer - duplicate (do not use)
SQL Server 2016 Standard - duplicate (do not use)
SQL Server 2017 Developer on Windows
SQL Server 2017 Enterprise on Windows
SQL Server 2017 Enterprise Core on Windows
SQL Server 2017 Standard on Windows
Affected releases:
build lower than 14.0.3022.28
Fixed releases:
14.0.3022.28
Description:
Symptoms
Consider the following scenario: You use email subscriptions in SQL Server Reporting Services (SSRS). You upgrade from SQL Server 2008 Reporting Services to SQL Server 2016 Reporting Services. On the Subscription page in SQL Server 2016 Reporting Services, there are multiple semi-colons (;) between the email subscription addresses on the To line. In this scenario, the data-driven subscription fails, and you receive the following error message: An invalid character was found in the mail header: ',' The entire subscription fails without generating the email.
Resolution
This fix is included in the following cumulative updates for SQL Server: Cumulative Update 4 for SQL Server 2017 Cumulative Update 7 for SQL Server 2016 SP1 Cumulative Update 9 for SQL Server 2016.
About SQL Server builds
Each new build for SQL Server 2016 contains all the hotfixes and security fixes that were in the previous build. We recommend that you install the latest cumulative updates for SQL Server: Latest cumulative update for SQL Server 2017 latest build for SQL Server 2016
Status
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
References
Learn about the terminology Microsoft uses to describe software updates.
