Copied to clipboard

Flag this post as spam?

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


  • Valentin Valeanu 22 posts 145 karma points
    15 days ago
    Valentin Valeanu
    0

    Error when upgrading from Umbraco 7.15.3 to Umbraco 8.1.1 (unexpected data in grid values occurred)

    Hi Umbraco,

    Today I tried upgrading from version 7.15.3 to version 8.1.1, and in doing this I was following this article. Unfortunately I have stumbled upon this error message:

    error 1

    I went to /App_Data/Logs/ and this is how the last lines of the log file look like. It seems that it's something related to ConvertTinyMceAndGridMediaUrlsToLocalLink but I am not able to figure out what can be wrong.

    Can somebody help me, I would really appreciate.

    {"@t":"2020-06-24T06:33:07.5285865Z","@mt":"Execute {MigrationType}","MigrationType":"ConvertTinyMceAndGridMediaUrlsToLocalLink","SourceContext":"Umbraco.Core.Migrations.MigrationPlan","ProcessId":39148,"ProcessName":"iisexpress","ThreadId":17,"AppDomainId":10,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"PC13","Log4NetLevel":"INFO ","HttpRequestNumber":7,"HttpRequestId":"59a7fbed-318e-4eac-b994-843dc8fd397d"} {"@t":"2020-06-24T06:33:22.9894970Z","@mt":"Database configuration failed","@l":"Error","@x":"System.AggregateException: One or more errors related to unexpected data in grid values occurred. --- System.InvalidOperationException: Cannot deserialize the value as json. This can be because the property editor type is changed from another type into a grid. Old versions of the value in this property can have the structure from the old property editor type. This needs to be changed manually before updating the database.\nProperty info: Id = 4, LanguageId = , VersionId = 2, Value = Navigation --- Newtonsoft.Json.JsonReaderException: Error parsing NaN value. Path '', line 1, position 2.\r\n at Newtonsoft.Json.JsonTextReader.ParseNumberNaN(ReadType readType, Boolean matched)\r\n at Newtonsoft.Json.JsonTextReader.ParseValue()\r\n at Newtonsoft.Json.JsonReader.ReadForType(JsonContract contract, Boolean hasConverter)\r\n at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.Deserialize(JsonReader reader, Type objectType, Boolean checkAdditionalContent)\r\n at Newtonsoft.Json.JsonSerializer.DeserializeInternal(JsonReader reader, Type objectType)\r\n at Newtonsoft.Json.JsonConvert.DeserializeObject(String value, Type type, JsonSerializerSettings settings)\r\n at Newtonsoft.Json.JsonConvert.DeserializeObject[T](String value, JsonSerializerSettings settings)\r\n at Umbraco.Core.Migrations.Upgrade.V810.ConvertTinyMceAndGridMediaUrlsToLocalLink.Migrate()\r\n --- End of inner exception stack trace ---\r\n --- End of inner exception stack trace ---\r\n at Umbraco.Core.Migrations.Upgrade.V810.ConvertTinyMceAndGridMediaUrlsToLocalLink.Migrate()\r\n at Umbraco.Core.Migrations.MigrationBase.Umbraco.Core.Migrations.IMigration.Migrate()\r\n at Umbraco.Core.Migrations.MigrationPlan.Execute(IScope scope, String fromState, IMigrationBuilder migrationBuilder, ILogger logger)\r\n at Umbraco.Core.Migrations.Upgrade.Upgrader.Execute(IScopeProvider scopeProvider, IMigrationBuilder migrationBuilder, IKeyValueService keyValueService, ILogger logger)\r\n at Umbraco.Core.Migrations.Install.DatabaseBuilder.UpgradeSchemaAndData(MigrationPlan plan)\r\n--- (Inner Exception #0) System.InvalidOperationException: Cannot deserialize the value as json. This can be because the property editor type is changed from another type into a grid. Old versions of the value in this property can have the structure from the old property editor type. This needs to be changed manually before updating the database.\nProperty info: Id = 4, LanguageId = , VersionId = 2, Value = Navigation --- Newtonsoft.Json.JsonReaderException: Error parsing NaN value. Path '', line 1, position 2.\r\n at Newtonsoft.Json.JsonTextReader.ParseNumberNaN(ReadType readType, Boolean matched)\r\n at Newtonsoft.Json.JsonTextReader.ParseValue()\r\n at Newtonsoft.Json.JsonReader.ReadForType(JsonContract contract, Boolean hasConverter)\r\n at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.Deserialize(JsonReader reader, Type objectType, Boolean checkAdditionalContent)\r\n at Newtonsoft.Json.JsonSerializer.DeserializeInternal(JsonReader reader, Type objectType)\r\n at Newtonsoft.Json.JsonConvert.DeserializeObject(String value, Type type, JsonSerializerSettings settings)\r\n at Newtonsoft.Json.JsonConvert.DeserializeObject[T](String value, JsonSerializerSettings settings)\r\n at Umbraco.Core.Migrations.Upgrade.V810.ConvertTinyMceAndGridMediaUrlsToLocalLink.Migrate()\r\n --- End of inner exception stack trace ---<---\r\n\r\n--- (Inner Exception #1) System.InvalidOperationException: Cannot deserialize the value as json. This can be because the property editor type is changed from another type into a grid. Old versions of the value in this property can have the structure from the old property editor type. This needs to be changed manually before updating the database.\nProperty info: Id = 6, LanguageId = , VersionId = 3, Value = Navigation --- Newtonsoft.Json.JsonReaderException: Error parsing NaN value. Path '', line 1, position 2.\r\n at Newtonsoft.Json.JsonTextReader.ParseNumberNaN(ReadType readType, Boolean matched)\r\n at Newtonsoft.Json.JsonTextReader.ParseValue()\r\n at Newtonsoft.Json.JsonReader.ReadForType(JsonContract contract, Boolean hasConverter)\r\n at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.Deserialize(JsonReader reader, Type objectType, Boolean checkAdditionalContent)\r\n at Newtonsoft.Json.JsonSerializer.DeserializeInternal(JsonReader reader, Type objectType)\r\n at Newtonsoft.Json.JsonConvert.DeserializeObject(String value, Type type, JsonSerializerSettings settings)\r\n at Newtonsoft.Json.JsonConvert.DeserializeObject[T](String value, JsonSerializerSettings settings)\r\n at Umbraco.Core.Migrations.Upgrade.V810.ConvertTinyMceAndGridMediaUrlsToLocalLink.Migrate()\r\n --- End of inner exception stack trace ---<---\r\n\r\n--- (Inner Exception #2) System.InvalidOperationException: Cannot deserialize the value as json. This can be because the property editor type is changed from another type into a grid. Old versions of the value in this property can have the structure from the old property editor type. This needs to be changed manually before updating the database.\nProperty info: Id = 17, LanguageId = , VersionId = 9, Value =

    810.ConvertTinyMceAndGridMediaUrlsToLocalLink.Migrate()\r\n --- End of inner exception stack trace ---<---\r\n\r\n--- (Inner Exception #3) System.InvalidOperationException: Cannot deserialize the value as json. This can be because the property editor type is changed from another type into a grid. Old versions of the value in this property can have the structure from the old property editor type. This needs to be changed manually before updating the database.\nProperty info: Id = 19, LanguageId = , VersionId = 10, Value =

    810.ConvertTinyMceAndGridMediaUrlsToLocalLink.Migrate()\r\n --- End of inner exception stack trace ---<---\r\n\r\n--- (Inner Exception #4) System.InvalidOperationException: Cannot deserialize the value as json. This can be because the property editor type is changed from another type into a grid. Old versions of the value in this property can have the structure from the old property editor type. This needs to be changed manually before updating the database.\nProperty info: Id = 21, LanguageId = , VersionId = 11, Value =

    81_0.ConvertTinyMceAndGridMediaUrlsToLocalLink.Migrate()\r\n --- End of inner exception stack trace ---<---\r\n","SourceContext":"Umbraco.Core.Migrations.Install.DatabaseBuilder","ProcessId":39148,"ProcessName":"iisexpress","ThreadId":17,"AppDomainId":10,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"PC13","Log4NetLevel":"ERROR","HttpRequestNumber":7,"HttpRequestId":"59a7fbed-318e-4eac-b994-843dc8fd397d"}

  • D K M J 69 posts 202 karma points
    1 week ago
    D K M J
    0

    Hey Valentines,

    When migrating from V7 - V8 ,we need to ensure about the data type and the packages used,because some data types are not supported for V8.

    Most probably the issue is related with obsolete data type.

  • Valentin Valeanu 22 posts 145 karma points
    1 week ago
    Valentin Valeanu
    0

    Hey there, I don't seem to have any (Obsolete) data types.

    I had them in the beginning but I replaced them with newer types. Moreover, some of them I had to delete because they didn't have a new type.

    Maybe it's something related to this error ? I found out that it has been solved in 8.1.1 so I am not sure why I am still experiencing it.

Please Sign in or register to post replies

Write your reply to:

Draft