Knowledge Base

The VMware Knowledge Base provides support solutions, error messages and troubleshooting guides
 
Search the VMware Knowledge Base (KB)   View by Article ID
 

Collation conflicts occur in SQL Server databases when upgrading VMware Service Manager

Symptoms

  • Collation conflicts occur in SQL Server databases when upgrading or patching VMware Service Manager
  • Upgraded VMware Service Manager system shows collation conflicts as indicated by this message in DebugView trace:

    Cannot resolve collation conflict for equal to operation
  • You this error when running database upgrade as a part of applying a Rolling Patch:

Implicit conversion of varchar value to varchar cannot be performed because the collation of the value is unresolved due to a collation conflict.

Resolution

Collation conflicts can appear after moving a database between servers, and then running an upgrade script. When new tables are created in through an upgrade process, they may have conflicting collations associated with them if the servers are running under different locales or if the original database was created under an earlier version of SQL Server.
 
Collations specify the character set and character sort order for a particular database. The character set refers to the character-to-bit map for each language (in the case of non-unicode character sets), and the sort order refers to the relations between the characters (for example, 'a' is less than 'b'; 'm' is equivalent to 'M', and so on). Note that sort order information for Unicode character sets are also referenced by collations.
 
Unless otherwise specified, the collation of a SQL Server database will default to the locale set on the server. Furthermore, the naming conventions for collations have changed between SQL Server 7.0 and SQL Server 2000/2005/2008.
To resolve this issue, ensure that the collation settings are compatible when upgrading databases. For more information on collation compatibility within SQL Server, see these articles from Microsoft:

Note: The information provided in this link is provided as is and VMware does not guarantee the accuracy or applicability of this information. The preceding links were correct as of June 25, 2011. If you find the link is broken, provide feedback and a VMware employee will update the link.

Request a Product Feature

To request a new product feature or to provide feedback on a VMware product, please visit the Request a Product Feature page.

Feedback

Did this article help you?
This article resolved my issue.
This article did not resolve my issue.
This article helped but additional information was required to resolve my issue.
What can we do to improve this information? (4000 or fewer characters)
Actions
KB: