Press Ctrl / CMD + C to copy this to your clipboard.
This post will be reported to the moderators as potential spam to be looked at
Following this guide and am stuck on step 1: https://our.umbraco.com/documentation/Umbraco-Cloud/Upgrades/Migrating-from-8-to-10/#step-1-content-migration
Steps completed:
-Backup db hosting v8 project
-Create a local v10 site
-Update connection string in appsettings.json
-Enabled unattended upgrades
This is the error I receive: The log shows the migration fails after the 'MigrateLogViewerQueriesFromFileToDb' step. Has anyone else ran into this issue?
Thanks!
Log dump below:
{"@t":"2023-01-10T21:38:47.5668607Z","@mt":"Database upgrade started","SourceContext":"Umbraco.Cms.Infrastructure.Migrations.Install.DatabaseBuilder","ProcessId":30028,"ProcessName":"iisexpress","ThreadId":1,"ApplicationId":"94c2084ae6c1f01f5c2f80848e2e314281b8d6f1","MachineName":"M020193","Log4NetLevel":"INFO "} {"@t":"2023-01-10T21:38:47.6311576Z","@mt":"Starting '{MigrationName}'...","MigrationName":"Umbraco.Core","SourceContext":"Umbraco.Cms.Infrastructure.Migrations.MigrationPlanExecutor","ProcessId":30028,"ProcessName":"iisexpress","ThreadId":1,"ApplicationId":"94c2084ae6c1f01f5c2f80848e2e314281b8d6f1","MachineName":"M020193","Log4NetLevel":"INFO "} {"@t":"2023-01-10T21:38:47.6312040Z","@mt":"At {OrigState}","OrigState":"{03482BB0-CF13-475C-845E-ECB8319DBE3C}","SourceContext":"Umbraco.Cms.Infrastructure.Migrations.MigrationPlanExecutor","ProcessId":30028,"ProcessName":"iisexpress","ThreadId":1,"ApplicationId":"94c2084ae6c1f01f5c2f80848e2e314281b8d6f1","MachineName":"M020193","Log4NetLevel":"INFO "} {"@t":"2023-01-10T21:38:47.6324846Z","@mt":"Execute {MigrationType}","MigrationType":"UpdateCmsPropertyGroupIdSeed","SourceContext":"Umbraco.Cms.Infrastructure.Migrations.MigrationPlanExecutor","ProcessId":30028,"ProcessName":"iisexpress","ThreadId":1,"ApplicationId":"94c2084ae6c1f01f5c2f80848e2e314281b8d6f1","MachineName":"M020193","Log4NetLevel":"INFO "} {"@t":"2023-01-10T21:38:47.6330462Z","@mt":"At {OrigState}","OrigState":"{622E5172-42E1-4662-AD80-9504AF5A4E53}","SourceContext":"Umbraco.Cms.Infrastructure.Migrations.MigrationPlanExecutor","ProcessId":30028,"ProcessName":"iisexpress","ThreadId":1,"ApplicationId":"94c2084ae6c1f01f5c2f80848e2e314281b8d6f1","MachineName":"M020193","Log4NetLevel":"INFO "} {"@t":"2023-01-10T21:38:47.6330955Z","@mt":"Execute {MigrationType}","MigrationType":"ExternalLoginTableIndexesFixup","SourceContext":"Umbraco.Cms.Infrastructure.Migrations.MigrationPlanExecutor","ProcessId":30028,"ProcessName":"iisexpress","ThreadId":1,"ApplicationId":"94c2084ae6c1f01f5c2f80848e2e314281b8d6f1","MachineName":"M020193","Log4NetLevel":"INFO "} {"@t":"2023-01-10T21:38:47.7747044Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":0,"Sql":"ALTER TABLE [umbracoExternalLogin] ALTER COLUMN [loginProvider] NVARCHAR(400) NOT NULL","SourceContext":"Umbraco.Cms.Infrastructure.Migrations.MigrationContext","ProcessId":30028,"ProcessName":"iisexpress","ThreadId":1,"ApplicationId":"94c2084ae6c1f01f5c2f80848e2e314281b8d6f1","MachineName":"M020193","Log4NetLevel":"INFO "} {"@t":"2023-01-10T21:38:47.7971539Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":1,"Sql":"CREATE NONCLUSTERED INDEX [IX_umbracoExternalLogin_LoginProvider] ON [umbracoExternalLogin] ([loginProvider],[userId])","SourceContext":"Umbraco.Cms.Infrastructure.Migrations.MigrationContext","ProcessId":30028,"ProcessName":"iisexpress","ThreadId":1,"ApplicationId":"94c2084ae6c1f01f5c2f80848e2e314281b8d6f1","MachineName":"M020193","Log4NetLevel":"INFO "} {"@t":"2023-01-10T21:38:47.8191427Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":2,"Sql":"CREATE NONCLUSTERED INDEX [IX_umbracoExternalLogin_ProviderKey] ON [umbracoExternalLogin] ([loginProvider],[providerKey])","SourceContext":"Umbraco.Cms.Infrastructure.Migrations.MigrationContext","ProcessId":30028,"ProcessName":"iisexpress","ThreadId":1,"ApplicationId":"94c2084ae6c1f01f5c2f80848e2e314281b8d6f1","MachineName":"M020193","Log4NetLevel":"INFO "} {"@t":"2023-01-10T21:38:47.8230835Z","@mt":"At {OrigState}","OrigState":"{10F7BB61-C550-426B-830B-7F954F689CDF}","SourceContext":"Umbraco.Cms.Infrastructure.Migrations.MigrationPlanExecutor","ProcessId":30028,"ProcessName":"iisexpress","ThreadId":1,"ApplicationId":"94c2084ae6c1f01f5c2f80848e2e314281b8d6f1","MachineName":"M020193","Log4NetLevel":"INFO "} {"@t":"2023-01-10T21:38:47.8231446Z","@mt":"Execute {MigrationType}","MigrationType":"DictionaryTablesIndexes","SourceContext":"Umbraco.Cms.Infrastructure.Migrations.MigrationPlanExecutor","ProcessId":30028,"ProcessName":"iisexpress","ThreadId":1,"ApplicationId":"94c2084ae6c1f01f5c2f80848e2e314281b8d6f1","MachineName":"M020193","Log4NetLevel":"INFO "} {"@t":"2023-01-10T21:38:47.9425813Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":3,"Sql":"DROP INDEX [IX_cmsDictionary_key] ON [cmsDictionary]","SourceContext":"Umbraco.Cms.Infrastructure.Migrations.MigrationContext","ProcessId":30028,"ProcessName":"iisexpress","ThreadId":1,"ApplicationId":"94c2084ae6c1f01f5c2f80848e2e314281b8d6f1","MachineName":"M020193","Log4NetLevel":"INFO "} {"@t":"2023-01-10T21:38:47.9601272Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":4,"Sql":"CREATE UNIQUE NONCLUSTERED INDEX [IX_cmsDictionary_key] ON [cmsDictionary] ([key])","SourceContext":"Umbraco.Cms.Infrastructure.Migrations.MigrationContext","ProcessId":30028,"ProcessName":"iisexpress","ThreadId":1,"ApplicationId":"94c2084ae6c1f01f5c2f80848e2e314281b8d6f1","MachineName":"M020193","Log4NetLevel":"INFO "} {"@t":"2023-01-10T21:38:47.9647436Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":5,"Sql":"CREATE UNIQUE NONCLUSTERED INDEX [IX_cmsLanguageText_languageId] ON [cmsLanguageText] ([languageId],[UniqueId])","SourceContext":"Umbraco.Cms.Infrastructure.Migrations.MigrationContext","ProcessId":30028,"ProcessName":"iisexpress","ThreadId":1,"ApplicationId":"94c2084ae6c1f01f5c2f80848e2e314281b8d6f1","MachineName":"M020193","Log4NetLevel":"INFO "} {"@t":"2023-01-10T21:38:47.9679733Z","@mt":"At {OrigState}","OrigState":"{5AAE6276-80DB-4ACF-B845-199BC6C37538}","SourceContext":"Umbraco.Cms.Infrastructure.Migrations.MigrationPlanExecutor","ProcessId":30028,"ProcessName":"iisexpress","ThreadId":1,"ApplicationId":"94c2084ae6c1f01f5c2f80848e2e314281b8d6f1","MachineName":"M020193","Log4NetLevel":"INFO "} {"@t":"2023-01-10T21:38:47.9680268Z","@mt":"Execute {MigrationType}","MigrationType":"MigrateLogViewerQueriesFromFileToDb","SourceContext":"Umbraco.Cms.Infrastructure.Migrations.MigrationPlanExecutor","ProcessId":30028,"ProcessName":"iisexpress","ThreadId":1,"ApplicationId":"94c2084ae6c1f01f5c2f80848e2e314281b8d6f1","MachineName":"M020193","Log4NetLevel":"INFO "} {"@t":"2023-01-10T21:38:48.1249204Z","@mt":"Create table:\n {Sql}","Sql":"CREATE TABLE [umbracoLogViewerQuery] ([id] INTEGER NOT NULL IDENTITY(1,1),\n[name] NVARCHAR(255) NOT NULL,\n[query] NVARCHAR(255) NOT NULL)","SourceContext":"Umbraco.Cms.Persistence.SqlServer.Services.SqlServerSyntaxProvider","ProcessId":30028,"ProcessName":"iisexpress","ThreadId":1,"ApplicationId":"94c2084ae6c1f01f5c2f80848e2e314281b8d6f1","MachineName":"M020193","Log4NetLevel":"INFO "} {"@t":"2023-01-10T21:38:48.1515680Z","@mt":"Create Primary Key:\n {Sql}","Sql":"ALTER TABLE [umbracoLogViewerQuery] ADD CONSTRAINT [PK_umbracoLogViewerQuery] PRIMARY KEY CLUSTERED ([id])","SourceContext":"Umbraco.Cms.Persistence.SqlServer.Services.SqlServerSyntaxProvider","ProcessId":30028,"ProcessName":"iisexpress","ThreadId":1,"ApplicationId":"94c2084ae6c1f01f5c2f80848e2e314281b8d6f1","MachineName":"M020193","Log4NetLevel":"INFO "} {"@t":"2023-01-10T21:38:48.1567048Z","@mt":"Create Index:\n {Sql}","Sql":"CREATE UNIQUE NONCLUSTERED INDEX [IX_LogViewerQuery_name] ON [umbracoLogViewerQuery] ([name])","SourceContext":"Umbraco.Cms.Persistence.SqlServer.Services.SqlServerSyntaxProvider","ProcessId":30028,"ProcessName":"iisexpress","ThreadId":1,"ApplicationId":"94c2084ae6c1f01f5c2f80848e2e314281b8d6f1","MachineName":"M020193","Log4NetLevel":"INFO "} {"@t":"2023-01-10T21:39:18.4114553Z","@mt":"Exception ({InstanceId}).","@l":"Error","@x":"Microsoft.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.\r\nOperation cancelled by user.\r\nThe statement has been terminated.\r\n ---> System.ComponentModel.Win32Exception (258): The wait operation timed out.\r\n at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)\r\n at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)\r\n at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)\r\n at Microsoft.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)\r\n at Microsoft.Data.SqlClient.SqlBulkCopy.RunParser(BulkCopySimpleResultSet bulkCopyHandler)\r\n at Microsoft.Data.SqlClient.SqlBulkCopy.CopyBatchesAsyncContinuedOnSuccess(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source)\r\n at Microsoft.Data.SqlClient.SqlBulkCopy.CopyBatchesAsyncContinued(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source)\r\n at Microsoft.Data.SqlClient.SqlBulkCopy.CopyBatchesAsync(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source)\r\n at Microsoft.Data.SqlClient.SqlBulkCopy.WriteToServerInternalRestContinuedAsync(BulkCopySimpleResultSet internalResults, CancellationToken cts, TaskCompletionSource`1 source)\r\n at Microsoft.Data.SqlClient.SqlBulkCopy.WriteToServerInternalRestAsync(CancellationToken cts, TaskCompletionSource`1 source)\r\n at Microsoft.Data.SqlClient.SqlBulkCopy.WriteToServerInternalAsync(CancellationToken ctoken)\r\n at Microsoft.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServerAsync(Int32 columnCount, CancellationToken ctoken)\r\n at Microsoft.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState)\r\n at NPoco.SqlServer.SqlBulkCopyHelper.BulkInsert[T](IDatabase db, IEnumerable`1 list, SqlBulkCopyOptions sqlBulkCopyOptions, InsertBulkOptions insertBulkOptions)\r\n at NPoco.SqlServer.SqlBulkCopyHelper.BulkInsert[T](IDatabase db, IEnumerable`1 list, InsertBulkOptions insertBulkOptions)\r\n at NPoco.Database.InsertBulk[T](IEnumerable`1 pocos, InsertBulkOptions options)\r\nClientConnectionId:913196c9-8a71-4194-bfd3-3509c6e1fc75\r\nError Number:-2,State:0,Class:11","InstanceId":"688a1e78","SourceContext":"Umbraco.Cms.Infrastructure.Persistence.UmbracoDatabase","ProcessId":30028,"ProcessName":"iisexpress","ThreadId":1,"ApplicationId":"94c2084ae6c1f01f5c2f80848e2e314281b8d6f1","MachineName":"M020193","Log4NetLevel":"ERROR"} {"@t":"2023-01-10T21:39:18.5179038Z","@mt":"Database configuration failed","@l":"Error","@x":"Microsoft.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.\r\nOperation cancelled by user.\r\nThe statement has been terminated.\r\n ---> System.ComponentModel.Win32Exception (258): The wait operation timed out.\r\n at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)\r\n at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)\r\n at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)\r\n at Microsoft.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)\r\n at Microsoft.Data.SqlClient.SqlBulkCopy.RunParser(BulkCopySimpleResultSet bulkCopyHandler)\r\n at Microsoft.Data.SqlClient.SqlBulkCopy.CopyBatchesAsyncContinuedOnSuccess(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source)\r\n at Microsoft.Data.SqlClient.SqlBulkCopy.CopyBatchesAsyncContinued(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source)\r\n at Microsoft.Data.SqlClient.SqlBulkCopy.CopyBatchesAsync(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source)\r\n at Microsoft.Data.SqlClient.SqlBulkCopy.WriteToServerInternalRestContinuedAsync(BulkCopySimpleResultSet internalResults, CancellationToken cts, TaskCompletionSource`1 source)\r\n at Microsoft.Data.SqlClient.SqlBulkCopy.WriteToServerInternalRestAsync(CancellationToken cts, TaskCompletionSource`1 source)\r\n at Microsoft.Data.SqlClient.SqlBulkCopy.WriteToServerInternalAsync(CancellationToken ctoken)\r\n at Microsoft.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServerAsync(Int32 columnCount, CancellationToken ctoken)\r\n at Microsoft.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState)\r\n at NPoco.SqlServer.SqlBulkCopyHelper.BulkInsert[T](IDatabase db, IEnumerable`1 list, SqlBulkCopyOptions sqlBulkCopyOptions, InsertBulkOptions insertBulkOptions)\r\n at NPoco.SqlServer.SqlBulkCopyHelper.BulkInsert[T](IDatabase db, IEnumerable`1 list, InsertBulkOptions insertBulkOptions)\r\n at NPoco.Database.InsertBulk[T](IEnumerable`1 pocos, InsertBulkOptions options)\r\n at Umbraco.Cms.Infrastructure.Migrations.Upgrade.V_9_0_0.MigrateLogViewerQueriesFromFileToDb.MigrateFileContentToDB()\r\n at Umbraco.Cms.Infrastructure.Migrations.MigrationBase.Run()\r\n at Umbraco.Cms.Infrastructure.Migrations.MigrationPlanExecutor.Execute(MigrationPlan plan, String fromState)\r\n at Umbraco.Cms.Infrastructure.Migrations.Upgrade.Upgrader.Execute(IMigrationPlanExecutor migrationPlanExecutor, ICoreScopeProvider scopeProvider, IKeyValueService keyValueService)\r\n at Umbraco.Cms.Infrastructure.Migrations.Install.DatabaseBuilder.UpgradeSchemaAndData(UmbracoPlan plan)\r\nClientConnectionId:913196c9-8a71-4194-bfd3-3509c6e1fc75\r\nError Number:-2,State:0,Class:11","SourceContext":"Umbraco.Cms.Infrastructure.Migrations.Install.DatabaseBuilder","ProcessId":30028,"ProcessName":"iisexpress","ThreadId":1,"ApplicationId":"94c2084ae6c1f01f5c2f80848e2e314281b8d6f1","MachineName":"M020193","Log4NetLevel":"ERROR"}
Still haven't been able to move past this issue. Any help would be greatly appreciated!
first migrate to 9, then to 10
The issue was regarding a space issue in the database serverwhere the upgrade was being made.
is working on a reply...
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.
Continue discussion
DB Migration from v8.18.5 to v10 Fails
Following this guide and am stuck on step 1: https://our.umbraco.com/documentation/Umbraco-Cloud/Upgrades/Migrating-from-8-to-10/#step-1-content-migration
Steps completed:
-Backup db hosting v8 project
-Create a local v10 site
-Update connection string in appsettings.json
-Enabled unattended upgrades
This is the error I receive:
The log shows the migration fails after the 'MigrateLogViewerQueriesFromFileToDb' step. Has anyone else ran into this issue?
Thanks!
Log dump below:
Still haven't been able to move past this issue. Any help would be greatly appreciated!
first migrate to 9, then to 10
The issue was regarding a space issue in the database serverwhere the upgrade was being made.
is working on a reply...
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.