Sign in Register
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • David McDonnell 53 posts 251 karma points
    Jun 28, 2018 @ 15:33
    David McDonnell
    0

    Upgrade 7.5.14 to 7.6.0

    Hi all I am upgrading from version 7.5.14 to 7.6.0 and receiving the following error at the end of the update and when trying to load the site afterwards

    [SystemException: Read MediaType failed System.SystemException: Read MediaType failed System.Exception: Exception while creating a value. ---> System.InvalidOperationException: There is already an open DataReader associated with this Command which must be closed first. at System.Data.SqlClient.SqlInternalConnectionTds.ValidateConnectionForExecute(SqlCommand command) at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteDbDataReader(CommandBehavior behavior) in c:\Code\github\SamSaffron\MiniProfiler\StackExchange.Profiling\Data\ProfiledDbCommand.cs:line 248 at Umbraco.Core.Persistence.PetaPocoCommandExtensions.<>c__DisplayClass4.<ExecuteReaderWithRetry>b__3() at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func1 func) at Umbraco.Core.Persistence.Database.

    [HttpException (0x80004005): Read MediaType failed System.SystemException: Read MediaType failed System.Exception: Exception while creating a value. ---> System.InvalidOperationException: There is already an open DataReader associated with this Command which must be closed first. at System.Data.SqlClient.SqlInternalConnectionTds.ValidateConnectionForExecute(SqlCommand command) at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteDbDataReader(CommandBehavior behavior) in c:\Code\github\SamSaffron\MiniProfiler\StackExchange.Profiling\Data\ProfiledDbCommand.cs:line 248 at Umbraco.Core.Persistence.PetaPocoCommandExtensions.<>c__DisplayClass4.<ExecuteReaderWithRetry>b__3() at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func1 func) at Umbraco.Core.Persistence.Database.

    [HttpException (0x80004005): Read MediaType failed System.SystemException: Read MediaType failed System.Exception: Exception while creating a value. ---> System.InvalidOperationException: There is already an open DataReader associated with this Command which must be closed first. at System.Data.SqlClient.SqlInternalConnectionTds.ValidateConnectionForExecute(SqlCommand command) at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteDbDataReader(CommandBehavior behavior) in c:\Code\github\SamSaffron\MiniProfiler\StackExchange.Profiling\Data\ProfiledDbCommand.cs:line 248 at Umbraco.Core.Persistence.PetaPocoCommandExtensions.<>c__DisplayClass4.<ExecuteReaderWithRetry>b__3() at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func1 func) at Umbraco.Core.Persistence.Database.

    Copy Link
  • David McDonnell 53 posts 251 karma points
    Jun 28, 2018 @ 16:20
    David McDonnell
    0

    this particular error seems to be related to usync, have updated it to latest version but am receiving an new error now. the headerBackground property is a Media Picker property on a doc type

    [InvalidOperationException: Value "{ "focalPoint": { "left": 0.5, "top": 0.5 }, "src": "/media/3907/femal-header.jpg", "crops": [ { "alias": "thumbnail", "width": 400, "height": 300 }, { "alias": "mobile", "width": 200, "height": 150 }, { "alias": "desktopjumbotron", "width": 1920, "height": 470 }, { "alias": "halfarticle", "width": 750, "height": 240 }, { "alias": "quaterarticle", "width": 360, "height": 230 }, { "alias": "thirdarticle", "width": 500, "height": 300 }, { "alias": "fullwidth", "width": 1200, "height": 450 }, { "alias": "fullarticle", "width": 1200, "height": 400 } ] }" of type "System.String" could not be converted to type "System.Int32" which is expected by property type "headerBackground".] Umbraco.Core.Models.Property.ThrowTypeException(Object value, Type expected, String alias) +177 Umbraco.Core.Models.Property.set_Value(Object value) +701 Umbraco.Core.Persistence.Factories.PropertyFactory.BuildEntity(IReadOnlyCollection1 dtos, PropertyType[] compositionTypeProperties, DateTime createDate, DateTime updateDate) +442 Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase2.GetPropertyCollection(PagingSqlQuery pagingSqlQuery, IReadOnlyCollection1 documentDefs) +2363 Umbraco.Core.Persistence.Repositories.ContentRepository.ProcessQuery(Sql sqlFull, PagingSqlQuery pagingSqlQuery, Boolean withCache, Boolean includeAllVersions) +2072 Umbraco.Core.Persistence.Repositories.ContentRepository.<GetPagedResultsByQuery>b__54(Sql sqlFull, PagingSqlQuery1 pagingSqlQuery) +17 Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase2.GetPagedResultsByQuery(IQuery1 query, Int64 pageIndex, Int32 pageSize, Int64& totalRecords, Tuple2 nodeIdSelect, Func3 processQuery, String orderBy, Direction orderDirection, Boolean orderBySystemField, Func1 defaultFilter) +1796 Umbraco.Core.Persistence.Repositories.ContentRepository.GetPagedResultsByQuery(IQuery1 query, Int64 pageIndex, Int32 pageSize, Int64& totalRecords, String orderBy, Direction orderDirection, Boolean orderBySystemField, IQuery1 filter) +762 Umbraco.Core.Services.ContentService.GetPagedDescendants(Int32 id, Int64 pageIndex, Int32 pageSize, Int64& totalChildren, String orderBy, Direction orderDirection, Boolean orderBySystemField, String filter) +1518 Umbraco.Core.Services.ContentService.GetPagedDescendants(Int32 id, Int64 pageIndex, Int32 pageSize, Int64& totalChildren, String orderBy, Direction orderDirection, String filter) +57 UmbracoExamine.UmbracoContentIndexer.PerformIndexAll(String type) +1169 UmbracoExamine.BaseUmbracoIndexer.IndexAll(String type) +76 UmbracoExamine.BaseUmbracoIndexer.PerformIndexRebuild() +111 UmbracoExamine.BaseUmbracoIndexer.RebuildIndex() +69 Umbraco.Web.WebBootManager.<InitializeResolvers>b__f() +156 Umbraco.Core.Sync.DatabaseServerMessenger.Initialize() +768 Umbraco.Web.BatchedDatabaseServerMessengerStartup.ApplicationStarted(UmbracoApplicationBase umbracoApplication, ApplicationContext applicationContext) +87 Umbraco.Core.ApplicationEventHandler.OnApplicationStarted(UmbracoApplicationBase umbracoApplication, ApplicationContext applicationContext) +50 Umbraco.Core.CoreBootManager.<Complete>b__a(IApplicationEventHandler x) +381 Umbraco.Core.EnumerableExtensions.ForEach(IEnumerable1 items, Action1 action) +166 Umbraco.Core.CoreBootManager.Complete(Action1 afterComplete) +419 Umbraco.Web.WebBootManager.Complete(Action`1 afterComplete) +137 Umbraco.Core.UmbracoApplicationBase.StartApplication(Object sender, EventArgs e) +364

    [HttpException (0x80004005): Value "{ "focalPoint": { "left": 0.5, "top": 0.5 }, "src": "/media/3907/femal-header.jpg", "crops": [ { "alias": "thumbnail", "width": 400, "height": 300 }, { "alias": "mobile", "width": 200, "height": 150 }, { "alias": "desktopjumbotron", "width": 1920, "height": 470 }, { "alias": "halfarticle", "width": 750, "height": 240 }, { "alias": "quaterarticle", "width": 360, "height": 230 }, { "alias": "thirdarticle", "width": 500, "height": 300 }, { "alias": "fullwidth", "width": 1200, "height": 450 }, { "alias": "fullarticle", "width": 1200, "height": 400 } ] }" of type "System.String" could not be converted to type "System.Int32" which is expected by property type "headerBackground".] System.Web.HttpApplicationFactory.EnsureAppStartCalledForIntegratedMode(HttpContext context, HttpApplication app) +535 System.Web.HttpApplication.RegisterEventSubscriptionsWithIIS(IntPtr appContext, HttpContext context, MethodInfo[] handlers) +166 System.Web.HttpApplication.InitSpecial(HttpApplicationState state, MethodInfo[] handlers, IntPtr appContext, HttpContext context) +169 System.Web.HttpApplicationFactory.GetSpecialApplicationInstance(IntPtr appContext, HttpContext context) +372 System.Web.Hosting.PipelineRuntime.InitializeApplication(IntPtr appContext) +329

    [HttpException (0x80004005): Value "{ "focalPoint": { "left": 0.5, "top": 0.5 }, "src": "/media/3907/femal-header.jpg", "crops": [ { "alias": "thumbnail", "width": 400, "height": 300 }, { "alias": "mobile", "width": 200, "height": 150 }, { "alias": "desktopjumbotron", "width": 1920, "height": 470 }, { "alias": "halfarticle", "width": 750, "height": 240 }, { "alias": "quaterarticle", "width": 360, "height": 230 }, { "alias": "thirdarticle", "width": 500, "height": 300 }, { "alias": "fullwidth", "width": 1200, "height": 450 }, { "alias": "fullarticle", "width": 1200, "height": 400 } ] }" of type "System.String" could not be converted to type "System.Int32" which is expected by property type "headerBackground".] System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +525 System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +118 System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context) +708

    Copy Link
  • David McDonnell 53 posts 251 karma points
    Jul 09, 2018 @ 13:55
    David McDonnell
    100

    Thanks to Paul Seal for this post, resolved my issues with upgrading.

    https://codeshare.co.uk/blog/how-to-upgrade-umbraco-safely/

    Cheers David

    Copy Link

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies