November Happy Hour will be moved to Thursday December 5th.

Database error when update CMS 11.10.6 to 11.20.8.

Vote:
 

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:
 

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.