I have a website from an Umbraco site that is the latest 8 version, 8.18.5.
I have create a project with version 9.0.0.
When I start the site pointing to that database I get the following error:
The database failed to upgrade. ERROR: The database configuration failed with the following message: The migration plan does not support migrating from state {03482BB0-CF13-475C-845E-ECB8319DBE3C}
Thanks. Still I don't know why it has an incorrect value and what I should do to upgrade. I have not altered the database or done anything special.
I tried with a clean restore of the database and did according to the second link; to first boot up and install a new database, and then I changed to the version 8 database. But I still get the same error.
In the installation wizard it says "Detected current version (03482bb0), which needs to be upgraded to 9.0.0 (5e02f241)." Seems a bit fishy. Though I cannot understand why...
So, anyone trying to upgrade from version 8.18.5 to 9 -> make sure to upgrade to at least 9.3.1 instead of 9.0.0. Maybe this should be mentioned in the official guides...
{"@t":"2023-10-05T11:11:01.4543898Z","@mt":"Database configuration failed","@l":"Error","@x":"System.InvalidCastException: Invalid cast from 'System.DateTime' to 'System.ValueTuple2[[System.Nullable1[[System.DateTime, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]], mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[System.Nullable`1[[System.DateTime, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]], mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]'.\r\n at System.Convert.DefaultToType(IConvertible value, Type targetType, IFormatProvider provider)\r\n at System.DateTime.System.IConvertible.ToType(Type type, IFormatProvider provider)\r\n at System.Convert.ChangeType(Object value, Type conversionType, IFormatProvider provider)\r\n at NPoco.Database.Dictionary[TKey,TValue](String sql, Object[] args)\r\n at NPoco.Database.Dictionary[TKey,TValue](Sql Sql)\r\n at Umbraco.Core.Migrations.Upgrade.V800.TablesForScheduledPublishing.Migrate() in d:\a\1\s\src\Umbraco.Core\Migrations\Upgrade\V800\TablesForScheduledPublishing.cs:line 17\r\n at Umbraco.Core.Migrations.MigrationBase.Umbraco.Core.Migrations.IMigration.Migrate() in d:\a\1\s\src\Umbraco.Core\Migrations\MigrationBase.cs:line 73\r\n at Umbraco.Core.Migrations.MigrationPlan.Execute(IScope scope, String fromState, IMigrationBuilder migrationBuilder, ILogger logger) in d:\a\1\s\src\Umbraco.Core\Migrations\MigrationPlan.cs:line 309\r\n at Umbraco.Core.Migrations.Upgrade.Upgrader.Execute(IScopeProvider scopeProvider, IMigrationBuilder migrationBuilder, IKeyValueService keyValueService, ILogger logger) in d:\a\1\s\src\Umbraco.Core\Migrations\Upgrade\Upgrader.cs:line 67\r\n at Umbraco.Core.Migrations.Install.DatabaseBuilder.UpgradeSchemaAndData(MigrationPlan plan) in d:\a\1\s\src\Umbraco.Core\Migrations\Install\DatabaseBuilder.cs:line 498","SourceContext":"Umbraco.Core.Migrations.Install.DatabaseBuilder","ProcessId":19460,"ProcessName":"iisexpress","ThreadId":7,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"WEBDEV-2","Log4NetLevel":"ERROR","HttpRequestNumber":12,"HttpRequestId":"79dab6d4-49f9-4221-bb48-bdaba2f34bbf"}
Database failed to upgrade 8.18.5 -> 9.0.0
Hello
I have a website from an Umbraco site that is the latest 8 version, 8.18.5.
I have create a project with version 9.0.0.
When I start the site pointing to that database I get the following error:
The database failed to upgrade. ERROR: The database configuration failed with the following message: The migration plan does not support migrating from state {03482BB0-CF13-475C-845E-ECB8319DBE3C}
Does anyone have a clue?
Regards Fredrik
Hey Fredrik
The umbracoKeyValue table has an incorrect value in it https://github.com/umbraco/Umbraco-CMS/blob/46414f2c646d9a04e2d3614876a7a311cba8653a/src/Umbraco.Infrastructure/Migrations/Upgrade/UmbracoPlan.cs#L252
You might want to look into https://our.umbraco.com/forum/umbraco-9/107301-migrating-umbraco-8-to-9 and https://our.umbraco.com/documentation/Umbraco-Cloud/Upgrades/Migrating-from-8-to-10/
Do you happen to have the keyvalue for 11.1 to 11.2? Logs show it fails at the keyvalue every time.
Hello
Thanks. Still I don't know why it has an incorrect value and what I should do to upgrade. I have not altered the database or done anything special.
I tried with a clean restore of the database and did according to the second link; to first boot up and install a new database, and then I changed to the version 8 database. But I still get the same error.
In the installation wizard it says "Detected current version (03482bb0), which needs to be upgraded to 9.0.0 (5e02f241)." Seems a bit fishy. Though I cannot understand why...
Regards Fredrik
Hey again
Try https://docs.umbraco.com/v/10.x-lts/umbraco-cms/fundamentals/setup/upgrading#run-an-unattended-upgrade
When looking at UpgradePlan source file i see the guid I have seems to be added in version 9.3.1.
https://github.com/umbraco/Umbraco-CMS/commit/3a269ed3293c8e22bd9a546f424402c0a491964f
I will try to upgrade the project to 9.3.1 and see if that works better.
It worked!
So, anyone trying to upgrade from version 8.18.5 to 9 -> make sure to upgrade to at least 9.3.1 instead of 9.0.0. Maybe this should be mentioned in the official guides...
Regards Fredrik
Database configuration failed.
Hello Any one can help me on this error.
{"@t":"2023-10-05T11:11:01.4543898Z","@mt":"Database configuration failed","@l":"Error","@x":"System.InvalidCastException: Invalid cast from 'System.DateTime' to 'System.ValueTuple
2[[System.Nullable1[[System.DateTime, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]], mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[System.Nullable`1[[System.DateTime, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]], mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]'.\r\n at System.Convert.DefaultToType(IConvertible value, Type targetType, IFormatProvider provider)\r\n at System.DateTime.System.IConvertible.ToType(Type type, IFormatProvider provider)\r\n at System.Convert.ChangeType(Object value, Type conversionType, IFormatProvider provider)\r\n at NPoco.Database.Dictionary[TKey,TValue](String sql, Object[] args)\r\n at NPoco.Database.Dictionary[TKey,TValue](Sql Sql)\r\n at Umbraco.Core.Migrations.Upgrade.V800.TablesForScheduledPublishing.Migrate() in d:\a\1\s\src\Umbraco.Core\Migrations\Upgrade\V800\TablesForScheduledPublishing.cs:line 17\r\n at Umbraco.Core.Migrations.MigrationBase.Umbraco.Core.Migrations.IMigration.Migrate() in d:\a\1\s\src\Umbraco.Core\Migrations\MigrationBase.cs:line 73\r\n at Umbraco.Core.Migrations.MigrationPlan.Execute(IScope scope, String fromState, IMigrationBuilder migrationBuilder, ILogger logger) in d:\a\1\s\src\Umbraco.Core\Migrations\MigrationPlan.cs:line 309\r\n at Umbraco.Core.Migrations.Upgrade.Upgrader.Execute(IScopeProvider scopeProvider, IMigrationBuilder migrationBuilder, IKeyValueService keyValueService, ILogger logger) in d:\a\1\s\src\Umbraco.Core\Migrations\Upgrade\Upgrader.cs:line 67\r\n at Umbraco.Core.Migrations.Install.DatabaseBuilder.UpgradeSchemaAndData(MigrationPlan plan) in d:\a\1\s\src\Umbraco.Core\Migrations\Install\DatabaseBuilder.cs:line 498","SourceContext":"Umbraco.Core.Migrations.Install.DatabaseBuilder","ProcessId":19460,"ProcessName":"iisexpress","ThreadId":7,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"WEBDEV-2","Log4NetLevel":"ERROR","HttpRequestNumber":12,"HttpRequestId":"79dab6d4-49f9-4221-bb48-bdaba2f34bbf"}is working on a reply...