Initialize-EPiDatabase fails for case-sensitive database

Found in

EPiServer.CMS.Core 9.0.3

Created

Nov 10 2017

Updated

Nov 24 2017

Area

CMS Core

State

Closed, Fixed and tested

Voting

Affected? You can raise the priority of a bug by voting for it. By doing so, you will be helping our developers to choose which bug to fix next.

Voting is disabled for closed bugs.

0

Description

Steps to reproduce:
1. In SQL Server/LocalDB: Create a new empty DB having Collation setting for case-sensitive - Collation setting name contains CS e.g. Latin1_General_100_CS_AI
2. Create a new site by using EPiServer.VsIntegration.Package.vsix
3. Edit web.config to point EPiServerDB connection string to the new DB at step #1
4. Run Initialize-EPiDatabase cmdlet (or execute file \packages\EPiServer.CMS.Core.11.1.0*\tools\EPiServer.Cms.Core.sql)

Expected: EPiServerDB is created successfully
Actual: Show exception.

SQL ErrorsCreating [dbo].[netMappedIdentityForProvider]...
Msg 4104, Level 16, State 1, Procedure netMappedIdentityForProvider, Line 7227
The multi-part identifier "Mi.ExistingContentId" could not be bound.
Creating [dbo].[netMappedIdentityGetOrCreate]...
Msg 4104, Level 16, State 1, Procedure netMappedIdentityGetOrCreate, Line 7248
The multi-part identifier "Target.Provider" could not be bound.
Msg 4104, Level 16, State 1, Procedure netMappedIdentityGetOrCreate, Line 7248
The multi-part identifier "Target.ProviderUniqueId" could not be bound.
Creating [dbo].[netActivityLogEntrySave]...
Msg 4104, Level 16, State 1, Procedure netActivityLogEntrySave, Line 15128
The multi-part identifier "Target.To" could not be bound.
Msg 4104, Level 16, State 1, Procedure netActivityLogEntrySave, Line 15128
The multi-part identifier "Target.From" could not be bound.
Msg 4104, Level 16, State 1, Procedure netMappedIdentityForProvider, Line 7 [Batch Start Line 7220]
The multi-part identifier "Mi.ExistingContentId" could not be bound.

Comments