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

Jonas Lindau

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