Try our conversational search powered by Generative AI!

Automatic creation of database schema doesn't work when Find+Marketing is installed

Found in

EPiServer.CMS.Core 11.1.0

Fixed in

EPiServer.CMS.Core 11.10.4

(Or a related package)

Created

Sep 03, 2018

Updated

Oct 05, 2018

Area

CMS Core

State

Closed, Fixed and tested


Description

Steps to reproduce

  1. Create a site with Find installed.
  2. Install EPiServer.Marketing.Testing.
  3. Change the connection string to an empty database.
  4. Add createDatabaseSchema="true" and updateDatabaseSchema="true" to your <episerver.framework>.
  5. Start the site.

Expected:
Should create necessary Episerver database schemas.

Actual:
Failed to execute script because validation failed: 'Not an EPiServer database'

[InvalidOperationException: Failed to execute script because validation failed: 'Not an EPiServer database']
   EPiServer.Data.SchemaUpdates.Internal.<>c__DisplayClass2_0.<ExecuteScripts>b__0() +352
   EPiServer.Data.Providers.Internal.<>c__DisplayClass32_0.<ExecuteTransaction>b__0() +10
   EPiServer.Data.Providers.Internal.<>c__DisplayClass33_0`1.<ExecuteTransaction>b__0() +55
   EPiServer.Data.Providers.SqlTransientErrorsRetryPolicy.Execute(Func`1 method) +45
   EPiServer.Data.Providers.Internal.SqlDatabaseExecutor.ExecuteTransaction(Func`1 action) +125
   EPiServer.Data.Providers.Internal.SqlDatabaseExecutor.ExecuteTransaction(Action action) +90
   EPiServer.Data.SchemaUpdates.Internal.ScriptRunnerImpl.ExecuteScripts(IDatabaseExecutor databaseHandler, IEnumerable`1 streams) +87
   EPiServer.Data.SchemaUpdates.Internal.ScriptExecutorImplementation.ExecuteEmbeddedZippedScripts(String connectionString, Assembly assembly, String resourcePath) +456
   EPiServer.Marketing.Testing.Web.SchemaUpdater.DatabaseVersionValidator.Update(ConnectionStringSettings connectionStringSettings) +70
   EPiServer.Data.SchemaUpdates.Internal.SchemaUpdaterWrapper.Update(ConnectionStringOptions ConnectionStringOption) +23
   EPiServer.Data.SchemaUpdates.Internal.DatabaseSchemaManagerImplementation.EnsureDatabaseSchema(DataAccessOptions dataAccessOptions) +1873
   EPiServer.Data.DataInitialization.ValidateDatabaseSchema(InitializationEngine context) +85
   EPiServer.Data.DataInitialization.Initialize(InitializationEngine context) +25
   EPiServer.Framework.Initialization.Internal.<>c__DisplayClass2_0.<Initialize>b__0() +19
   EPiServer.Framework.Initialization.Internal.ModuleNode.Execute(Action a, String key) +52
   EPiServer.Framework.Initialization.Internal.ModuleNode.Initialize(InitializationEngine context) +80
   EPiServer.Framework.Initialization.InitializationEngine.InitializeModules() +179