Five New Optimizely Certifications are Here! Validate your expertise and advance your career with our latest certification exams. Click here to find out more

Database error when update CMS 11.10.6 to 11.20.8.

Vote:
0

i'm getting an error when trying to update from CMS 11.10.6 to 11.20.8.

I have run the Update-EPiDatabase command and also used export to add semi-colon before all MERGE-statements as instructed in earlier posts. The Stack trace is leading me to Episerver.Forms, however have not touched this package.

Please advise.

Index "IDX_tblContentProperty_ScopeName" on table "tblContentProperty" (specified in the FROM clause) is disabled or resides in a filegroup which is not online.

Stack Trace:

[SqlException (0x80131904): Index "IDX_tblContentProperty_ScopeName" on table "tblContentProperty" (specified in the FROM clause) is disabled or resides in a filegroup which is not online.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +277
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +765
   System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +4239
   System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() +88
   System.Data.SqlClient.SqlDataReader.get_MetaData() +103
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) +621
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) +3382
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) +707
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +83
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +302
   EPiServer.DataAccess.Internal.<>c__DisplayClass10_0.<ListContentOfContentType>b__0() +1067
   EPiServer.Data.Providers.Internal.<>c__DisplayClass31_0`1.<Execute>b__0() +58
   EPiServer.Data.Providers.SqlTransientErrorsRetryPolicy.Execute(Func`1 method) +702
   EPiServer.Forms.EditView.Internal.FormsExtensionsUI.GetExistingForms(IContentTypeRepository contentTypeRepository) +737
   EPiServer.Forms.EditView.Internal.MigrationService.UpdateMissingValueOfRetentionPolicy() +117
   EPiServer.Forms.EditView.InitializationModule.Initialize(InitializationEngine context) +1505
   EPiServer.Framework.Initialization.Internal.ModuleNode.Execute(Action a, String key) +58
   EPiServer.Framework.Initialization.Internal.ModuleNode.Initialize(InitializationEngine context) +123
   EPiServer.Framework.Initialization.InitializationEngine.InitializeModules() +257

[InitializationException: Initialize action failed for Initialize on class EPiServer.Forms.EditView.InitializationModule, EPiServer.Forms.UI, Version=4.22.0.0, Culture=neutral, PublicKeyToken=8fe83dea738b45b7]
   EPiServer.Framework.Initialization.InitializationEngine.InitializeModules() +872
   EPiServer.Framework.Initialization.InitializationEngine.ExecuteTransition(Boolean continueTransitions) +194
   EPiServer.Framework.Initialization.InitializationModule.EngineExecute(HostType hostType, Action`1 engineAction) +879
   EPiServer.Framework.Initialization.InitializationModule.FrameworkInitialization(HostType hostType) +226
   EPiServer.Global..ctor() +42
   xxx.Epi.EPiServerApplication..ctor() in C:\Users\jonasbo\source\repos\xxx.Epi\xxx\xxx.Epi\Global.asax.cs:12
   ASP.global_asax..ctor() +42
#263285
Sep 17, 2021 9:58
Vote:
0

Not sure what the issue was. 

I tried updating to 11.14 first and later to 11.20 which worked.

Now where are on the latest minor release for major version 11.

#293555
Dec 22, 2022 13:27
This topic was created over six months ago and has been resolved. If you have a similar question, please create a new topic and refer to this one.
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.