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

  1. Ensure you have K2 4.7 installed.
  2. Download and Install the K2 4.7 November 2017 Cumulative Update from K2 Partner and Customer Portal.
  3. Get the K2 4.7 November 2017 Cumulative Update FP10 from Regional Support.
  4. Install the K2 4.7 November 2017 Cumulative Update FP10 to apply the fix.