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

"The language 'xx' is not available" when saving certain pages

Vote:
 

Hello,

I've got a problem that seems to have begun all the sudden. Some pages on our site cannot be saved anymore. All pages have worked just fine recently, and i can't figure out what has changed. The error i get is as below. The swedish language works just fine, and all the pages which cannot be saved, can be viewed. Any ideas?

[InvalidOperationException: The language 'sv' is not available]
   EPiServer.DataAccess.Internal.ContentSaveDB.CreateNewVersion(IDatabaseExecutor executor, IContent content, Nullable`1 baseVersion, String currentUser, ContentSaveCommand saveCommand) +1363
   EPiServer.DataAccess.Internal.<>c__DisplayClass27_0.<SaveInternal>b__0() +140
   EPiServer.Data.Providers.Internal.<>c__DisplayClass32_0.<ExecuteTransaction>b__0() +18
   EPiServer.Data.Providers.Internal.<>c__DisplayClass33_0`1.<ExecuteTransaction>b__0() +60
   EPiServer.Data.Providers.SqlTransientErrorsRetryPolicy.Execute(Func`1 method) +70
   EPiServer.DataAccess.Internal.ContentSaveDB.SaveInternal(IContent content, SaveOptions options) +266
   EPiServer.DataAccess.Internal.ContentSaveDB.Save(IContent content, SaveAction action, String currentUser) +240
   EPiServer.Core.Internal.DefaultContentProviderDatabase.Save(IContent content, SaveAction action, String currentUser) +293
   EPiServer.Core.Internal.DefaultContentProvider.Save(IContent content, SaveAction action) +79
   EPiServer.Core.Internal.DefaultContentRepository.Save(IContent content, SaveAction action, AccessLevel access) +773
   EPiServer.Cms.Shell.Service.Internal.ContentService.Save(IContent content, SaveAction saveAction, AccessLevel accessLevel) +93
   EPiServer.Cms.Shell.Service.Internal.ContentService.CreateDraft(ContentReference contentLink, Boolean setAsCommonDraft) +606
   EPiServer.Cms.Shell.UI.Rest.Internal.ContentVersionStore.Post(CreateContentVersionViewModel entity) +240
   lambda_method(Closure , ControllerBase , Object[] ) +139
   System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters) +35
   System.Web.Mvc.Async.<>c.<BeginInvokeSynchronousActionMethod>b__9_0(IAsyncResult asyncResult, ActionInvocation innerInvokeState) +39
   System.Web.Mvc.Async.WrappedAsyncResult`2.CallEndDelegate(IAsyncResult asyncResult) +77
   System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethod(IAsyncResult asyncResult) +42
   System.Web.Mvc.Async.<>c__DisplayClass11_0.<InvokeActionMethodFilterAsynchronouslyRecursive>b__0() +80
   System.Web.Mvc.Async.<>c__DisplayClass11_2.<InvokeActionMethodFilterAsynchronouslyRecursive>b__2() +396
   System.Web.Mvc.Async.<>c__DisplayClass11_2.<InvokeActionMethodFilterAsynchronouslyRecursive>b__2() +396
   System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethodWithFilters(IAsyncResult asyncResult) +42
   System.Web.Mvc.Async.<>c__DisplayClass3_6.<BeginInvokeAction>b__4() +50
   System.Web.Mvc.Async.<>c__DisplayClass3_1.<BeginInvokeAction>b__1(IAsyncResult asyncResult) +188
   System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeAction(IAsyncResult asyncResult) +38
   EPiServer.Shell.Services.Rest.RestControllerBase.EndExecute(IAsyncResult asyncResult) +63
   System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +431
   System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step) +75
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +158

#278329
Apr 11, 2022 17:02
Vote:
 

Hi Jonas,

Thank you very much for sharing your findings. Just adding here in case if some one else also get the same issue.

The cause

This error is an effect of enabling database replication. The error occur on larger pages (that is, long content in one property like MainBody). It also efffetcs tasks like import data in Optimizely.

The solution

Configure SQL Server to allow larger fields to replicate. The default value is 65536 bytes. This can be configured with something like:

EXEC sp_configure 'show advanced options', 1 ;

RECONFIGURE ;

GO

EXEC sp_configure 'max text repl size', 2097152 ;

GO

RECONFIGURE;

GO

Thanks,
Kosala
#291491
Nov 11, 2022 13:22
* 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.