ICA and SQL Server localization

Products

• Information Centric Analytics

Issue/Introduction

Information Centric Analytics (ICA) is installed with a localized copy of Microsoft SQL Server and both the ICA installation logs and RiskFabric Processing logs show data type conversion errors from nvarchar to datetime. The following examples are from an environment running SQL Server localized for Brazilian Portuguese:

Installation

Error - Initialize SQL Tables
System.Data.SqlClient.SqlException (0x80131904): Falha ao converter data e/ou hora da cadeia de caracteres.

Log_DataTransformation

Error Msg: Procedure=spUpdateLDW_SymantecDLP,Error=A conversão de um tipo de dados varchar em um tipo de dados datetime resultou em um valor fora do intervalo.; Line  Number: 135

Error Msg: A conversão de um tipo de dados varchar em um tipo de dados datetime resultou em um valor fora do intervalo. Line  Number: 129

Error Msg: Exit processing of ScenarioID = 3007 Falha ao converter data e/ou hora da cadeia de caracteres. Line  Number: 341

Environment

Release : 6.x

Cause

ICA requires the English-language, case-insensitive version of SQL Server Enterprise.

Resolution

To install ICA after attempting to install using a localized version of SQL Server, follow this procedure:

1. Uninstall ICA using the ICA Installation Wizard
2. Uninstall the localized version of SQL Server and install the English-language version of SQL Server
3. Install the English-language, case insensitive version of SQL Server Enterprise
4. Install ICA using the ICA Installation Wizard

Additional Information

Local Language Versions in SQL Server

https://learn.microsoft.com/en-us/sql/sql-server/install/local-language-versions-in-sql-server?view=sql-server-ver16

Collations and Case Sensitivity

https://learn.microsoft.com/en-us/ef/core/miscellaneous/collations-and-case-sensitivity