FIX: Error occurs when you filter data with date format that differs from DateTime attribute format setting in MDS 2014
Consider the following scenario:
- Implement a Master Data Services solution on a non-English version of Microsoft SQL Server 2014.
- Create a DateTime attribute, and select "DD/MM/YYYY" from the Input mask list.
- Filter the data on the DateTime attribute in MDS Explorer.
For example, when you filter the data by using a filter criteria in the date format "MM/DD/YYYY" and the day value is larger than 12, you receive the following error message:
241: Database error: Contact your system administrator
The issue was first fixed in the following cumulative update of SQL Server.
About cumulative updates for SQL Server
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Article ID: 3066682 - Last Review: 06/22/2015 14:41:00 - Revision: 1.0
Microsoft SQL Server 2014 Developer, Microsoft SQL Server 2014 Enterprise, Microsoft SQL Server 2014 Standard, Microsoft SQL Server 2014 Service Pack 1
- kbqfe kbfix kbsurveynew kbexpertiseadvanced KB3066682