Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Dynamics CRM V9 On-Pre...
Microsoft Dynamics CRM (Archived)

Dynamics CRM V9 On-Premise | Collation Failure using Latin1_General_CI_AS

(0) ShareShare
ReportReport
Posted on by Steve Le Monnier 924

Having waited so long to get my hands on CRM V9 On-Premise, I was frustrated to encounter problems doing a clean install.
I don't know if this is bad luck on my part or a repeatable problem, but this is what I encountered during my install attempts.

Coming from the UK we normally use the SQL Collation Latin1_General_CI_AS (similar to DOCI). This isn't the default as far as CRM is concerned, the product ships with the default collation Latin1_General_CI_AI. And if you install V9 without changing this... it installs just fine.

However, if you change the default collation (to match your SQL Server) the installation crashes with a Collation Change failure on scripts creating foreign keys etc.

Has anybody else encountered this problem?
I was using the EXE install rather than an ISO image

Cheers
Steve

*This post is locked for comments

  • Rickard Norström Profile Picture
    Rickard Norström on at
    RE: Dynamics CRM V9 On-Premise | Collation Failure using Latin1_General_CI_AS

    Unfortunately this did not resolve the collation error.

  • Rickard Norström Profile Picture
    Rickard Norström on at
    RE: Dynamics CRM V9 On-Premise | Collation Failure using Latin1_General_CI_AS

    My Google-fu is weak, I couldn't find that one. Thanks!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Dynamics CRM V9 On-Premise | Collation Failure using Latin1_General_CI_AS

    Microsoft has made a bugfix for this particular issue and has corportated this in update 0.3 which is avalailable here.

    https://www.microsoft.com/en-us/download/details.aspx?id=58153

  • Rickard Norström Profile Picture
    Rickard Norström on at
    RE: Dynamics CRM V9 On-Premise | Collation Failure using Latin1_General_CI_AS

    Any updates on this? I'm facing this issue too. We're unable to upgrade an organization with collation finnish_swedish, or create new ones with that collation.

    I'm also facing issues with user creation, some plugin assembly from MS is missing there.

    Cheers

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Dynamics CRM V9 On-Premise | Collation Failure using Latin1_General_CI_AS

    There is an iso available in the Volume License section, since two weeks. This contains a license.txt file.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Dynamics CRM V9 On-Premise | Collation Failure using Latin1_General_CI_AS

    I promised to send an update regarding the collation issue. Microsoft provided a bugfix which indeed fixed the problems we had. It consists of an updated mdf file which resides in the Languages\XRM\sql\9 folder.

    I'm not sure if I'm allowed to share this file, but I will ask the Microsoft Manager. Keep you posted.

    Cheers Arjan

  • Steve Le Monnier Profile Picture
    Steve Le Monnier 924 on at
    RE: Dynamics CRM V9 On-Premise | Collation Failure using Latin1_General_CI_AS

    Thanks for the confirmation, since the initial on-premise release, news of V9 has been very quite.

    PS. Has anybody been able to get licence keys to transition to V9, we've only been able to develop and test using a demo key, and they only last for 90 days!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Dynamics CRM V9 On-Premise | Collation Failure using Latin1_General_CI_AS

    Microsoft did indeed clarify, that it is a bug an that they are currently working on the fix. When this will be released is unknown

  • crw Profile Picture
    crw 10 on at
    RE: Dynamics CRM V9 On-Premise | Collation Failure using Latin1_General_CI_AS

    Same here:

    17:30:47|   Info| OrganizationCollation Latin1_General_CI_AS selected from UI page
    ...
    17:30:50|   Info| OrganizationInfo.OrganizationCollation: Latin1_General_CI_AS
    ...
    17:30:50|Verbose| The supported collation 'Latin1_General_CI_AI' matches the language of the database's collation 'Latin1_General_CI_AS'
    17:30:50|   Info| The case sensitivity of the database collation is correct.
    17:30:50|   Info| The database collation is correct.
    ...
    17:31:07|  Error| System.Exception: Error.ActionFailed Microsoft.Crm.Tools.Admin.SetDatabaseCollationAction ---> System.Data.SqlClient.SqlException: The statistics 'Attribute.ndx_Attribute_EntityId_ColumnNumber' is dependent on database collation. The database collation cannot be changed if a schema-bound object depends on it. Remove the dependencies on the database collation and then retry the operation.
    The object 'fn_CollectForCascadeShare' is dependent on database collation. The database collation cannot be changed if a schema-bound object depends on it. Remove the dependencies on the database collation and then retry the operation.
    The object 'fn_CollectForCascadeUnShare' is dependent on database collation. The database collation cannot be changed if a schema-bound object depends on it. Remove the dependencies on the database collation and then retry the operation.
    ALTER DATABASE failed. The default collation of database '#####' cannot be set to Latin1_General_CI_AS. 

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Dynamics CRM V9 On-Premise | Collation Failure using Latin1_General_CI_AS

    Hi Steve,

    Let me clarify. The issue is not the installer but the tooling which creates an organization. A default organization will be created automatically when installing Dynamics 365 with a full server configuration. That's why you are getting the error.

    You can install Dynamics 365 v9 without a default organization and create one afterwards. However the Latin1_General_CI_AI collation is the only one without errors.

    Keep you posted.

    Arjan

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans