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

AI OnAI Off

Upgrade 10.10.3 to 11.14.0 SqlException

ABjorck
ABjorck
Vote:
 

Hello Epi people!

After upgrading I'm getting an error when changing any property i Edit mode. The friendly message is simply "Something went wrong", "An unexpected error occurred". The config and database schema updates have been run without any errors reported. Everything else seems to be working fine.

The following exception is logged. Any suggestions would be greatly appreciated!

2020-01-16 10:38:41,019 [43] ERROR EPiServer.Cms.Shell.UI.Rest.ContentChangeManager: Unexpected error when saving 352_13626
System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'netPropertySave' expects parameter '@ContentId', which was not supplied.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at 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)
   at 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)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at EPiServer.DataAccess.Internal.ContentSaveDB.SaveContentVersionProperty(IDatabaseExecutor executor, IContent content)
   at EPiServer.DataAccess.Internal.ContentSaveDB.<>c__DisplayClass27_0.<SaveInternal>b__0()
   at EPiServer.Data.Providers.Internal.SqlDatabaseExecutor.<>c__DisplayClass32_0.<ExecuteTransaction>b__0()
   at EPiServer.Data.Providers.Internal.SqlDatabaseExecutor.<>c__DisplayClass33_0`1.<ExecuteTransaction>b__0()
   at EPiServer.Data.Providers.SqlTransientErrorsRetryPolicy.Execute[TResult](Func`1 method)
   at EPiServer.DataAccess.Internal.ContentSaveDB.SaveInternal(IContent content, SaveOptions options)
   at EPiServer.DataAccess.Internal.ContentSaveDB.Save(IContent content, SaveAction action, String currentUser)
   at EPiServer.Core.Internal.DefaultContentProviderDatabase.Save(IContent content, SaveAction action, String currentUser)
   at EPiServer.Core.Internal.DefaultContentProvider.Save(IContent content, SaveAction action)
   at EPiServer.Core.Internal.DefaultContentRepository.Save(IContent content, SaveAction action, AccessLevel access)
   at EPiServer.Cms.Shell.Service.Internal.ContentService.Save(IContent content, SaveAction saveAction, AccessLevel accessLevel)
   at EPiServer.Cms.Shell.UI.Rest.ContentChangeManager.UpdateContentProperties(ContentReference contentReference, IDictionary`2 properties, SaveAction saveAction)
ClientConnectionId:0cd5ac0b-4c33-4814-af1e-5c4f3be61d7e
Error Number:201,State:4,Class:16

Here is my packages.config file for version info:

<?xml version="1.0" encoding="utf-8"?>
<packages>
  <package id="ActionParameterAlias" version="6.0.0" targetFramework="net461" />
  <package id="Antlr" version="3.4.1.9004" targetFramework="net461" />
  <package id="AutoMapper" version="6.2.2" targetFramework="net461" />
  <package id="BuildWebCompiler" version="1.11.375" targetFramework="net461" />
  <package id="BVN.404Handler" version="11.3.0" targetFramework="net461" />
  <package id="Castle.Core" version="4.2.1" targetFramework="net461" />
  <package id="Castle.Windsor" version="4.1.0" targetFramework="net461" />
  <package id="EntityFramework" version="6.1.3" targetFramework="net461" />
  <package id="EPiServer.AddOns.Helpers" version="0.4.0.0" targetFramework="net461" />
  <package id="EPiServer.CMS" version="11.14.0" targetFramework="net461" />
  <package id="EPiServer.CMS.AspNet" version="11.14.0" targetFramework="net461" />
  <package id="EPiServer.CMS.Core" version="11.14.0" targetFramework="net461" />
  <package id="EPiServer.CMS.TinyMce" version="2.9.0" targetFramework="net461" />
  <package id="EPiServer.CMS.UI" version="11.23.3" targetFramework="net461" />
  <package id="EPiServer.CMS.UI.Core" version="11.23.3" targetFramework="net461" />
  <package id="EPiServer.Forms" version="4.27.0" targetFramework="net461" />
  <package id="EPiServer.Forms.Core" version="4.27.0" targetFramework="net461" />
  <package id="EPiServer.Forms.UI" version="4.27.0" targetFramework="net461" />
  <package id="EPiServer.Framework" version="11.14.0" targetFramework="net461" />
  <package id="EPiServer.Framework.AspNet" version="11.14.0" targetFramework="net461" />
  <package id="EPiServer.Logging.Log4Net" version="2.2.2" targetFramework="net461" />
  <package id="EPiServer.Packaging" version="3.4.0" targetFramework="net461" />
  <package id="EPiServer.Packaging.UI" version="3.4.0" targetFramework="net461" />
  <package id="EPiServer.Search" version="9.0.3" targetFramework="net461" />
  <package id="EPiServer.Search.Cms" version="9.0.3" targetFramework="net461" />
  <package id="EPiServer.ServiceLocation.StructureMap" version="2.0.3" targetFramework="net461" />
  <package id="log4net" version="2.0.8" targetFramework="net461" />
  <package id="Lucene.Net" version="3.0.3" targetFramework="net461" />
  <package id="Microsoft.AspNet.Mvc" version="5.2.3" targetFramework="net461" />
  <package id="Microsoft.AspNet.Providers.Core" version="2.0.0" targetFramework="net461" />
  <package id="Microsoft.AspNet.Razor" version="3.2.3" targetFramework="net461" />
  <package id="Microsoft.AspNet.Web.Optimization" version="1.1.3" targetFramework="net461" />
  <package id="Microsoft.AspNet.Web.Optimization.cs" version="1.1.3" targetFramework="net461" />
  <package id="Microsoft.AspNet.WebApi" version="5.2.3" targetFramework="net461" />
  <package id="Microsoft.AspNet.WebApi.Client" version="5.2.3" targetFramework="net461" />
  <package id="Microsoft.AspNet.WebApi.Core" version="5.2.3" targetFramework="net461" />
  <package id="Microsoft.AspNet.WebApi.WebHost" version="5.2.3" targetFramework="net461" />
  <package id="Microsoft.AspNet.WebPages" version="3.2.3" targetFramework="net461" />
  <package id="Microsoft.CodeDom.Providers.DotNetCompilerPlatform" version="1.0.8" targetFramework="net461" />
  <package id="Microsoft.Net.Compilers" version="2.4.0" targetFramework="net461" developmentDependency="true" />
  <package id="Microsoft.Tpl.Dataflow" version="4.5.24" targetFramework="net461" />
  <package id="Microsoft.Web.Infrastructure" version="1.0.0.0" targetFramework="net461" />
  <package id="Microsoft.Web.Xdt" version="2.1.1" targetFramework="net461" />
  <package id="Microsoft.VisualStudio.SlowCheetah" version="3.0.61" targetFramework="net461" />
  <package id="Newtonsoft.Json" version="10.0.3" targetFramework="net461" />
  <package id="NuGet.Core" version="2.7.2" targetFramework="net461" />
  <package id="Postal.Mvc5" version="1.2.0" targetFramework="net461" />
  <package id="RazorEngine" version="3.4.1" targetFramework="net461" />
  <package id="SharpZipLib" version="0.86.0" targetFramework="net461" />
  <package id="Sigil" version="4.7.0" targetFramework="net461" />
  <package id="StructureMap" version="4.7.1" targetFramework="net461" />
  <package id="structuremap.web" version="4.0.0.315" targetFramework="net461" />
  <package id="structuremap.web-signed" version="3.1.6.191" targetFramework="net461" />
  <package id="structuremap-signed" version="3.1.9.463" targetFramework="net461" />
  <package id="System.ComponentModel.Annotations" version="4.4.0" targetFramework="net461" />
  <package id="System.Data.SqlClient" version="4.8.0" targetFramework="net461" />
  <package id="System.Reflection.Emit" version="4.3.0" targetFramework="net461" />
  <package id="System.Reflection.Emit.Lightweight" version="4.3.0" targetFramework="net461" />
  <package id="System.Security.AccessControl" version="4.5.0" targetFramework="net461" />
  <package id="System.Security.Cryptography.Xml" version="4.5.0" targetFramework="net461" />
  <package id="System.Security.Permissions" version="4.5.0" targetFramework="net461" />
  <package id="System.Security.Principal.Windows" version="4.5.0" targetFramework="net461" />
  <package id="System.Threading.AccessControl" version="4.4.0" targetFramework="net461" />
  <package id="System.ValueTuple" version="4.5.0" targetFramework="net461" />
  <package id="WebGrease" version="1.5.2" targetFramework="net461" />
</packages>

Cheers! /AHBjorck

#215894
Jan 16, 2020 21:28
Ravindra S. Rathore
Ravindra S. Rathore
Vote:
 

Hi ABjorck,

I faced this issue in one of my projects but in my case, the bacpac file I received from the client is in read-only mode so can you please grab the new copy of the database, make sure it is in read-write mode and then try once again.

#215905
Jan 17, 2020 9:07
ABjorck
ABjorck
Vote:
 

Hi, thank you for replying and sorry for my tardy reponse. I've been away from this endeavour for a while, back at it :-)

In my case, I'm running Epi on premise for the client (not DXC/DXP/Azure). The upgrade, including the database migrations ran without any errors reported. As far as I can see there is nothing read-only anywhere, database or otherwise.

#217059
Feb 14, 2020 9:21
* 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.