Closed tenshi04 closed 1 month ago
Reference to https://github.com/umbraco/Umbraco.Forms.Issues/issues/559
Booting error when upgrade from 8.18.12 to 8.18.14
This error looks very similar to the issue 559
I am using SQL Server for my DB.
If you're filing a bug, please describe how to reproduce it. Include as much relevant information as possible, such as:
Upgrading a site (on UAT) from 8.18.12 to 8.18.14 on a live environement causes a boot error.
Log messages:
{"@t":"2024-05-21T16:53:30.1887159Z","@mt":"Starting '{MigrationName}'...","MigrationName":"UmbracoForms","SourceContext":"Umbraco.Core.Migrations.MigrationPlan","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.1887159Z","@mt":"At {OrigState}","OrigState":"{forms-init-state}","SourceContext":"Umbraco.Core.Migrations.MigrationPlan","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.1887159Z","@mt":"Execute {MigrationType}","MigrationType":"AddFormsTables","SourceContext":"Umbraco.Core.Migrations.MigrationPlan","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.2043419Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":0,"Sql":"CREATE TABLE [UFRecords] ([Id] INTEGER NOT NULL IDENTITY(1,1),[Form] UniqueIdentifier NOT NULL,[Created] DATETIME NOT NULL,[Updated] DATETIME NOT NULL,[CurrentPage] UniqueIdentifier NULL,[UmbracoPageId] INTEGER NULL,[IP] NVARCHAR(255) NULL,[MemberKey] NVARCHAR(255) NULL,[UniqueId] UniqueIdentifier NOT NULL,[State] NVARCHAR(50) NULL,[RecordData] NTEXT NOT NULL,[Culture] NVARCHAR(84) NULL)","SourceContext":"Umbraco.Core.Migrations.Expressions.Execute.Expressions.ExecuteSqlStatementExpression","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.2355887Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":1,"Sql":"ALTER TABLE [UFRecords] ADD CONSTRAINT [PK_UFRecords] PRIMARY KEY CLUSTERED ([Id])","SourceContext":"Umbraco.Core.Migrations.Expressions.Execute.Expressions.ExecuteSqlStatementExpression","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.2355887Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":2,"Sql":"CREATE TABLE [UFRecordFields] ([Key] UniqueIdentifier NOT NULL,[FieldId] UniqueIdentifier NOT NULL,[Record] INTEGER NOT NULL,[Alias] NVARCHAR(255) NOT NULL,[DataType] NVARCHAR(255) NOT NULL)","SourceContext":"Umbraco.Core.Migrations.Expressions.Execute.Expressions.ExecuteSqlStatementExpression","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.2512117Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":3,"Sql":"ALTER TABLE [UFRecordFields] ADD CONSTRAINT [PK_UFRecordFields] PRIMARY KEY CLUSTERED ([Key])","SourceContext":"Umbraco.Core.Migrations.Expressions.Execute.Expressions.ExecuteSqlStatementExpression","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.2512117Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":4,"Sql":"CREATE NONCLUSTERED INDEX [IX_record_recordfield] ON [UFRecordFields] ([Record])","SourceContext":"Umbraco.Core.Migrations.Expressions.Execute.Expressions.ExecuteSqlStatementExpression","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.2668453Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":5,"Sql":"CREATE TABLE [UFRecordDataString] ([Id] INTEGER NOT NULL IDENTITY(1,1),[Key] UniqueIdentifier NOT NULL,[Value] NVARCHAR(255) NOT NULL)","SourceContext":"Umbraco.Core.Migrations.Expressions.Execute.Expressions.ExecuteSqlStatementExpression","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.2668453Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":6,"Sql":"ALTER TABLE [UFRecordDataString] ADD CONSTRAINT [PK_UFRecordDataString] PRIMARY KEY CLUSTERED ([Id])","SourceContext":"Umbraco.Core.Migrations.Expressions.Execute.Expressions.ExecuteSqlStatementExpression","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.2668453Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":7,"Sql":"ALTER TABLE [UFRecordDataString] ADD CONSTRAINT [FK_UFRecordDataString_UFRecordFields_Key] FOREIGN KEY ([Key]) REFERENCES [UFRecordFields] ([Key])","SourceContext":"Umbraco.Core.Migrations.Expressions.Execute.Expressions.ExecuteSqlStatementExpression","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.2668453Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":8,"Sql":"CREATE NONCLUSTERED INDEX [IX_datastring_recordfield] ON [UFRecordDataString] ([Key])","SourceContext":"Umbraco.Core.Migrations.Expressions.Execute.Expressions.ExecuteSqlStatementExpression","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.2668453Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":9,"Sql":"CREATE TABLE [UFRecordDataLongString] ([Id] INTEGER NOT NULL IDENTITY(1,1),[Key] UniqueIdentifier NOT NULL,[Value] NTEXT NULL)","SourceContext":"Umbraco.Core.Migrations.Expressions.Execute.Expressions.ExecuteSqlStatementExpression","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.2824790Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":10,"Sql":"CREATE TABLE [UFRecordDataInteger] ([Id] INTEGER NOT NULL IDENTITY(1,1),[Key] UniqueIdentifier NOT NULL,[Value] INTEGER NULL)","SourceContext":"Umbraco.Core.Migrations.Expressions.Execute.Expressions.ExecuteSqlStatementExpression","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.2824790Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":11,"Sql":"CREATE TABLE [UFRecordDataBit] ([Id] INTEGER NOT NULL IDENTITY(1,1),[Key] UniqueIdentifier NOT NULL,[Value] BIT NULL)","SourceContext":"Umbraco.Core.Migrations.Expressions.Execute.Expressions.ExecuteSqlStatementExpression","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.2824790Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":12,"Sql":"CREATE TABLE [UFRecordDataDateTime] ([Id] INTEGER NOT NULL IDENTITY(1,1),[Key] UniqueIdentifier NOT NULL,[Value] DATETIME NULL)","SourceContext":"Umbraco.Core.Migrations.Expressions.Execute.Expressions.ExecuteSqlStatementExpression","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.3137346Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":13,"Sql":"CREATE TABLE [UFUserSecurity] ([User] NVARCHAR(50) NOT NULL,[ManageDataSources] BIT NOT NULL,[ManagePreValueSources] BIT NOT NULL,[ManageWorkflows] BIT NOT NULL,[ManageForms] BIT NOT NULL,[ViewEntries] BIT NOT NULL CONSTRAINT [DF_UFUserSecurity_ViewEntries] DEFAULT ('0'),[EditEntries] BIT NOT NULL CONSTRAINT [DF_UFUserSecurity_EditEntries] DEFAULT ('0'))","SourceContext":"Umbraco.Core.Migrations.Expressions.Execute.Expressions.ExecuteSqlStatementExpression","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.3293609Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":14,"Sql":"CREATE TABLE [UFUserFormSecurity] ([Id] INTEGER NOT NULL IDENTITY(1,1),[User] NVARCHAR(50) NOT NULL,[Form] UniqueIdentifier NOT NULL,[HasAccess] BIT NOT NULL,[AllowInEditor] BIT NOT NULL,[SecurityType] INTEGER NOT NULL)","SourceContext":"Umbraco.Core.Migrations.Expressions.Execute.Expressions.ExecuteSqlStatementExpression","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.3293609Z","@mt":"At {OrigState}","OrigState":"{forms-init-db}","SourceContext":"Umbraco.Core.Migrations.MigrationPlan","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.3293609Z","@mt":"Execute {MigrationType}","MigrationType":"AddFormsTrialLicense","SourceContext":"Umbraco.Core.Migrations.MigrationPlan","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.3293609Z","@mt":"At {OrigState}","OrigState":"{forms-init-license}","SourceContext":"Umbraco.Core.Migrations.MigrationPlan","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.3293609Z","@mt":"Execute {MigrationType}","MigrationType":"AddFormsMacro","SourceContext":"Umbraco.Core.Migrations.MigrationPlan","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.5012256Z","@mt":"At {OrigState}","OrigState":"{forms-init-macro}","SourceContext":"Umbraco.Core.Migrations.MigrationPlan","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.5012256Z","@mt":"Execute {MigrationType}","MigrationType":"AddFormsApplicationPermission","SourceContext":"Umbraco.Core.Migrations.MigrationPlan","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.5480991Z","@mt":"At {OrigState}","OrigState":"{forms-init-complete}","SourceContext":"Umbraco.Core.Migrations.MigrationPlan","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.5480991Z","@mt":"Execute {MigrationType}","MigrationType":"AddRecordKeysAndIndexes","SourceContext":"Umbraco.Core.Migrations.MigrationPlan","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.5793862Z","@mt":"Database migration step not completed: could not create primary key constraint on UFRecordDataBit as a primary key already exists.","SourceContext":"Umbraco.Forms.Core.Migrations.V_8_7_0.AddRecordKeysAndIndexes","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.5949737Z","@mt":"Database migration step not completed: could not create primary key constraint on UFRecordDataDateTime as a primary key already exists.","SourceContext":"Umbraco.Forms.Core.Migrations.V_8_7_0.AddRecordKeysAndIndexes","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.5949737Z","@mt":"Database migration step not completed: could not create primary key constraint on UFRecordDataInteger as a primary key already exists.","SourceContext":"Umbraco.Forms.Core.Migrations.V_8_7_0.AddRecordKeysAndIndexes","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.6105986Z","@mt":"Database migration step not completed: could not create primary key constraint on UFRecordDataLongString as a primary key already exists.","SourceContext":"Umbraco.Forms.Core.Migrations.V_8_7_0.AddRecordKeysAndIndexes","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.6262322Z","@mt":"Database migration step not completed: could not create foreign key constraint between UFRecordFields.Record and UFRecords.Id as a constraint with the name FK_UFRecordFields_UFRecords_Record already exists.","SourceContext":"Umbraco.Forms.Core.Migrations.V_8_7_0.AddRecordKeysAndIndexes","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.6418508Z","@mt":"Database migration step not completed: could not create foreign key constraint between UFRecordDataBit.Key and UFRecordFields.Key as a constraint with the name FK_UFRecordDataBit_UFRecordFields_Key already exists.","SourceContext":"Umbraco.Forms.Core.Migrations.V_8_7_0.AddRecordKeysAndIndexes","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.6418508Z","@mt":"Database migration step not completed: could not create foreign key constraint between UFRecordDataDateTime.Key and UFRecordFields.Key as a constraint with the name FK_UFRecordDataDateTime_UFRecordFields_Key already exists.","SourceContext":"Umbraco.Forms.Core.Migrations.V_8_7_0.AddRecordKeysAndIndexes","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.6418508Z","@mt":"Database migration step not completed: could not create foreign key constraint between UFRecordDataInteger.Key and UFRecordFields.Key as a constraint with the name FK_UFRecordDataInteger_UFRecordFields_Key already exists.","SourceContext":"Umbraco.Forms.Core.Migrations.V_8_7_0.AddRecordKeysAndIndexes","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.6418508Z","@mt":"Database migration step not completed: could not create foreign key constraint between UFRecordDataLongString.Key and UFRecordFields.Key as a constraint with the name FK_UFRecordDataLongString_UFRecordFields_Key already exists.","SourceContext":"Umbraco.Forms.Core.Migrations.V_8_7_0.AddRecordKeysAndIndexes","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.6575237Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":15,"Sql":"CREATE NONCLUSTERED INDEX [IX_UFRecordDataBit_Key] ON [UFRecordDataBit] ([Key])","SourceContext":"Umbraco.Core.Migrations.Expressions.Common.Expressions.CreateIndexExpression","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.6575237Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":16,"Sql":"CREATE NONCLUSTERED INDEX [IX_UFRecordDataDateTime_Key] ON [UFRecordDataDateTime] ([Key])","SourceContext":"Umbraco.Core.Migrations.Expressions.Common.Expressions.CreateIndexExpression","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.6731068Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":17,"Sql":"CREATE NONCLUSTERED INDEX [IX_UFRecordDataInteger_Key] ON [UFRecordDataInteger] ([Key])","SourceContext":"Umbraco.Core.Migrations.Expressions.Common.Expressions.CreateIndexExpression","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.6731068Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":18,"Sql":"CREATE NONCLUSTERED INDEX [IX_UFRecordDataLongString_Key] ON [UFRecordDataLongString] ([Key])","SourceContext":"Umbraco.Core.Migrations.Expressions.Common.Expressions.CreateIndexExpression","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.6887658Z","@mt":"Database migration step not completed: could not create primary key constraint on UFUserSecurity as a primary key already exists.","SourceContext":"Umbraco.Forms.Core.Migrations.V_8_7_0.AddRecordKeysAndIndexes","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.6887658Z","@mt":"Database migration step not completed: could not create primary key constraint on UFUserFormSecurity as a primary key already exists.","SourceContext":"Umbraco.Forms.Core.Migrations.V_8_7_0.AddRecordKeysAndIndexes","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.7043719Z","@mt":"Database migration step not completed: could not create unique constraint on the User, Form columns in UFUserFormSecurity as a constraint with the name UK_UFUserFormSecurity_User_Form already exists.","SourceContext":"Umbraco.Forms.Core.Migrations.V_8_7_0.AddRecordKeysAndIndexes","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.7043719Z","@mt":"At {OrigState}","OrigState":"6822cdca-1dc4-4983-b189-9c45314e8747","SourceContext":"Umbraco.Core.Migrations.MigrationPlan","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.7043719Z","@mt":"Execute {MigrationType}","MigrationType":"AddViewAndEditEntriesPermissions","SourceContext":"Umbraco.Core.Migrations.MigrationPlan","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.7356092Z","@mt":"At {OrigState}","OrigState":"70153aa8-c130-4900-ba9c-ad3a0a929079","SourceContext":"Umbraco.Core.Migrations.MigrationPlan","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.7356092Z","@mt":"Execute {MigrationType}","MigrationType":"AddRecordAudit","SourceContext":"Umbraco.Core.Migrations.MigrationPlan","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.7356092Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":19,"Sql":"CREATE TABLE [UFRecordAudit] ([Id] INTEGER NOT NULL IDENTITY(1,1),[Record] INTEGER NOT NULL,[UpdatedOn] DATETIME NOT NULL,[UpdatedBy] INTEGER NULL)","SourceContext":"Umbraco.Core.Migrations.Expressions.Execute.Expressions.ExecuteSqlStatementExpression","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.7356092Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":20,"Sql":"ALTER TABLE [UFRecordAudit] ADD CONSTRAINT [PK_UFRecordAudit] PRIMARY KEY CLUSTERED ([Id])","SourceContext":"Umbraco.Core.Migrations.Expressions.Execute.Expressions.ExecuteSqlStatementExpression","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.7356092Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":21,"Sql":"ALTER TABLE [UFRecordAudit] ADD CONSTRAINT [FK_UFRecordAudit_UFRecords_Id] FOREIGN KEY ([Record]) REFERENCES [UFRecords] ([Id])","SourceContext":"Umbraco.Core.Migrations.Expressions.Execute.Expressions.ExecuteSqlStatementExpression","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.7512377Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":22,"Sql":"CREATE NONCLUSTERED INDEX [IX_Record_RecordAudit] ON [UFRecordAudit] ([Record])","SourceContext":"Umbraco.Core.Migrations.Expressions.Execute.Expressions.ExecuteSqlStatementExpression","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.7512377Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":23,"Sql":"CREATE NONCLUSTERED INDEX [IX_Record_UpdatedBy] ON [UFRecordAudit] ([UpdatedBy])","SourceContext":"Umbraco.Core.Migrations.Expressions.Execute.Expressions.ExecuteSqlStatementExpression","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.7512377Z","@mt":"At {OrigState}","OrigState":"0b07a932-cc1e-4c22-974b-821e8bc61689","SourceContext":"Umbraco.Core.Migrations.MigrationPlan","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.7512377Z","@mt":"Execute {MigrationType}","MigrationType":"AddUserGroupPermissions","SourceContext":"Umbraco.Core.Migrations.MigrationPlan","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.7512377Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":24,"Sql":"CREATE TABLE [UFUserGroupSecurity] ([UserGroupId] INTEGER NOT NULL,[ManageDataSources] BIT NOT NULL,[ManagePreValueSources] BIT NOT NULL,[ManageWorkflows] BIT NOT NULL,[ManageForms] BIT NOT NULL,[ViewEntries] BIT NOT NULL CONSTRAINT [DF_UFUserGroupSecurity_ViewEntries] DEFAULT ('0'),[EditEntries] BIT NOT NULL CONSTRAINT [DF_UFUserGroupSecurity_EditEntries] DEFAULT ('0'))","SourceContext":"Umbraco.Core.Migrations.Expressions.Execute.Expressions.ExecuteSqlStatementExpression","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.7512377Z","@mt":"SQL [{ContextIndex}]: ","ContextIndex":25,"SourceContext":"Umbraco.Core.Migrations.Expressions.Execute.Expressions.ExecuteSqlStatementExpression","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.7512377Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":26,"Sql":"CREATE TABLE [UFUserGroupFormSecurity] ([Id] INTEGER NOT NULL IDENTITY(1,1),[UserGroupId] INTEGER NOT NULL,[Form] UniqueIdentifier NOT NULL,[HasAccess] BIT NOT NULL,[AllowInEditor] BIT NOT NULL,[SecurityType] INTEGER NOT NULL)","SourceContext":"Umbraco.Core.Migrations.Expressions.Execute.Expressions.ExecuteSqlStatementExpression","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.7512377Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":27,"Sql":"ALTER TABLE [UFUserGroupFormSecurity] ADD CONSTRAINT [PK_UserGroupFormSecurity] PRIMARY KEY CLUSTERED ([Id])","SourceContext":"Umbraco.Core.Migrations.Expressions.Execute.Expressions.ExecuteSqlStatementExpression","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.7668780Z","@mt":"At {OrigState}","OrigState":"949ad38a-f7db-401d-a4f2-f79cb059da22","SourceContext":"Umbraco.Core.Migrations.MigrationPlan","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.7668780Z","@mt":"Execute {MigrationType}","MigrationType":"AddUserGroupPermissionsConstraints","SourceContext":"Umbraco.Core.Migrations.MigrationPlan","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.7668780Z","@mt":"Database migration step not completed: could not create primary key constraint on UFUserGroupSecurity as a primary key already exists.","SourceContext":"Umbraco.Forms.Core.Migrations.V_8_11_0.AddUserGroupPermissionsConstraints","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.7824860Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":28,"Sql":"ALTER TABLE [UFUserGroupFormSecurity] ADD CONSTRAINT [PK_UFUserGroupFormSecurity] PRIMARY KEY CLUSTERED ([Id])","SourceContext":"Umbraco.Core.Migrations.Expressions.Create.Expressions.CreateConstraintExpression","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.7981053Z","@mt":"Exception ({InstanceId}).","@l":"Error","@x":"System.Data.SqlClient.SqlException (0x80131904): Table 'UFUserGroupFormSecurity' already has a primary key defined on it.\r\nCould not create constraint or index. See previous errors.\r\n at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)\r\n at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)\r\n at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)\r\n at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)\r\n at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)\r\n at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()\r\n at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func1 func)\r\n at NPoco.Database.ExecuteNonQueryHelper(DbCommand cmd)\r\n at NPoco.Database.Execute(String sql, CommandType commandType, Object[] args)\r\n at Umbraco.Core.Migrations.MigrationExpressionBase.ExecuteStatement(StringBuilder stmtBuilder)\r\n at Umbraco.Core.Migrations.MigrationExpressionBase.Execute()\r\n at Umbraco.Forms.Core.Migrations.FormsMigrationBase.AddPrimaryKey[TDto](String table, String[] columns)\r\n at Umbraco.Forms.Core.Migrations.FormsMigrationBase.AddPrimaryKey[TDto](String table, String column)\r\n at Umbraco.Forms.Core.Migrations.V_8_11_0.AddUserGroupPermissionsConstraints.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.Forms.Core.Components.UmbracoFormsComponent.ExecuteDatabaseUpgrades()\r\n at Umbraco.Forms.Core.Components.UmbracoFormsComponent.Initialize()\r\n at Umbraco.Core.Composing.ComponentCollection.Initialize()\r\n at Umbraco.Core.Runtime.CoreRuntime.Boot(IRegister register, DisposableTimer timer)\r\nClientConnectionId:0adf1c48-f3f3-4f04-b9fd-47be364f42c4\r\nError Number:1779,State:0,Class:16","InstanceId":"ed9a015c","SourceContext":"Umbraco.Core.Persistence.UmbracoDatabase","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"ERROR","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:57.8734139Z","@mt":"{FailMessage} ({Duration}ms) [Timing {TimingId}]","@l":"Error","@x":"Umbraco.Core.Exceptions.BootFailedException: Boot failed. ---> System.Data.SqlClient.SqlException: Table 'UFUserGroupFormSecurity' already has a primary key defined on it.\r\nCould not create constraint or index. See previous errors.\r\n at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)\r\n at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)\r\n at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)\r\n at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)\r\n at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)\r\n at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()\r\n at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func1 func)\r\n at NPoco.Database.ExecuteNonQueryHelper(DbCommand cmd)\r\n at NPoco.Database.Execute(String sql, CommandType commandType, Object[] args)\r\n at Umbraco.Core.Migrations.MigrationExpressionBase.ExecuteStatement(StringBuilder stmtBuilder)\r\n at Umbraco.Core.Migrations.MigrationExpressionBase.Execute()\r\n at Umbraco.Forms.Core.Migrations.FormsMigrationBase.AddPrimaryKey[TDto](String table, String[] columns)\r\n at Umbraco.Forms.Core.Migrations.FormsMigrationBase.AddPrimaryKey[TDto](String table, String column)\r\n at Umbraco.Forms.Core.Migrations.V_8_11_0.AddUserGroupPermissionsConstraints.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.Forms.Core.Components.UmbracoFormsComponent.ExecuteDatabaseUpgrades()\r\n at Umbraco.Forms.Core.Components.UmbracoFormsComponent.Initialize()\r\n at Umbraco.Core.Composing.ComponentCollection.Initialize()\r\n at Umbraco.Core.Runtime.CoreRuntime.Boot(IRegister register, DisposableTimer timer)\r\n --- End of inner exception stack trace ---","FailMessage":"Boot failed.","Duration":29865,"TimingId":"b60b8ab","SourceContext":"Umbraco.Core.Runtime.CoreRuntime","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"ERROR","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:57.9671733Z","@mt":"An unhandled exception occurred","@l":"Error","@x":"Umbraco.Core.Exceptions.BootFailedException: Boot failed: Umbraco cannot run. See Umbraco's log file for more details.\n\n-> Umbraco.Core.Exceptions.BootFailedException: Boot failed.\n\n-> System.Data.SqlClient.SqlException: Table 'UFUserGroupFormSecurity' already has a primary key defined on it.\r\nCould not create constraint or index. See previous errors.\n at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)\r\n at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)\r\n at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)\r\n at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)\r\n at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)\r\n at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()\r\n at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func1 func)\r\n at NPoco.Database.ExecuteNonQueryHelper(DbCommand cmd)\r\n at NPoco.Database.Execute(String sql, CommandType commandType, Object[] args)\r\n at Umbraco.Core.Migrations.MigrationExpressionBase.ExecuteStatement(StringBuilder stmtBuilder)\r\n at Umbraco.Core.Migrations.MigrationExpressionBase.Execute()\r\n at Umbraco.Forms.Core.Migrations.FormsMigrationBase.AddPrimaryKey[TDto](String table, String[] columns)\r\n at Umbraco.Forms.Core.Migrations.FormsMigrationBase.AddPrimaryKey[TDto](String table, String column)\r\n at Umbraco.Forms.Core.Migrations.V_8_11_0.AddUserGroupPermissionsConstraints.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.Forms.Core.Components.UmbracoFormsComponent.ExecuteDatabaseUpgrades()\r\n at Umbraco.Forms.Core.Components.UmbracoFormsComponent.Initialize()\r\n at Umbraco.Core.Composing.ComponentCollection.Initialize()\r\n at Umbraco.Core.Runtime.CoreRuntime.Boot(IRegister register, DisposableTimer timer)\r\n at Umbraco.Core.Exceptions.BootFailedException.Rethrow(BootFailedException bootFailedException)\r\n at System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()\r\n at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)\r\n at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)","SourceContext":"Umbraco.Web.UmbracoApplicationBase","ProcessId":3540,"ProcessName":"w3wp","ThreadId":12,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"ERROR","HttpRequestNumber":2,"HttpRequestId":"3cd8efe9-09fc-4383-b29f-41316b993457"} {"@t":"2024-05-21T16:53:58.5611730Z","@mt":"An unhandled exception occurred","@l":"Error","@x":"Umbraco.Core.Exceptions.BootFailedException: Boot failed: Umbraco cannot run. See Umbraco's log file for more details.\n\n-> Umbraco.Core.Exceptions.BootFailedException: Boot failed.\n\n-> System.Data.SqlClient.SqlException: Table 'UFUserGroupFormSecurity' already has a primary key defined on it.\r\nCould not create constraint or index. See previous errors.\n at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)\r\n at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)\r\n at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)\r\n at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)\r\n at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)\r\n at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()\r\n at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func1 func)\r\n at NPoco.Database.ExecuteNonQueryHelper(DbCommand cmd)\r\n at NPoco.Database.Execute(String sql, CommandType commandType, Object[] args)\r\n at Umbraco.Core.Migrations.MigrationExpressionBase.ExecuteStatement(StringBuilder stmtBuilder)\r\n at Umbraco.Core.Migrations.MigrationExpressionBase.Execute()\r\n at Umbraco.Forms.Core.Migrations.FormsMigrationBase.AddPrimaryKey[TDto](String table, String[] columns)\r\n at Umbraco.Forms.Core.Migrations.FormsMigrationBase.AddPrimaryKey[TDto](String table, String column)\r\n at Umbraco.Forms.Core.Migrations.V_8_11_0.AddUserGroupPermissionsConstraints.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.Forms.Core.Components.UmbracoFormsComponent.ExecuteDatabaseUpgrades()\r\n at Umbraco.Forms.Core.Components.UmbracoFormsComponent.Initialize()\r\n at Umbraco.Core.Composing.ComponentCollection.Initialize()\r\n at Umbraco.Core.Runtime.CoreRuntime.Boot(IRegister register, DisposableTimer timer)\r\n at Umbraco.Core.Exceptions.BootFailedException.Rethrow(BootFailedException bootFailedException)\r\n at System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()\r\n at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)\r\n at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)","SourceContext":"Umbraco.Web.UmbracoApplicationBase","ProcessId":3540,"ProcessName":"w3wp","ThreadId":19,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"ERROR","HttpRequestNumber":3,"HttpRequestId":"751f5a5a-e589-43c4-8949-7a274d8dd770"} {"@t":"2024-05-21T17:14:53.6705426Z","@mt":"{LogPrefix} Terminating {Immediate}","LogPrefix":"[Umbraco.Web.Scheduling.IBackgroundTask] ","Immediate":"","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":71,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:53.6705426Z","@mt":"{LogPrefix} Terminating {Immediate}","LogPrefix":"[ServerRegistration] ","Immediate":"","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":71,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:53.6705426Z","@mt":"{LogPrefix} Terminating {Immediate}","LogPrefix":"[HealthCheckNotifier] ","Immediate":"","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":71,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:53.6705426Z","@mt":"{LogPrefix} Terminating {Immediate}","LogPrefix":"[ScheduledTasks] ","Immediate":"","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":71,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:53.6705426Z","@mt":"{LogPrefix} Terminating {Immediate}","LogPrefix":"[ScheduledPublishing] ","Immediate":"","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":71,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:53.6705426Z","@mt":"{LogPrefix} Terminating {Immediate}","LogPrefix":"[ContentVersionCleanup] ","Immediate":"","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":71,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:53.6705426Z","@mt":"{LogPrefix} Terminating {Immediate}","LogPrefix":"[TempFileCleanup] ","Immediate":"","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":71,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:53.6705426Z","@mt":"{LogPrefix} Terminating {Immediate}","LogPrefix":"[TelemetryReporter] ","Immediate":"","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":71,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:53.6705426Z","@mt":"{LogPrefix} Terminating {Immediate}","LogPrefix":"[LogScrubber] ","Immediate":"","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":71,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:53.6705426Z","@mt":"{LogPrefix} Terminating {Immediate}","LogPrefix":"[KeepAlive] ","Immediate":"","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":71,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:53.6705426Z","@mt":"Stopping ({SignalSource})","SignalSource":"environment","SourceContext":"Umbraco.Core.Runtime.MainDom","ProcessId":3540,"ProcessName":"w3wp","ThreadId":71,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:53.6861239Z","@mt":"{StartMessage} [Timing {TimingId}]","StartMessage":"Examine shutting down","TimingId":"a137aa3","SourceContext":"Umbraco.Web.Search.ExamineComponent","ProcessId":3540,"ProcessName":"w3wp","ThreadId":71,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:53.7017481Z","@mt":"{EndMessage} ({Duration}ms) [Timing {TimingId}]","EndMessage":"Completed.","Duration":14,"TimingId":"a137aa3","SourceContext":"Umbraco.Web.Search.ExamineComponent","ProcessId":3540,"ProcessName":"w3wp","ThreadId":71,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:53.7017481Z","@mt":"Released ({SignalSource})","SignalSource":"environment","SourceContext":"Umbraco.Core.Runtime.MainDom","ProcessId":3540,"ProcessName":"w3wp","ThreadId":71,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:53.7017481Z","@mt":"{LogPrefix} Terminating {Immediate}","LogPrefix":"[ServerInstProcess] ","Immediate":"","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":71,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:53.7017481Z","@mt":"{LogPrefix} Canceling tasks","LogPrefix":"[Umbraco.Web.Scheduling.IBackgroundTask] ","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":70,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:53.7017481Z","@mt":"{LogPrefix} Tasks {TaskStatus}, terminated","LogPrefix":"[Umbraco.Web.Scheduling.IBackgroundTask] ","TaskStatus":"cancelled","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":70,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:53.7017481Z","@mt":"{LogPrefix} Canceling tasks","LogPrefix":"[ServerRegistration] ","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":74,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:53.7017481Z","@mt":"{LogPrefix} Tasks {TaskStatus}, terminated","LogPrefix":"[ServerRegistration] ","TaskStatus":"cancelled","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":74,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:53.7017481Z","@mt":"{LogPrefix} Canceling tasks","LogPrefix":"[HealthCheckNotifier] ","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":72,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:53.7017481Z","@mt":"{LogPrefix} Tasks {TaskStatus}, terminated","LogPrefix":"[HealthCheckNotifier] ","TaskStatus":"cancelled","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":72,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:53.7017481Z","@mt":"{LogPrefix} Canceling tasks","LogPrefix":"[ScheduledTasks] ","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":69,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:53.7017481Z","@mt":"{LogPrefix} Tasks {TaskStatus}, terminated","LogPrefix":"[ScheduledTasks] ","TaskStatus":"cancelled","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":69,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:54.6766768Z","@mt":"{LogPrefix} Canceling tasks","LogPrefix":"[ScheduledPublishing] ","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":76,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:54.6766768Z","@mt":"{LogPrefix} Tasks {TaskStatus}, terminated","LogPrefix":"[ScheduledPublishing] ","TaskStatus":"cancelled","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":76,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:55.6707684Z","@mt":"{LogPrefix} Canceling tasks","LogPrefix":"[ContentVersionCleanup] ","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":78,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:55.6707684Z","@mt":"{LogPrefix} Tasks {TaskStatus}, terminated","LogPrefix":"[ContentVersionCleanup] ","TaskStatus":"cancelled","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":78,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:55.7176274Z","@mt":"{LogPrefix} Canceling tasks","LogPrefix":"[ScheduledTasks] ","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":69,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:55.7176274Z","@mt":"{LogPrefix} Canceling tasks","LogPrefix":"[TempFileCleanup] ","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":69,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:55.7176274Z","@mt":"{LogPrefix} Tasks {TaskStatus}, terminated","LogPrefix":"[TempFileCleanup] ","TaskStatus":"cancelled","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":69,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:55.7176274Z","@mt":"{LogPrefix} Canceling tasks","LogPrefix":"[HealthCheckNotifier] ","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":72,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:55.7176274Z","@mt":"{LogPrefix} Canceling tasks","LogPrefix":"[ServerRegistration] ","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":74,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:55.7176274Z","@mt":"{LogPrefix} Canceling tasks","LogPrefix":"[LogScrubber] ","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":74,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:55.7176274Z","@mt":"{LogPrefix} Tasks {TaskStatus}, terminated","LogPrefix":"[LogScrubber] ","TaskStatus":"cancelled","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":74,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:55.7176274Z","@mt":"{LogPrefix} Canceling tasks","LogPrefix":"[Umbraco.Web.Scheduling.IBackgroundTask] ","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":70,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:55.7176274Z","@mt":"{LogPrefix} Canceling tasks","LogPrefix":"[KeepAlive] ","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":70,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:55.7176274Z","@mt":"{LogPrefix} Tasks {TaskStatus}, terminated","LogPrefix":"[KeepAlive] ","TaskStatus":"cancelled","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":70,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:56.6690040Z","@mt":"{LogPrefix} Canceling tasks","LogPrefix":"[ServerInstProcess] ","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":79,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:56.6690040Z","@mt":"{LogPrefix} Tasks {TaskStatus}, terminated","LogPrefix":"[ServerInstProcess] ","TaskStatus":"cancelled","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":79,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:56.7001901Z","@mt":"{LogPrefix} Canceling tasks","LogPrefix":"[ScheduledPublishing] ","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":76,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:56.7001901Z","@mt":"{LogPrefix} Canceling tasks","LogPrefix":"[TelemetryReporter] ","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":76,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:56.7001901Z","@mt":"{LogPrefix} Tasks {TaskStatus}, terminated","LogPrefix":"[TelemetryReporter] ","TaskStatus":"cancelled","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":76,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:56.7782913Z","@mt":"Application shutdown. Details: {ShutdownReason}\r\n\r\n_shutDownMessage={ShutdownMessage}\r\n\r\n_shutDownStack={ShutdownStack}","ShutdownReason":"HostingEnvironment","ShutdownMessage":"HostingEnvironment initiated shutdown\r\nHostingEnvironment caused shutdown","ShutdownStack":" at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)\r\n at System.Environment.get_StackTrace()\r\n at System.Web.Hosting.HostingEnvironment.InitiateShutdownInternal()\r\n at System.Web.Hosting.HostingEnvironment.InitiateShutdownWithoutDemand()\r\n at System.Web.Hosting.PipelineRuntime.StopProcessing()","SourceContext":"Umbraco.Web.UmbracoApplicationBase","ProcessId":3540,"ProcessName":"w3wp","ThreadId":76,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "}
1 wrapCloseInAction)\r\n at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)\r\n at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)\r\n at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)\r\n at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource
1 func)\r\n at NPoco.Database.ExecuteNonQueryHelper(DbCommand cmd)\r\n at NPoco.Database.Execute(String sql, CommandType commandType, Object[] args)\r\n at Umbraco.Core.Migrations.MigrationExpressionBase.ExecuteStatement(StringBuilder stmtBuilder)\r\n at Umbraco.Core.Migrations.MigrationExpressionBase.Execute()\r\n at Umbraco.Forms.Core.Migrations.FormsMigrationBase.AddPrimaryKey[TDto](String table, String[] columns)\r\n at Umbraco.Forms.Core.Migrations.FormsMigrationBase.AddPrimaryKey[TDto](String table, String column)\r\n at Umbraco.Forms.Core.Migrations.V_8_11_0.AddUserGroupPermissionsConstraints.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.Forms.Core.Components.UmbracoFormsComponent.ExecuteDatabaseUpgrades()\r\n at Umbraco.Forms.Core.Components.UmbracoFormsComponent.Initialize()\r\n at Umbraco.Core.Composing.ComponentCollection.Initialize()\r\n at Umbraco.Core.Runtime.CoreRuntime.Boot(IRegister register, DisposableTimer timer)\r\nClientConnectionId:0adf1c48-f3f3-4f04-b9fd-47be364f42c4\r\nError Number:1779,State:0,Class:16","InstanceId":"ed9a015c","SourceContext":"Umbraco.Core.Persistence.UmbracoDatabase","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"ERROR","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:57.8734139Z","@mt":"{FailMessage} ({Duration}ms) [Timing {TimingId}]","@l":"Error","@x":"Umbraco.Core.Exceptions.BootFailedException: Boot failed. ---> System.Data.SqlClient.SqlException: Table 'UFUserGroupFormSecurity' already has a primary key defined on it.\r\nCould not create constraint or index. See previous errors.\r\n at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action
1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)\r\n at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()\r\n at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func
1 func)\r\n at NPoco.Database.ExecuteNonQueryHelper(DbCommand cmd)\r\n at NPoco.Database.Execute(String sql, CommandType commandType, Object[] args)\r\n at Umbraco.Core.Migrations.MigrationExpressionBase.ExecuteStatement(StringBuilder stmtBuilder)\r\n at Umbraco.Core.Migrations.MigrationExpressionBase.Execute()\r\n at Umbraco.Forms.Core.Migrations.FormsMigrationBase.AddPrimaryKey[TDto](String table, String[] columns)\r\n at Umbraco.Forms.Core.Migrations.FormsMigrationBase.AddPrimaryKey[TDto](String table, String column)\r\n at Umbraco.Forms.Core.Migrations.V_8_11_0.AddUserGroupPermissionsConstraints.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.Forms.Core.Components.UmbracoFormsComponent.ExecuteDatabaseUpgrades()\r\n at Umbraco.Forms.Core.Components.UmbracoFormsComponent.Initialize()\r\n at Umbraco.Core.Composing.ComponentCollection.Initialize()\r\n at Umbraco.Core.Runtime.CoreRuntime.Boot(IRegister register, DisposableTimer timer)\r\n at Umbraco.Core.Exceptions.BootFailedException.Rethrow(BootFailedException bootFailedException)\r\n at System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()\r\n at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)\r\n at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)","SourceContext":"Umbraco.Web.UmbracoApplicationBase","ProcessId":3540,"ProcessName":"w3wp","ThreadId":12,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"ERROR","HttpRequestNumber":2,"HttpRequestId":"3cd8efe9-09fc-4383-b29f-41316b993457"} {"@t":"2024-05-21T16:53:58.5611730Z","@mt":"An unhandled exception occurred","@l":"Error","@x":"Umbraco.Core.Exceptions.BootFailedException: Boot failed: Umbraco cannot run. See Umbraco's log file for more details.\n\n-> Umbraco.Core.Exceptions.BootFailedException: Boot failed.\n\n-> System.Data.SqlClient.SqlException: Table 'UFUserGroupFormSecurity' already has a primary key defined on it.\r\nCould not create constraint or index. See previous errors.\n at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action
Reference to https://github.com/umbraco/Umbraco.Forms.Issues/issues/559
Booting error when upgrade from 8.18.12 to 8.18.14
This error looks very similar to the issue 559
I am using SQL Server for my DB.
Reproduction
If you're filing a bug, please describe how to reproduce it. Include as much relevant information as possible, such as:
Bug summary
Upgrading a site (on UAT) from 8.18.12 to 8.18.14 on a live environement causes a boot error.
Log messages:
{"@t":"2024-05-21T16:53:30.1887159Z","@mt":"Starting '{MigrationName}'...","MigrationName":"UmbracoForms","SourceContext":"Umbraco.Core.Migrations.MigrationPlan","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.1887159Z","@mt":"At {OrigState}","OrigState":"{forms-init-state}","SourceContext":"Umbraco.Core.Migrations.MigrationPlan","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.1887159Z","@mt":"Execute {MigrationType}","MigrationType":"AddFormsTables","SourceContext":"Umbraco.Core.Migrations.MigrationPlan","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.2043419Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":0,"Sql":"CREATE TABLE [UFRecords] ([Id] INTEGER NOT NULL IDENTITY(1,1),[Form] UniqueIdentifier NOT NULL,[Created] DATETIME NOT NULL,[Updated] DATETIME NOT NULL,[CurrentPage] UniqueIdentifier NULL,[UmbracoPageId] INTEGER NULL,[IP] NVARCHAR(255) NULL,[MemberKey] NVARCHAR(255) NULL,[UniqueId] UniqueIdentifier NOT NULL,[State] NVARCHAR(50) NULL,[RecordData] NTEXT NOT NULL,[Culture] NVARCHAR(84) NULL)","SourceContext":"Umbraco.Core.Migrations.Expressions.Execute.Expressions.ExecuteSqlStatementExpression","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.2355887Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":1,"Sql":"ALTER TABLE [UFRecords] ADD CONSTRAINT [PK_UFRecords] PRIMARY KEY CLUSTERED ([Id])","SourceContext":"Umbraco.Core.Migrations.Expressions.Execute.Expressions.ExecuteSqlStatementExpression","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.2355887Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":2,"Sql":"CREATE TABLE [UFRecordFields] ([Key] UniqueIdentifier NOT NULL,[FieldId] UniqueIdentifier NOT NULL,[Record] INTEGER NOT NULL,[Alias] NVARCHAR(255) NOT NULL,[DataType] NVARCHAR(255) NOT NULL)","SourceContext":"Umbraco.Core.Migrations.Expressions.Execute.Expressions.ExecuteSqlStatementExpression","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.2512117Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":3,"Sql":"ALTER TABLE [UFRecordFields] ADD CONSTRAINT [PK_UFRecordFields] PRIMARY KEY CLUSTERED ([Key])","SourceContext":"Umbraco.Core.Migrations.Expressions.Execute.Expressions.ExecuteSqlStatementExpression","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.2512117Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":4,"Sql":"CREATE NONCLUSTERED INDEX [IX_record_recordfield] ON [UFRecordFields] ([Record])","SourceContext":"Umbraco.Core.Migrations.Expressions.Execute.Expressions.ExecuteSqlStatementExpression","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.2668453Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":5,"Sql":"CREATE TABLE [UFRecordDataString] ([Id] INTEGER NOT NULL IDENTITY(1,1),[Key] UniqueIdentifier NOT NULL,[Value] NVARCHAR(255) NOT NULL)","SourceContext":"Umbraco.Core.Migrations.Expressions.Execute.Expressions.ExecuteSqlStatementExpression","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.2668453Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":6,"Sql":"ALTER TABLE [UFRecordDataString] ADD CONSTRAINT [PK_UFRecordDataString] PRIMARY KEY CLUSTERED ([Id])","SourceContext":"Umbraco.Core.Migrations.Expressions.Execute.Expressions.ExecuteSqlStatementExpression","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.2668453Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":7,"Sql":"ALTER TABLE [UFRecordDataString] ADD CONSTRAINT [FK_UFRecordDataString_UFRecordFields_Key] FOREIGN KEY ([Key]) REFERENCES [UFRecordFields] ([Key])","SourceContext":"Umbraco.Core.Migrations.Expressions.Execute.Expressions.ExecuteSqlStatementExpression","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.2668453Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":8,"Sql":"CREATE NONCLUSTERED INDEX [IX_datastring_recordfield] ON [UFRecordDataString] ([Key])","SourceContext":"Umbraco.Core.Migrations.Expressions.Execute.Expressions.ExecuteSqlStatementExpression","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.2668453Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":9,"Sql":"CREATE TABLE [UFRecordDataLongString] ([Id] INTEGER NOT NULL IDENTITY(1,1),[Key] UniqueIdentifier NOT NULL,[Value] NTEXT NULL)","SourceContext":"Umbraco.Core.Migrations.Expressions.Execute.Expressions.ExecuteSqlStatementExpression","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.2824790Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":10,"Sql":"CREATE TABLE [UFRecordDataInteger] ([Id] INTEGER NOT NULL IDENTITY(1,1),[Key] UniqueIdentifier NOT NULL,[Value] INTEGER NULL)","SourceContext":"Umbraco.Core.Migrations.Expressions.Execute.Expressions.ExecuteSqlStatementExpression","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.2824790Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":11,"Sql":"CREATE TABLE [UFRecordDataBit] ([Id] INTEGER NOT NULL IDENTITY(1,1),[Key] UniqueIdentifier NOT NULL,[Value] BIT NULL)","SourceContext":"Umbraco.Core.Migrations.Expressions.Execute.Expressions.ExecuteSqlStatementExpression","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.2824790Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":12,"Sql":"CREATE TABLE [UFRecordDataDateTime] ([Id] INTEGER NOT NULL IDENTITY(1,1),[Key] UniqueIdentifier NOT NULL,[Value] DATETIME NULL)","SourceContext":"Umbraco.Core.Migrations.Expressions.Execute.Expressions.ExecuteSqlStatementExpression","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.3137346Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":13,"Sql":"CREATE TABLE [UFUserSecurity] ([User] NVARCHAR(50) NOT NULL,[ManageDataSources] BIT NOT NULL,[ManagePreValueSources] BIT NOT NULL,[ManageWorkflows] BIT NOT NULL,[ManageForms] BIT NOT NULL,[ViewEntries] BIT NOT NULL CONSTRAINT [DF_UFUserSecurity_ViewEntries] DEFAULT ('0'),[EditEntries] BIT NOT NULL CONSTRAINT [DF_UFUserSecurity_EditEntries] DEFAULT ('0'))","SourceContext":"Umbraco.Core.Migrations.Expressions.Execute.Expressions.ExecuteSqlStatementExpression","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.3293609Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":14,"Sql":"CREATE TABLE [UFUserFormSecurity] ([Id] INTEGER NOT NULL IDENTITY(1,1),[User] NVARCHAR(50) NOT NULL,[Form] UniqueIdentifier NOT NULL,[HasAccess] BIT NOT NULL,[AllowInEditor] BIT NOT NULL,[SecurityType] INTEGER NOT NULL)","SourceContext":"Umbraco.Core.Migrations.Expressions.Execute.Expressions.ExecuteSqlStatementExpression","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.3293609Z","@mt":"At {OrigState}","OrigState":"{forms-init-db}","SourceContext":"Umbraco.Core.Migrations.MigrationPlan","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.3293609Z","@mt":"Execute {MigrationType}","MigrationType":"AddFormsTrialLicense","SourceContext":"Umbraco.Core.Migrations.MigrationPlan","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.3293609Z","@mt":"At {OrigState}","OrigState":"{forms-init-license}","SourceContext":"Umbraco.Core.Migrations.MigrationPlan","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.3293609Z","@mt":"Execute {MigrationType}","MigrationType":"AddFormsMacro","SourceContext":"Umbraco.Core.Migrations.MigrationPlan","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.5012256Z","@mt":"At {OrigState}","OrigState":"{forms-init-macro}","SourceContext":"Umbraco.Core.Migrations.MigrationPlan","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.5012256Z","@mt":"Execute {MigrationType}","MigrationType":"AddFormsApplicationPermission","SourceContext":"Umbraco.Core.Migrations.MigrationPlan","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.5480991Z","@mt":"At {OrigState}","OrigState":"{forms-init-complete}","SourceContext":"Umbraco.Core.Migrations.MigrationPlan","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.5480991Z","@mt":"Execute {MigrationType}","MigrationType":"AddRecordKeysAndIndexes","SourceContext":"Umbraco.Core.Migrations.MigrationPlan","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.5793862Z","@mt":"Database migration step not completed: could not create primary key constraint on UFRecordDataBit as a primary key already exists.","SourceContext":"Umbraco.Forms.Core.Migrations.V_8_7_0.AddRecordKeysAndIndexes","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.5949737Z","@mt":"Database migration step not completed: could not create primary key constraint on UFRecordDataDateTime as a primary key already exists.","SourceContext":"Umbraco.Forms.Core.Migrations.V_8_7_0.AddRecordKeysAndIndexes","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.5949737Z","@mt":"Database migration step not completed: could not create primary key constraint on UFRecordDataInteger as a primary key already exists.","SourceContext":"Umbraco.Forms.Core.Migrations.V_8_7_0.AddRecordKeysAndIndexes","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.6105986Z","@mt":"Database migration step not completed: could not create primary key constraint on UFRecordDataLongString as a primary key already exists.","SourceContext":"Umbraco.Forms.Core.Migrations.V_8_7_0.AddRecordKeysAndIndexes","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.6262322Z","@mt":"Database migration step not completed: could not create foreign key constraint between UFRecordFields.Record and UFRecords.Id as a constraint with the name FK_UFRecordFields_UFRecords_Record already exists.","SourceContext":"Umbraco.Forms.Core.Migrations.V_8_7_0.AddRecordKeysAndIndexes","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.6418508Z","@mt":"Database migration step not completed: could not create foreign key constraint between UFRecordDataBit.Key and UFRecordFields.Key as a constraint with the name FK_UFRecordDataBit_UFRecordFields_Key already exists.","SourceContext":"Umbraco.Forms.Core.Migrations.V_8_7_0.AddRecordKeysAndIndexes","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.6418508Z","@mt":"Database migration step not completed: could not create foreign key constraint between UFRecordDataDateTime.Key and UFRecordFields.Key as a constraint with the name FK_UFRecordDataDateTime_UFRecordFields_Key already exists.","SourceContext":"Umbraco.Forms.Core.Migrations.V_8_7_0.AddRecordKeysAndIndexes","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.6418508Z","@mt":"Database migration step not completed: could not create foreign key constraint between UFRecordDataInteger.Key and UFRecordFields.Key as a constraint with the name FK_UFRecordDataInteger_UFRecordFields_Key already exists.","SourceContext":"Umbraco.Forms.Core.Migrations.V_8_7_0.AddRecordKeysAndIndexes","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.6418508Z","@mt":"Database migration step not completed: could not create foreign key constraint between UFRecordDataLongString.Key and UFRecordFields.Key as a constraint with the name FK_UFRecordDataLongString_UFRecordFields_Key already exists.","SourceContext":"Umbraco.Forms.Core.Migrations.V_8_7_0.AddRecordKeysAndIndexes","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.6575237Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":15,"Sql":"CREATE NONCLUSTERED INDEX [IX_UFRecordDataBit_Key] ON [UFRecordDataBit] ([Key])","SourceContext":"Umbraco.Core.Migrations.Expressions.Common.Expressions.CreateIndexExpression","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.6575237Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":16,"Sql":"CREATE NONCLUSTERED INDEX [IX_UFRecordDataDateTime_Key] ON [UFRecordDataDateTime] ([Key])","SourceContext":"Umbraco.Core.Migrations.Expressions.Common.Expressions.CreateIndexExpression","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.6731068Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":17,"Sql":"CREATE NONCLUSTERED INDEX [IX_UFRecordDataInteger_Key] ON [UFRecordDataInteger] ([Key])","SourceContext":"Umbraco.Core.Migrations.Expressions.Common.Expressions.CreateIndexExpression","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.6731068Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":18,"Sql":"CREATE NONCLUSTERED INDEX [IX_UFRecordDataLongString_Key] ON [UFRecordDataLongString] ([Key])","SourceContext":"Umbraco.Core.Migrations.Expressions.Common.Expressions.CreateIndexExpression","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.6887658Z","@mt":"Database migration step not completed: could not create primary key constraint on UFUserSecurity as a primary key already exists.","SourceContext":"Umbraco.Forms.Core.Migrations.V_8_7_0.AddRecordKeysAndIndexes","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.6887658Z","@mt":"Database migration step not completed: could not create primary key constraint on UFUserFormSecurity as a primary key already exists.","SourceContext":"Umbraco.Forms.Core.Migrations.V_8_7_0.AddRecordKeysAndIndexes","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.7043719Z","@mt":"Database migration step not completed: could not create unique constraint on the User, Form columns in UFUserFormSecurity as a constraint with the name UK_UFUserFormSecurity_User_Form already exists.","SourceContext":"Umbraco.Forms.Core.Migrations.V_8_7_0.AddRecordKeysAndIndexes","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.7043719Z","@mt":"At {OrigState}","OrigState":"6822cdca-1dc4-4983-b189-9c45314e8747","SourceContext":"Umbraco.Core.Migrations.MigrationPlan","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.7043719Z","@mt":"Execute {MigrationType}","MigrationType":"AddViewAndEditEntriesPermissions","SourceContext":"Umbraco.Core.Migrations.MigrationPlan","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.7356092Z","@mt":"At {OrigState}","OrigState":"70153aa8-c130-4900-ba9c-ad3a0a929079","SourceContext":"Umbraco.Core.Migrations.MigrationPlan","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.7356092Z","@mt":"Execute {MigrationType}","MigrationType":"AddRecordAudit","SourceContext":"Umbraco.Core.Migrations.MigrationPlan","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.7356092Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":19,"Sql":"CREATE TABLE [UFRecordAudit] ([Id] INTEGER NOT NULL IDENTITY(1,1),[Record] INTEGER NOT NULL,[UpdatedOn] DATETIME NOT NULL,[UpdatedBy] INTEGER NULL)","SourceContext":"Umbraco.Core.Migrations.Expressions.Execute.Expressions.ExecuteSqlStatementExpression","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.7356092Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":20,"Sql":"ALTER TABLE [UFRecordAudit] ADD CONSTRAINT [PK_UFRecordAudit] PRIMARY KEY CLUSTERED ([Id])","SourceContext":"Umbraco.Core.Migrations.Expressions.Execute.Expressions.ExecuteSqlStatementExpression","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.7356092Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":21,"Sql":"ALTER TABLE [UFRecordAudit] ADD CONSTRAINT [FK_UFRecordAudit_UFRecords_Id] FOREIGN KEY ([Record]) REFERENCES [UFRecords] ([Id])","SourceContext":"Umbraco.Core.Migrations.Expressions.Execute.Expressions.ExecuteSqlStatementExpression","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.7512377Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":22,"Sql":"CREATE NONCLUSTERED INDEX [IX_Record_RecordAudit] ON [UFRecordAudit] ([Record])","SourceContext":"Umbraco.Core.Migrations.Expressions.Execute.Expressions.ExecuteSqlStatementExpression","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.7512377Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":23,"Sql":"CREATE NONCLUSTERED INDEX [IX_Record_UpdatedBy] ON [UFRecordAudit] ([UpdatedBy])","SourceContext":"Umbraco.Core.Migrations.Expressions.Execute.Expressions.ExecuteSqlStatementExpression","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.7512377Z","@mt":"At {OrigState}","OrigState":"0b07a932-cc1e-4c22-974b-821e8bc61689","SourceContext":"Umbraco.Core.Migrations.MigrationPlan","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.7512377Z","@mt":"Execute {MigrationType}","MigrationType":"AddUserGroupPermissions","SourceContext":"Umbraco.Core.Migrations.MigrationPlan","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.7512377Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":24,"Sql":"CREATE TABLE [UFUserGroupSecurity] ([UserGroupId] INTEGER NOT NULL,[ManageDataSources] BIT NOT NULL,[ManagePreValueSources] BIT NOT NULL,[ManageWorkflows] BIT NOT NULL,[ManageForms] BIT NOT NULL,[ViewEntries] BIT NOT NULL CONSTRAINT [DF_UFUserGroupSecurity_ViewEntries] DEFAULT ('0'),[EditEntries] BIT NOT NULL CONSTRAINT [DF_UFUserGroupSecurity_EditEntries] DEFAULT ('0'))","SourceContext":"Umbraco.Core.Migrations.Expressions.Execute.Expressions.ExecuteSqlStatementExpression","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:30.7512377Z","@mt":"SQL [{ContextIndex}]:","ContextIndex":25,"SourceContext":"Umbraco.Core.Migrations.Expressions.Execute.Expressions.ExecuteSqlStatementExpression","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"}
{"@t":"2024-05-21T16:53:30.7512377Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":26,"Sql":"CREATE TABLE [UFUserGroupFormSecurity] ([Id] INTEGER NOT NULL IDENTITY(1,1),[UserGroupId] INTEGER NOT NULL,[Form] UniqueIdentifier NOT NULL,[HasAccess] BIT NOT NULL,[AllowInEditor] BIT NOT NULL,[SecurityType] INTEGER NOT NULL)","SourceContext":"Umbraco.Core.Migrations.Expressions.Execute.Expressions.ExecuteSqlStatementExpression","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"}
{"@t":"2024-05-21T16:53:30.7512377Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":27,"Sql":"ALTER TABLE [UFUserGroupFormSecurity] ADD CONSTRAINT [PK_UserGroupFormSecurity] PRIMARY KEY CLUSTERED ([Id])","SourceContext":"Umbraco.Core.Migrations.Expressions.Execute.Expressions.ExecuteSqlStatementExpression","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"}
{"@t":"2024-05-21T16:53:30.7668780Z","@mt":"At {OrigState}","OrigState":"949ad38a-f7db-401d-a4f2-f79cb059da22","SourceContext":"Umbraco.Core.Migrations.MigrationPlan","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"}
{"@t":"2024-05-21T16:53:30.7668780Z","@mt":"Execute {MigrationType}","MigrationType":"AddUserGroupPermissionsConstraints","SourceContext":"Umbraco.Core.Migrations.MigrationPlan","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"}
{"@t":"2024-05-21T16:53:30.7668780Z","@mt":"Database migration step not completed: could not create primary key constraint on UFUserGroupSecurity as a primary key already exists.","SourceContext":"Umbraco.Forms.Core.Migrations.V_8_11_0.AddUserGroupPermissionsConstraints","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"}
{"@t":"2024-05-21T16:53:30.7824860Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":28,"Sql":"ALTER TABLE [UFUserGroupFormSecurity] ADD CONSTRAINT [PK_UFUserGroupFormSecurity] PRIMARY KEY CLUSTERED ([Id])","SourceContext":"Umbraco.Core.Migrations.Expressions.Create.Expressions.CreateConstraintExpression","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"}
{"@t":"2024-05-21T16:53:30.7981053Z","@mt":"Exception ({InstanceId}).","@l":"Error","@x":"System.Data.SqlClient.SqlException (0x80131904): Table 'UFUserGroupFormSecurity' already has a primary key defined on it.\r\nCould not create constraint or index. See previous errors.\r\n at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action
1 wrapCloseInAction)\r\n at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)\r\n at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)\r\n at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)\r\n at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)\r\n at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()\r\n at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func1 func)\r\n at NPoco.Database.ExecuteNonQueryHelper(DbCommand cmd)\r\n at NPoco.Database.Execute(String sql, CommandType commandType, Object[] args)\r\n at Umbraco.Core.Migrations.MigrationExpressionBase.ExecuteStatement(StringBuilder stmtBuilder)\r\n at Umbraco.Core.Migrations.MigrationExpressionBase.Execute()\r\n at Umbraco.Forms.Core.Migrations.FormsMigrationBase.AddPrimaryKey[TDto](String table, String[] columns)\r\n at Umbraco.Forms.Core.Migrations.FormsMigrationBase.AddPrimaryKey[TDto](String table, String column)\r\n at Umbraco.Forms.Core.Migrations.V_8_11_0.AddUserGroupPermissionsConstraints.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.Forms.Core.Components.UmbracoFormsComponent.ExecuteDatabaseUpgrades()\r\n at Umbraco.Forms.Core.Components.UmbracoFormsComponent.Initialize()\r\n at Umbraco.Core.Composing.ComponentCollection.Initialize()\r\n at Umbraco.Core.Runtime.CoreRuntime.Boot(IRegister register, DisposableTimer timer)\r\nClientConnectionId:0adf1c48-f3f3-4f04-b9fd-47be364f42c4\r\nError Number:1779,State:0,Class:16","InstanceId":"ed9a015c","SourceContext":"Umbraco.Core.Persistence.UmbracoDatabase","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"ERROR","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:57.8734139Z","@mt":"{FailMessage} ({Duration}ms) [Timing {TimingId}]","@l":"Error","@x":"Umbraco.Core.Exceptions.BootFailedException: Boot failed. ---> System.Data.SqlClient.SqlException: Table 'UFUserGroupFormSecurity' already has a primary key defined on it.\r\nCould not create constraint or index. See previous errors.\r\n at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)\r\n at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)\r\n at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)\r\n at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)\r\n at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)\r\n at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()\r\n at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func1 func)\r\n at NPoco.Database.ExecuteNonQueryHelper(DbCommand cmd)\r\n at NPoco.Database.Execute(String sql, CommandType commandType, Object[] args)\r\n at Umbraco.Core.Migrations.MigrationExpressionBase.ExecuteStatement(StringBuilder stmtBuilder)\r\n at Umbraco.Core.Migrations.MigrationExpressionBase.Execute()\r\n at Umbraco.Forms.Core.Migrations.FormsMigrationBase.AddPrimaryKey[TDto](String table, String[] columns)\r\n at Umbraco.Forms.Core.Migrations.FormsMigrationBase.AddPrimaryKey[TDto](String table, String column)\r\n at Umbraco.Forms.Core.Migrations.V_8_11_0.AddUserGroupPermissionsConstraints.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.Forms.Core.Components.UmbracoFormsComponent.ExecuteDatabaseUpgrades()\r\n at Umbraco.Forms.Core.Components.UmbracoFormsComponent.Initialize()\r\n at Umbraco.Core.Composing.ComponentCollection.Initialize()\r\n at Umbraco.Core.Runtime.CoreRuntime.Boot(IRegister register, DisposableTimer timer)\r\n --- End of inner exception stack trace ---","FailMessage":"Boot failed.","Duration":29865,"TimingId":"b60b8ab","SourceContext":"Umbraco.Core.Runtime.CoreRuntime","ProcessId":3540,"ProcessName":"w3wp","ThreadId":9,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"ERROR","HttpRequestNumber":1,"HttpRequestId":"147d39b4-753b-427b-a2c8-f24ba9c12b54"} {"@t":"2024-05-21T16:53:57.9671733Z","@mt":"An unhandled exception occurred","@l":"Error","@x":"Umbraco.Core.Exceptions.BootFailedException: Boot failed: Umbraco cannot run. See Umbraco's log file for more details.\n\n-> Umbraco.Core.Exceptions.BootFailedException: Boot failed.\n\n-> System.Data.SqlClient.SqlException: Table 'UFUserGroupFormSecurity' already has a primary key defined on it.\r\nCould not create constraint or index. See previous errors.\n at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)\r\n at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)\r\n at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)\r\n at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)\r\n at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)\r\n at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()\r\n at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func1 func)\r\n at NPoco.Database.ExecuteNonQueryHelper(DbCommand cmd)\r\n at NPoco.Database.Execute(String sql, CommandType commandType, Object[] args)\r\n at Umbraco.Core.Migrations.MigrationExpressionBase.ExecuteStatement(StringBuilder stmtBuilder)\r\n at Umbraco.Core.Migrations.MigrationExpressionBase.Execute()\r\n at Umbraco.Forms.Core.Migrations.FormsMigrationBase.AddPrimaryKey[TDto](String table, String[] columns)\r\n at Umbraco.Forms.Core.Migrations.FormsMigrationBase.AddPrimaryKey[TDto](String table, String column)\r\n at Umbraco.Forms.Core.Migrations.V_8_11_0.AddUserGroupPermissionsConstraints.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.Forms.Core.Components.UmbracoFormsComponent.ExecuteDatabaseUpgrades()\r\n at Umbraco.Forms.Core.Components.UmbracoFormsComponent.Initialize()\r\n at Umbraco.Core.Composing.ComponentCollection.Initialize()\r\n at Umbraco.Core.Runtime.CoreRuntime.Boot(IRegister register, DisposableTimer timer)\r\n at Umbraco.Core.Exceptions.BootFailedException.Rethrow(BootFailedException bootFailedException)\r\n at System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()\r\n at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)\r\n at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)","SourceContext":"Umbraco.Web.UmbracoApplicationBase","ProcessId":3540,"ProcessName":"w3wp","ThreadId":12,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"ERROR","HttpRequestNumber":2,"HttpRequestId":"3cd8efe9-09fc-4383-b29f-41316b993457"} {"@t":"2024-05-21T16:53:58.5611730Z","@mt":"An unhandled exception occurred","@l":"Error","@x":"Umbraco.Core.Exceptions.BootFailedException: Boot failed: Umbraco cannot run. See Umbraco's log file for more details.\n\n-> Umbraco.Core.Exceptions.BootFailedException: Boot failed.\n\n-> System.Data.SqlClient.SqlException: Table 'UFUserGroupFormSecurity' already has a primary key defined on it.\r\nCould not create constraint or index. See previous errors.\n at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)\r\n at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)\r\n at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)\r\n at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)\r\n at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)\r\n at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()\r\n at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func1 func)\r\n at NPoco.Database.ExecuteNonQueryHelper(DbCommand cmd)\r\n at NPoco.Database.Execute(String sql, CommandType commandType, Object[] args)\r\n at Umbraco.Core.Migrations.MigrationExpressionBase.ExecuteStatement(StringBuilder stmtBuilder)\r\n at Umbraco.Core.Migrations.MigrationExpressionBase.Execute()\r\n at Umbraco.Forms.Core.Migrations.FormsMigrationBase.AddPrimaryKey[TDto](String table, String[] columns)\r\n at Umbraco.Forms.Core.Migrations.FormsMigrationBase.AddPrimaryKey[TDto](String table, String column)\r\n at Umbraco.Forms.Core.Migrations.V_8_11_0.AddUserGroupPermissionsConstraints.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.Forms.Core.Components.UmbracoFormsComponent.ExecuteDatabaseUpgrades()\r\n at Umbraco.Forms.Core.Components.UmbracoFormsComponent.Initialize()\r\n at Umbraco.Core.Composing.ComponentCollection.Initialize()\r\n at Umbraco.Core.Runtime.CoreRuntime.Boot(IRegister register, DisposableTimer timer)\r\n at Umbraco.Core.Exceptions.BootFailedException.Rethrow(BootFailedException bootFailedException)\r\n at System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()\r\n at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)\r\n at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)","SourceContext":"Umbraco.Web.UmbracoApplicationBase","ProcessId":3540,"ProcessName":"w3wp","ThreadId":19,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"ERROR","HttpRequestNumber":3,"HttpRequestId":"751f5a5a-e589-43c4-8949-7a274d8dd770"} {"@t":"2024-05-21T17:14:53.6705426Z","@mt":"{LogPrefix} Terminating {Immediate}","LogPrefix":"[Umbraco.Web.Scheduling.IBackgroundTask] ","Immediate":"","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":71,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:53.6705426Z","@mt":"{LogPrefix} Terminating {Immediate}","LogPrefix":"[ServerRegistration] ","Immediate":"","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":71,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:53.6705426Z","@mt":"{LogPrefix} Terminating {Immediate}","LogPrefix":"[HealthCheckNotifier] ","Immediate":"","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":71,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:53.6705426Z","@mt":"{LogPrefix} Terminating {Immediate}","LogPrefix":"[ScheduledTasks] ","Immediate":"","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":71,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:53.6705426Z","@mt":"{LogPrefix} Terminating {Immediate}","LogPrefix":"[ScheduledPublishing] ","Immediate":"","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":71,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:53.6705426Z","@mt":"{LogPrefix} Terminating {Immediate}","LogPrefix":"[ContentVersionCleanup] ","Immediate":"","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":71,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:53.6705426Z","@mt":"{LogPrefix} Terminating {Immediate}","LogPrefix":"[TempFileCleanup] ","Immediate":"","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":71,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:53.6705426Z","@mt":"{LogPrefix} Terminating {Immediate}","LogPrefix":"[TelemetryReporter] ","Immediate":"","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":71,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:53.6705426Z","@mt":"{LogPrefix} Terminating {Immediate}","LogPrefix":"[LogScrubber] ","Immediate":"","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":71,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:53.6705426Z","@mt":"{LogPrefix} Terminating {Immediate}","LogPrefix":"[KeepAlive] ","Immediate":"","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":71,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:53.6705426Z","@mt":"Stopping ({SignalSource})","SignalSource":"environment","SourceContext":"Umbraco.Core.Runtime.MainDom","ProcessId":3540,"ProcessName":"w3wp","ThreadId":71,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:53.6861239Z","@mt":"{StartMessage} [Timing {TimingId}]","StartMessage":"Examine shutting down","TimingId":"a137aa3","SourceContext":"Umbraco.Web.Search.ExamineComponent","ProcessId":3540,"ProcessName":"w3wp","ThreadId":71,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:53.7017481Z","@mt":"{EndMessage} ({Duration}ms) [Timing {TimingId}]","EndMessage":"Completed.","Duration":14,"TimingId":"a137aa3","SourceContext":"Umbraco.Web.Search.ExamineComponent","ProcessId":3540,"ProcessName":"w3wp","ThreadId":71,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:53.7017481Z","@mt":"Released ({SignalSource})","SignalSource":"environment","SourceContext":"Umbraco.Core.Runtime.MainDom","ProcessId":3540,"ProcessName":"w3wp","ThreadId":71,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:53.7017481Z","@mt":"{LogPrefix} Terminating {Immediate}","LogPrefix":"[ServerInstProcess] ","Immediate":"","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":71,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:53.7017481Z","@mt":"{LogPrefix} Canceling tasks","LogPrefix":"[Umbraco.Web.Scheduling.IBackgroundTask] ","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":70,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:53.7017481Z","@mt":"{LogPrefix} Tasks {TaskStatus}, terminated","LogPrefix":"[Umbraco.Web.Scheduling.IBackgroundTask] ","TaskStatus":"cancelled","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":70,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:53.7017481Z","@mt":"{LogPrefix} Canceling tasks","LogPrefix":"[ServerRegistration] ","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":74,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:53.7017481Z","@mt":"{LogPrefix} Tasks {TaskStatus}, terminated","LogPrefix":"[ServerRegistration] ","TaskStatus":"cancelled","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":74,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:53.7017481Z","@mt":"{LogPrefix} Canceling tasks","LogPrefix":"[HealthCheckNotifier] ","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":72,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:53.7017481Z","@mt":"{LogPrefix} Tasks {TaskStatus}, terminated","LogPrefix":"[HealthCheckNotifier] ","TaskStatus":"cancelled","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":72,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:53.7017481Z","@mt":"{LogPrefix} Canceling tasks","LogPrefix":"[ScheduledTasks] ","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":69,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:53.7017481Z","@mt":"{LogPrefix} Tasks {TaskStatus}, terminated","LogPrefix":"[ScheduledTasks] ","TaskStatus":"cancelled","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":69,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:54.6766768Z","@mt":"{LogPrefix} Canceling tasks","LogPrefix":"[ScheduledPublishing] ","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":76,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:54.6766768Z","@mt":"{LogPrefix} Tasks {TaskStatus}, terminated","LogPrefix":"[ScheduledPublishing] ","TaskStatus":"cancelled","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":76,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:55.6707684Z","@mt":"{LogPrefix} Canceling tasks","LogPrefix":"[ContentVersionCleanup] ","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":78,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:55.6707684Z","@mt":"{LogPrefix} Tasks {TaskStatus}, terminated","LogPrefix":"[ContentVersionCleanup] ","TaskStatus":"cancelled","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":78,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:55.7176274Z","@mt":"{LogPrefix} Canceling tasks","LogPrefix":"[ScheduledTasks] ","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":69,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:55.7176274Z","@mt":"{LogPrefix} Canceling tasks","LogPrefix":"[TempFileCleanup] ","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":69,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:55.7176274Z","@mt":"{LogPrefix} Tasks {TaskStatus}, terminated","LogPrefix":"[TempFileCleanup] ","TaskStatus":"cancelled","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":69,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:55.7176274Z","@mt":"{LogPrefix} Canceling tasks","LogPrefix":"[HealthCheckNotifier] ","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":72,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:55.7176274Z","@mt":"{LogPrefix} Canceling tasks","LogPrefix":"[ServerRegistration] ","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":74,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:55.7176274Z","@mt":"{LogPrefix} Canceling tasks","LogPrefix":"[LogScrubber] ","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":74,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:55.7176274Z","@mt":"{LogPrefix} Tasks {TaskStatus}, terminated","LogPrefix":"[LogScrubber] ","TaskStatus":"cancelled","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":74,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:55.7176274Z","@mt":"{LogPrefix} Canceling tasks","LogPrefix":"[Umbraco.Web.Scheduling.IBackgroundTask] ","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":70,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:55.7176274Z","@mt":"{LogPrefix} Canceling tasks","LogPrefix":"[KeepAlive] ","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":70,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:55.7176274Z","@mt":"{LogPrefix} Tasks {TaskStatus}, terminated","LogPrefix":"[KeepAlive] ","TaskStatus":"cancelled","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":70,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:56.6690040Z","@mt":"{LogPrefix} Canceling tasks","LogPrefix":"[ServerInstProcess] ","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":79,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:56.6690040Z","@mt":"{LogPrefix} Tasks {TaskStatus}, terminated","LogPrefix":"[ServerInstProcess] ","TaskStatus":"cancelled","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":79,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:56.7001901Z","@mt":"{LogPrefix} Canceling tasks","LogPrefix":"[ScheduledPublishing] ","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":76,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:56.7001901Z","@mt":"{LogPrefix} Canceling tasks","LogPrefix":"[TelemetryReporter] ","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":76,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:56.7001901Z","@mt":"{LogPrefix} Tasks {TaskStatus}, terminated","LogPrefix":"[TelemetryReporter] ","TaskStatus":"cancelled","SourceContext":"Umbraco.Web.Scheduling.BackgroundTaskRunner","ProcessId":3540,"ProcessName":"w3wp","ThreadId":76,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "} {"@t":"2024-05-21T17:14:56.7782913Z","@mt":"Application shutdown. Details: {ShutdownReason}\r\n\r\n_shutDownMessage={ShutdownMessage}\r\n\r\n_shutDownStack={ShutdownStack}","ShutdownReason":"HostingEnvironment","ShutdownMessage":"HostingEnvironment initiated shutdown\r\nHostingEnvironment caused shutdown","ShutdownStack":" at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)\r\n at System.Environment.get_StackTrace()\r\n at System.Web.Hosting.HostingEnvironment.InitiateShutdownInternal()\r\n at System.Web.Hosting.HostingEnvironment.InitiateShutdownWithoutDemand()\r\n at System.Web.Hosting.PipelineRuntime.StopProcessing()","SourceContext":"Umbraco.Web.UmbracoApplicationBase","ProcessId":3540,"ProcessName":"w3wp","ThreadId":76,"AppDomainId":4,"AppDomainAppId":"LMW3SVC1ROOT","MachineName":"C-GOA-APM-11034","Log4NetLevel":"INFO "}