FIX: Data-driven subscription fails after you upgrade from SSRS 2008 to SSRS 2016

Van toepassing: SQL Server 2016 Enterprise CoreSQL Server 2016 EnterpriseSQL Server 2016 Developer

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

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.