KB438708: Error message ‘Cannot resolve the collation conflict between Latin1_General_CI_AS and SQL_Latin1_General_CP1_CI_AS in the equal to operation.’appears when reports run in Developer.

Senior Cloud Support Engineer III • MicroStrategy

Usersee ‘Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.’when running report in Developer with SQL Server warehouse.

Symptom:
Users encounter ‘Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.’when running report in Developer with SQL Server warehouse.


Execute Query failed. Error type: Odbc error. Odbc operation attempted: SQLExecDirect. [42000:468: on *****] [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation. Connection String: DSN=***;DESCRIPTION=***;UID=***;APP=Strategy 9.4 ® Common Files;WSID=***;NETWORK=***;. SQL Statement:***

Cause:
Collation refers to a set of rules that determine how data is sorted and compared. SQL Server allows users to create databases, tables and columns in different collations. If there is a mismatch of two collations in database, errors come up.
Action：
Contact Database Administrator to check the collation of tables accessed by the report, especially the joined columns.

438708

Comment

0 comments

Details

Knowledge Article

Published:

December 21, 2017

Last Updated:

December 21, 2017