FIX: Subscription will fail if the DateTime parameter is created and edited by different locale and keyboard language in SSRS 2016

S’applique à : SQL Server 2016 DeveloperSQL Server 2016 EnterpriseSQL Server 2016 Enterprise Core

Symptoms


Considerthe following scenario:

  • You use Microsoft SQL Server 2016 Reporting Services (SSRS 2016).
  • You set the locale and keyboard language to English (EN-US).
  • You create a ReportSubscription that contains a Date/Time parameter.
  • Another user editsthe Subscription and changes the parameter by using a different locale and keyboard language, for example: French-FR (FR-FR).

In this scenario, when youopen the Subscriptions of the Report or the My Subscription Page, you notice that none of them is visible. Additionally, you may receive an error message that resembles thefollowing:

Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!2e!DateTime:: e ERROR: [3xtf6s8t]: OData exception occurred: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.FormatException: String was not recognized as a valid DateTime.

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section. 

Resolution


The issue is fixed in the following cumulative update for SQL Server:
About cumulative updates for SQL Server:

Each new cumulative update for SQL Server contains all thehotfixes and all the security fixes that were included with the previouscumulative update. Check out the latest cumulative updates for SQL Server:

Workaround


To work around the issue, you could manually delete the invalid subscriptions from the Report Server Database.

References


Learn about the terminology thatMicrosoft uses to describe software updates.