Try our conversational search powered by Generative AI!

Initialize-EPiDatabase fails for case-sensitive database

Found in

EPiServer.CMS.Core 9.0.3

Fixed in

EPiServer.CMS.Core 11.2.0

(Or a related package)

Created

Nov 10, 2017

Updated

Nov 27, 2017

Area

CMS Core

State

Closed, Fixed and tested


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 the 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: Shows 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.