I am running into initialization issues when migrating from CMS 11.15.0 -> CMS 12.8. It seems CMS is having a hard time running a specific SQL script. I have verified the tblBigTable does exist in my CMS Database. If I open SSMS and run the SQL against CMS DB it executes fine, if I try to run it against Commerce DB (it obviously does not work) but does provide the error "Invalid object name 'tblBigTable'"; which leads me to believe something might be configured wrong on my end to where the application is trying to update the Commerce DB.

Error Summary

• Initialize action failed
• Failed to update database during execution of statement '--Update known types in DDS
• Invalid object name 'tblBigTable'.

Attempts to fix

The only way I can get the error to go away (but introduce a new one) is to comment out my AddCmsAspNetIdentity line in Startup. I am using a custom Identity user called SiteUser, which inherits ApplicationUser.

I have also tried running dotnet-episerver update-database.

Full Error Stack

2023-05-24T13:43:07.456670232Z Starting ssh...
2023-05-24T13:43:07.506320602Z Starting OpenBSD Secure Shell server: sshd.
2023-05-24T13:43:07.506616207Z Starting application...
2023-05-24T13:43:12.800033044Z fail: EPiServer.Framework.Initialization.InitializationEngine[0]
2023-05-24T13:43:12.800474051Z       Initialize action failed for 'Initialize on class EPiServer.Data.DataInitialization, EPiServer.Data, Version=12.6.0.0, Culture=neutral, PublicKeyToken=8fe83dea738b45b7'
2023-05-24T13:43:12.801139561Z       System.Data.DataException: Failed to update database during execution of statement '--Update known types in DDS
2023-05-24T13:43:12.801161362Z       UPDATE tblBigTable SET ItemType = 'EPiServer.Personalization.VisitorGroups.Criteria.UserProfileModel, EPiServer.Cms.UI.AspNetIdentity' WHERE StoreName = 'EPiServer.Personalization.VisitorGroups.Criteria.UserProfileModel'
2023-05-24T13:43:12.801168062Z       UPDATE tblBigTableReference SET ElementType = 'EPiServer.Personalization.VisitorGroups.Criteria.UserProfileModel, EPiServer.Cms.UI.AspNetIdentity' WHERE ElementStoreName = 'EPiServer.Personalization.VisitorGroups.Criteria.UserProfileModel'
2023-05-24T13:43:12.801173662Z       IF EXISTS(select * FROM sys.views where name = 'VW_VisitorGroupCriterion')
2023-05-24T13:43:12.801178562Z       BEGIN
2023-05-24T13:43:12.801183362Z       	UPDATE [VW_VisitorGroupCriterion] SET TypeName = 'EPiServer.Personalization.VisitorGroups.Criteria.UserProfileCriterion, EPiServer.Cms.UI.AspNetIdentity' WHERE TypeName = 'EPiServer.Personalization.VisitorGroups.Criteria.UserProfileCriterion, EPiServer.Cms.AspNetCore'
2023-05-24T13:43:12.801190062Z       END
2023-05-24T13:43:12.801194662Z       '
2023-05-24T13:43:12.801199462Z        ---> Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid object name 'tblBigTable'.
2023-05-24T13:43:12.801204662Z          at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
2023-05-24T13:43:12.801209762Z          at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
2023-05-24T13:43:12.801214863Z          at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
2023-05-24T13:43:12.801219463Z          at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
2023-05-24T13:43:12.801224463Z          at Microsoft.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean isAsync, Int32 timeout, Boolean asyncWrite)
2023-05-24T13:43:12.801229463Z          at Microsoft.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry, String methodName)
2023-05-24T13:43:12.801234663Z          at Microsoft.Data.SqlClient.SqlCommand.ExecuteNonQuery()
2023-05-24T13:43:12.801239563Z          at EPiServer.Data.SchemaUpdates.Internal.ScriptRunnerImpl.<>c__DisplayClass5_0.<ExecuteScript>b__0()
2023-05-24T13:43:12.801257863Z       ClientConnectionId:228e6b60-4dcf-400e-a7e6-393ed9cffda8
2023-05-24T13:43:12.801263063Z       Error Number:208,State:1,Class:16
2023-05-24T13:43:12.801267463Z       ClientConnectionId before routing:032aa8d4-99a0-4b8f-ac7d-acf59f2cb103
2023-05-24T13:43:12.801272163Z       Routing Destination:d7e470a0fa81.tr37401.eastus1-a.worker.database.windows.net,11020
2023-05-24T13:43:12.801276564Z          --- End of inner exception stack trace ---
2023-05-24T13:43:12.801281464Z          at EPiServer.Data.SchemaUpdates.Internal.ScriptRunnerImpl.<>c__DisplayClass5_0.<ExecuteScript>b__0()
2023-05-24T13:43:12.801286864Z          at EPiServer.Data.Providers.Internal.SqlDatabaseExecutor.<>c__DisplayClass26_0`1.<ExecuteTransaction>b__0()
2023-05-24T13:43:12.801291564Z          at EPiServer.Data.Providers.Internal.NoRetriesPolicy.Execute[TResult](Func`1 method)
2023-05-24T13:43:12.801296364Z          at EPiServer.Data.Providers.Internal.SqlDatabaseExecutor.ExecuteTransaction[TResult](Func`1 action)
2023-05-24T13:43:12.801300764Z          at EPiServer.Data.SchemaUpdates.Internal.ScriptRunnerImpl.ExecuteScript(IDatabaseExecutor databaseHandler, StreamReader stream)
2023-05-24T13:43:12.801305064Z          at EPiServer.Data.SchemaUpdates.Internal.ScriptRunnerImpl.<>c__DisplayClass2_0.<ExecuteScripts>b__0()
2023-05-24T13:43:12.801309964Z          at EPiServer.Data.Providers.Internal.SqlDatabaseExecutor.<>c__DisplayClass25_0.<ExecuteTransaction>b__0()
2023-05-24T13:43:12.801314864Z          at EPiServer.Data.Providers.Internal.SqlDatabaseExecutor.<>c__DisplayClass26_0`1.<ExecuteTransaction>b__0()
2023-05-24T13:43:12.801342465Z          at EPiServer.Data.Providers.SqlTransientErrorsRetryPolicy.Execute[TResult](Func`1 method)
2023-05-24T13:43:12.801349065Z          at EPiServer.Data.Providers.Internal.SqlDatabaseExecutor.ExecuteTransaction[TResult](Func`1 action)
2023-05-24T13:43:12.801353865Z          at EPiServer.Data.Providers.Internal.SqlDatabaseExecutor.ExecuteTransaction(Action action)
2023-05-24T13:43:12.801428566Z          at EPiServer.Data.SchemaUpdates.Internal.ScriptRunnerImpl.ExecuteScripts(IDatabaseExecutor databaseHandler, IEnumerable`1 streams)
2023-05-24T13:43:12.801510867Z          at EPiServer.Data.SchemaUpdates.Internal.ScriptExecutorImplementation.ExecuteScript(String connectionString, Stream stream)
2023-05-24T13:43:12.801519467Z          at EPiServer.Cms.UI.AspNetIdentity.Schema.AspNetIdentitySchemaUpdater`1.Update(ConnectionStringOptions connectionStringOptions)
2023-05-24T13:43:12.801573168Z          at EPiServer.Data.SchemaUpdates.Internal.DatabaseSchemaManagerImplementation.EnsureDatabaseSchema(DataAccessOptions dataAccessOptions)
2023-05-24T13:43:12.801580668Z          at EPiServer.Data.DataInitialization.ValidateDatabaseSchema(InitializationEngine context)
2023-05-24T13:43:12.801585868Z          at EPiServer.Data.DataInitialization.Initialize(InitializationEngine context)
2023-05-24T13:43:12.801711470Z          at EPiServer.Framework.Initialization.Internal.ModuleNode.<>c__DisplayClass4_0.<Initialize>b__0()
2023-05-24T13:43:12.801729671Z          at EPiServer.Framework.Initialization.Internal.ModuleNode.Execute(Action a, String key)
2023-05-24T13:43:12.801788971Z          at EPiServer.Framework.Initialization.Internal.ModuleNode.Initialize(InitializationEngine context)
2023-05-24T13:43:12.801796272Z          at EPiServer.Framework.Initialization.InitializationEngine.InitializeModules()

Startup.cs File

public void ConfigureServices(IServiceCollection services)
        {
            services.Configure<DataAccessOptions>(options => options.ConnectionStrings.Add(new ConnectionStringOptions
            {
                Name = "EcfSqlConnection",
                ConnectionString = _configuration.GetConnectionString("EcfSqlConnection")
            }));
            
            services.AddCmsAspNetIdentity<SiteUser>(o =>
            {
                if (string.IsNullOrEmpty(o.ConnectionStringOptions?.ConnectionString))
                {
                    o.ConnectionStringOptions = new ConnectionStringOptions
                    {
                        Name = "EcfSqlConnection",
                        ConnectionString = _configuration.GetConnectionString("EcfSqlConnection")
                    };
                }
            },
            null,
            null,
            builder =>
                builder.MigrationsAssembly("Evoqua.Core"));

            services.AddTransient<IPasswordHasher<SiteUser>, FallbackPasswordHasher<SiteUser>>();

            services.AddMvc(o => o.Conventions.Add(new FeatureConvention())).AddRazorOptions(ro => ro.ViewLocationExpanders.Add(new FeatureViewLocationExpander()));
            
            if (_webHostingEnvironment.IsDevelopment())
            {
                services.Configure<ClientResourceOptions>(uiOptions =>
                {
                    uiOptions.Debug = true;
                });
            }
            else
            {
                services.AddCmsCloudPlatformSupport(_configuration);
                services.AddCommerceCloudPlatformSupport(_configuration);
            }
            
            services.AddCommerce();
            services.AddFind();
            services.AddGetaCategories();
            services.AddMaxMindGeolocationProvider(o =>
            {
                o.DatabasePath = Path.Combine(_webHostingEnvironment.ContentRootPath, "App_Data", "GeoLite2-City.mmdb");
                o.LocationsDatabasePath = Path.Combine(_webHostingEnvironment.ContentRootPath, "App_Data", "GeoLite2-City-Locations-en.csv");
            });

            services.AddDbContext<CommerceDbContext>(options => options.UseSqlServer(_configuration.GetConnectionString("EcfSqlConnection")));

            SetTinyMceSettings(services);
        }

        public void Configure(IApplicationBuilder app, IWebHostEnvironment env)
        {
            app.UseNotFoundHandler();
            if (env.IsDevelopment())
            {
                app.UseDeveloperExceptionPage();
            }

            app.UseGetaCategories();
            app.UseGetaCategoriesFind();

            app.UseAnonymousId();
            app.UseStaticFiles();
            app.UseRouting();
            app.UseCors();
            app.UseAuthentication();
            app.UseAuthorization();
            app.UseEndpoints(endpoints =>
            {
                endpoints.MapControllerRoute(name: "Default", pattern: "{controller}/{action}/{id?}");
                endpoints.MapControllers();
                endpoints.MapRazorPages();
                endpoints.MapContent();
            });

            HttpContextHelper.Configure(app.ApplicationServices.GetRequiredService<IHttpContextAccessor>());
            WebHostHelper.Configure(app.ApplicationServices.GetRequiredService<IWebHostEnvironment>());
            
            var factory = app.ApplicationServices.GetService<IServiceScopeFactory>();
            
            using var scope = factory.CreateScope();
            using var context = scope.ServiceProvider.GetRequiredService<CommerceDbContext>();
            
            context.Database.Migrate();
        }

CMS Package List