Code Fix: A SQL Collation error occurs when the K2 database and SQL server collation differs
KB002196
PRODUCT
Issue Description
When executing a joined SmartObject when the K2 database collation differs from the SQL Server, a SQL error returns.
Error Message
The error states: “Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation. Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation”.
Resolution
- Ensure you have K2 4.7 installed.
- Download and Install the K2 4.7 November 2017 Cumulative Update from K2 Partner and Customer Portal.
- Get the K2 4.7 November 2017 Cumulative Update FP10 from Regional Support.
- Install the K2 4.7 November 2017 Cumulative Update FP10 to apply the fix.