Primary keys of aggregation tables are not case sensitive in MySQL and MSSQL.Therefore an error regarding a primary key violation is thrown when trying to insert a new record with the same values as an existing one, but different in the case of characters.
Therefore we need to add collation level of case sensitivity to the databases.
Suggested Labels:
Stream Processor
Description:
Primary keys of aggregation tables are not case sensitive in MySQL and MSSQL.Therefore an error regarding a primary key violation is thrown when trying to insert a new record with the same values as an existing one, but different in the case of characters. Therefore we need to add collation level of case sensitivity to the databases. Suggested Labels: Stream Processor
Affected Product Version: WSO2-SP WSO2-APIM-Analytics WSO2-EI-Analytics WSO2-IS-Analytics
OS, DB, other environment details and versions:
Microsoft SQL database server MySQL