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:
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.
