05.05.2019 23.37.42 Updates initialized
05.05.2019 23.37.42 Package 2090 from updates.xml.aspx
05.05.2019 23.37.42 file C:\Dynamicweb\Solutions\unilabs.local\Templates\eCom\ProductCatalog\ProductViewListFacets.cshtml already exists.
05.05.2019 23.37.42 Package 2091 from updates.xml.aspx
05.05.2019 23.37.42 Standard SQL applied.
UPDATE [Module] SET [ModuleIconClass] = 'SwitchCamera' WHERE [ModuleSystemName] = 'DataPortability';
05.05.2019 23.37.42 Package 2092 from updates.xml.aspx
05.05.2019 23.37.42 Setting /Globalsettings/Settings/Auditing/EnableAuditing already exists.
05.05.2019 23.37.42 Package 2093 from updates.xml.aspx
05.05.2019 23.37.42 Conditional present - escaping.
05.05.2019 23.37.42 Package 2094 from updates.xml.aspx
05.05.2019 23.37.42 Conditional present - escaping.
05.05.2019 23.37.42 Conditional present - escaping.
05.05.2019 23.37.42 Conditional present - escaping.
05.05.2019 23.37.42 Package 2095 from updates.xml.aspx
05.05.2019 23.37.42 Setting /Globalsettings/System/Tracking/TableTimeInterval already exists.
05.05.2019 23.37.42 Setting /Globalsettings/System/Tracking/EnableTracking already exists.
05.05.2019 23.37.42 Setting /Globalsettings/System/Tracking/EnableLogging already exists.
05.05.2019 23.37.42 Package 2096 from updates.xml.aspx
05.05.2019 23.37.42 file C:\Dynamicweb\Solutions\unilabs.local\Templates\Filepublish\FilepublishList.cshtml already exists.
05.05.2019 23.37.43 Updates initialized
05.05.2019 23.37.43 Package 2105 from ecom.xml.aspx
05.05.2019 23.37.43 Conditional present - escaping.
05.05.2019 23.37.43 Package 2106 from ecom.xml.aspx
05.05.2019 23.37.43 Conditional present - escaping.
05.05.2019 23.37.43 Package 2107 from ecom.xml.aspx
05.05.2019 23.37.43 Conditional present - escaping.
05.05.2019 23.37.43 Conditional present - escaping.
05.05.2019 23.37.43 Conditional present - escaping.
05.05.2019 23.37.43 Conditional present - escaping.
05.05.2019 23.37.43 Conditional present - escaping.
05.05.2019 23.37.43 Conditional present - escaping.
05.05.2019 23.37.44 Conditional present - escaping.
05.05.2019 23.37.44 Conditional present - escaping.
05.05.2019 23.37.44 Conditional present - escaping.
05.05.2019 23.37.44 Conditional present - escaping.
05.05.2019 23.37.44 Package 2108 from ecom.xml.aspx
05.05.2019 23.37.44 Conditional present - escaping.
05.05.2019 23.37.44 Package 2109 from ecom.xml.aspx
05.05.2019 23.37.44 Conditional present - escaping.
05.05.2019 23.37.44 Package 2110 from ecom.xml.aspx
05.05.2019 23.37.44 Conditional present - escaping.
05.05.2019 23.37.44 Package 2111 from ecom.xml.aspx
05.05.2019 23.37.44 Conditional present - escaping.
8/1/2019 8:02:37 AM Updates initialized
8/1/2019 8:02:37 AM Updates initialized
8/1/2019 8:02:37 AM Package 2106 from ecom.xml.aspx
8/1/2019 8:02:37 AM Conditional present - escaping.
8/1/2019 8:02:37 AM Package 2107 from ecom.xml.aspx
8/1/2019 8:02:37 AM Conditional present - escaping.
8/1/2019 8:02:37 AM Conditional present - escaping.
8/1/2019 8:02:37 AM Conditional present - escaping.
8/1/2019 8:02:37 AM Conditional present - escaping.
8/1/2019 8:02:37 AM Conditional present - escaping.
8/1/2019 8:02:37 AM Conditional present - escaping.
8/1/2019 8:02:37 AM Conditional present - escaping.
8/1/2019 8:02:37 AM Conditional present - escaping.
8/1/2019 8:02:37 AM Conditional present - escaping.
8/1/2019 8:02:37 AM Conditional present - escaping.
8/1/2019 8:02:37 AM Package 2108 from ecom.xml.aspx
8/1/2019 8:02:37 AM Conditional present - escaping.
8/1/2019 8:02:37 AM Package 2109 from ecom.xml.aspx
8/1/2019 8:02:37 AM Conditional present - escaping.
8/1/2019 8:02:37 AM Package 2110 from ecom.xml.aspx
8/1/2019 8:02:37 AM Conditional present - escaping.
8/1/2019 8:02:37 AM Package 2111 from ecom.xml.aspx
8/1/2019 8:02:37 AM Conditional present - escaping.
8/1/2019 8:02:37 AM Package 2112 from ecom.xml.aspx
8/1/2019 8:02:37 AM Conditional present - escaping.
8/1/2019 8:02:37 AM Package 2113 from ecom.xml.aspx
8/1/2019 8:02:37 AM file D:\home\site\wwwroot\Dynamicweb\Solution\Templates\eCom7\CheckoutHandler\DibsEasy\Form\EmbededDibs.html already exists.
8/1/2019 8:02:37 AM file D:\home\site\wwwroot\Dynamicweb\Solution\Templates\eCom7\CheckoutHandler\DibsEasy\Error\checkouthandler_error.html already exists.
10/30/2019 3:45:42 PM Updates initialized
10/30/2019 3:45:42 PM Package 2093 from updates.xml.aspx
10/30/2019 3:45:42 PM Conditional present - escaping.
10/30/2019 3:45:42 PM Package 2094 from updates.xml.aspx
10/30/2019 3:45:42 PM Conditional present - escaping.
10/30/2019 3:45:42 PM Conditional present - escaping.
10/30/2019 3:45:42 PM Conditional present - escaping.
10/30/2019 3:45:42 PM Package 2095 from updates.xml.aspx
10/30/2019 3:45:42 PM Setting /Globalsettings/System/Tracking/TableTimeInterval already exists.
10/30/2019 3:45:42 PM Setting /Globalsettings/System/Tracking/EnableTracking already exists.
10/30/2019 3:45:42 PM Setting /Globalsettings/System/Tracking/EnableLogging already exists.
10/30/2019 3:45:42 PM Package 2096 from updates.xml.aspx
10/30/2019 3:45:42 PM Package 2097 from updates.xml.aspx
10/30/2019 3:45:42 PM Conditional present - escaping.
10/30/2019 3:45:42 PM Package 2098 from updates.xml.aspx
10/30/2019 3:45:42 PM file D:\home\site\wwwroot\Dynamicweb\Solution\Templates\Filepublish\FilepublishList.cshtml already exists.
10/30/2019 3:45:42 PM Package 2099 from updates.xml.aspx
10/30/2019 3:45:43 PM Conditional empty - Standard SQL applied.
ALTER TABLE [EcomStockUnit] ADD [StockUnitProductNumber] [nvarchar](255) NULL;
10/30/2019 3:45:43 PM Package 2100 from updates.xml.aspx
10/30/2019 3:45:43 PM Conditional empty - Standard SQL applied.
CREATE TABLE dbo.[EcomStockUnitDetail] (
[StockUnitDetailId] [bigint] IDENTITY(1,1) NOT NULL,
[StockUnitDetailProductId] [nvarchar](30) NULL,
[StockUnitDetailVariantId] [nvarchar](255) NULL,
[StockUnitDetailProductNumber] [nvarchar](255) NULL,
[StockUnitDetailStockUnitId] [nvarchar](50) NULL,
[StockUnitDetailQuantity] [int] NOT NULL DEFAULT 0,
CONSTRAINT [PK_EcomStockUnitDetail] PRIMARY KEY CLUSTERED ([StockUnitDetailId] ASC)
)
10/30/2019 3:45:43 PM Package 2101 from updates.xml.aspx
10/30/2019 3:45:43 PM Conditional empty - Standard SQL applied.
CREATE UNIQUE NONCLUSTERED INDEX [DW_IX_EcomStockUnitDetail_ProductId_VariantId_ProductNumber_StockUnitId] ON [EcomStockUnitDetail]
(
[StockUnitDetailProductId] ASC,
[StockUnitDetailProductNumber] ASC,
[StockUnitDetailStockUnitId] ASC,
[StockUnitDetailVariantId] ASC
)
10/30/2019 3:45:43 PM Package 2102 from updates.xml.aspx
10/30/2019 3:45:43 PM Conditional empty - Standard SQL applied.
CREATE TABLE dbo.[AuditDeletedObject] (
[AuditDeletedObjectId] [int] IDENTITY(1,1) NOT NULL,
[AuditDeletedObjectAuditId] [int] NOT NULL,
[AuditDeletedObjectInfo] [nvarchar](255) NULL,
CONSTRAINT [PK_AuditDeletedObject] PRIMARY KEY CLUSTERED ([AuditDeletedObjectId] ASC)
)
10/30/2019 3:45:43 PM Package 2103 from updates.xml.aspx
10/30/2019 3:45:43 PM Conditional empty - Standard SQL applied.
ALTER TABLE [AuditDeletedObject] ADD [AuditDeletedObjectAuditKey1] [nvarchar](255) NULL
10/30/2019 3:45:43 PM Conditional empty - Standard SQL applied.
ALTER TABLE [AuditDeletedObject] ADD [AuditDeletedObjectAuditKey2] [nvarchar](255) NULL
10/30/2019 3:45:43 PM Conditional empty - Standard SQL applied.
ALTER TABLE [AuditDeletedObject] ADD [AuditDeletedObjectAuditKey3] [nvarchar](255) NULL
10/30/2019 3:45:43 PM Package 2104 from updates.xml.aspx
10/30/2019 3:45:43 PM Folder D:\home\site\wwwroot\Dynamicweb\Solution\System\BulkDataEdit does not exist - creating.
10/30/2019 3:45:43 PM file D:\home\site\wwwroot\Dynamicweb\Applications\Application(9.7.3)\Admin\Update\\Files\System\BulkDataEdit\BasicForms.xml added.
10/30/2019 3:45:43 PM Folder D:\home\site\wwwroot\Dynamicweb\Solution\System\BulkDataEdit does not exist - creating.
10/30/2019 3:45:43 PM file D:\home\site\wwwroot\Dynamicweb\Applications\Application(9.7.3)\Admin\Update\\Files\System\BulkDataEdit\DM_Form.xml added.
10/30/2019 3:45:43 PM Folder D:\home\site\wwwroot\Dynamicweb\Solution\System\BulkDataEdit does not exist - creating.
10/30/2019 3:45:43 PM file D:\home\site\wwwroot\Dynamicweb\Applications\Application(9.7.3)\Admin\Update\\Files\System\BulkDataEdit\eCom_CartV2.xml added.
10/30/2019 3:45:43 PM Folder D:\home\site\wwwroot\Dynamicweb\Solution\System\BulkDataEdit does not exist - creating.
10/30/2019 3:45:43 PM file D:\home\site\wwwroot\Dynamicweb\Applications\Application(9.7.3)\Admin\Update\\Files\System\BulkDataEdit\eCom_Catalog.xml added.
10/30/2019 3:45:43 PM Folder D:\home\site\wwwroot\Dynamicweb\Solution\System\BulkDataEdit does not exist - creating.
10/30/2019 3:45:43 PM file D:\home\site\wwwroot\Dynamicweb\Applications\Application(9.7.3)\Admin\Update\\Files\System\BulkDataEdit\eCom_CustomerCenter.xml added.
10/30/2019 3:45:43 PM Folder D:\home\site\wwwroot\Dynamicweb\Solution\System\BulkDataEdit does not exist - creating.
10/30/2019 3:45:43 PM file D:\home\site\wwwroot\Dynamicweb\Applications\Application(9.7.3)\Admin\Update\\Files\System\BulkDataEdit\UserManagementFrontend.xml added.
10/30/2019 3:45:43 PM Folder D:\home\site\wwwroot\Dynamicweb\Solution\System\BulkDataEdit does not exist - creating.
10/30/2019 3:45:43 PM file D:\home\site\wwwroot\Dynamicweb\Applications\Application(9.7.3)\Admin\Update\\Files\System\BulkDataEdit\UserManagementFrontendExtended.xml added.
10/30/2019 3:45:43 PM Package 2105 from updates.xml.aspx
10/30/2019 3:45:43 PM Conditional present - escaping.
10/30/2019 3:45:43 PM Conditional present - escaping.
10/30/2019 3:45:43 PM Package 2106 from updates.xml.aspx
10/30/2019 3:45:43 PM Standard SQL applied.
UPDATE [Module] SET [ModuleAccess] = 1 WHERE [ModuleSystemName] = 'QueryPublisher'
10/30/2019 3:45:43 PM Package 2107 from updates.xml.aspx
10/30/2019 3:45:43 PM Conditional empty - Standard SQL applied.
ALTER TABLE [Page] ADD [PageUrlDataProvider] [nvarchar](255) NULL
10/30/2019 3:45:43 PM Conditional empty - Standard SQL applied.
ALTER TABLE [Page] ADD [PageUrlDataProviderParameters] [nvarchar](max) NULL
10/30/2019 3:45:43 PM Package 2108 from updates.xml.aspx
10/30/2019 3:45:43 PM Conditional empty - Standard SQL applied.
CREATE TABLE dbo.[EndpointAuthentication] (
[EndpointAuthenticationId] [int] IDENTITY(1,1) NOT NULL,
[EndpointAuthenticationName] [nvarchar](255) NOT NULL,
[EndpointAuthenticationType] [nvarchar](255) NOT NULL,
[EndpointAuthenticationParameters] [nvarchar](max) NULL
CONSTRAINT [PK_EndpointAuthentication] PRIMARY KEY CLUSTERED ([EndpointAuthenticationId] ASC)
)
10/30/2019 3:45:43 PM Conditional empty - Standard SQL applied.
CREATE TABLE dbo.[Endpoint] (
[EndpointId] [int] IDENTITY(1,1) NOT NULL,
[EndpointName] [nvarchar](255) NOT NULL,
[EndpointDescription] [nvarchar](max) NULL,
[EndpointUrl] [nvarchar](max) NULL,
[EndpointAuthenticationId] [int] NULL,
[EndpointRequestType] [nvarchar](10) NULL,
[EndpointHeaders] [nvarchar](max) NULL,
[EndpointBody] [nvarchar](max) NULL
CONSTRAINT [PK_Endpoint] PRIMARY KEY CLUSTERED ([EndpointId] ASC)
)
10/30/2019 3:45:43 PM Package 2109 from updates.xml.aspx
10/30/2019 3:45:43 PM Conditional empty - Standard SQL applied.
CREATE TABLE dbo.[AccessUserToken] (
[AccessUserTokenId] [int] NOT NULL IDENTITY(1, 1),
[AccessUserTokenHash] [nvarchar](128) NOT NULL,
[AccessUserTokenUserId] [int] NOT NULL,
[AccessUserTokenDeviceId] [nvarchar](100) NULL,
[AccessUserTokenName] [nvarchar](255) NULL,
[AccessUserTokenDescription] [nvarchar](MAX) NULL,
[AccessUserTokenCreatedDate] [datetime] NOT NULL,
CONSTRAINT [PK_AccessUserToken] PRIMARY KEY CLUSTERED ([AccessUserTokenId] ASC)
)
10/30/2019 3:45:43 PM Package 2110 from updates.xml.aspx
10/30/2019 3:45:43 PM Package 2111 from updates.xml.aspx
10/30/2019 3:45:43 PM Package 2112 from updates.xml.aspx
10/30/2019 3:45:43 PM Package 2113 from updates.xml.aspx
10/30/2019 3:45:43 PM Conditional empty - Standard SQL applied.
ALTER TABLE [AccessUser] ADD [AccessUserInformationSent] [datetime] NULL
10/30/2019 3:45:43 PM Package 2114 from updates.xml.aspx
10/30/2019 3:45:43 PM Standard SQL applied.
DELETE FROM [DashboardWidget] WHERE [DashboardWidgetDashboardID] IN (SELECT d.[DashboardID] FROM [Dashboard] d WHERE d.DashboardType = 'Content')
10/30/2019 3:45:43 PM Standard SQL applied.
DELETE FROM [Dashboard] WHERE DashboardType = 'Content'
10/30/2019 3:45:43 PM Package 2115 from updates.xml.aspx
10/30/2019 3:45:43 PM Standard SQL applied.
ALTER TABLE [Area] ADD [AreaNofollow] BIT NULL
10/30/2019 3:45:43 PM Standard SQL applied.
ALTER TABLE [Area] ADD [AreaNoindex] BIT NULL
10/30/2019 3:45:43 PM Package 2116 from updates.xml.aspx
10/30/2019 3:45:43 PM Conditional empty - Standard SQL applied.
ALTER TABLE [ExternalLoginProvider] ADD [ProviderEnableForBackend] [BIT] NOT NULL DEFAULT 0;
10/30/2019 3:45:44 PM Updates initialized
10/30/2019 3:45:44 PM Package 2108 from ecom.xml.aspx
10/30/2019 3:45:44 PM Conditional present - escaping.
10/30/2019 3:45:44 PM Package 2109 from ecom.xml.aspx
10/30/2019 3:45:44 PM Conditional present - escaping.
10/30/2019 3:45:44 PM Package 2110 from ecom.xml.aspx
10/30/2019 3:45:44 PM Conditional present - escaping.
10/30/2019 3:45:44 PM Package 2111 from ecom.xml.aspx
10/30/2019 3:45:44 PM Conditional present - escaping.
10/30/2019 3:45:44 PM Package 2112 from ecom.xml.aspx
10/30/2019 3:45:44 PM file D:\home\site\wwwroot\Dynamicweb\Solution\Templates\eCom7\CheckoutHandler\DibsEasy\Form\EmbededDibs.html already exists.
10/30/2019 3:45:44 PM file D:\home\site\wwwroot\Dynamicweb\Solution\Templates\eCom7\CheckoutHandler\DibsEasy\Error\checkouthandler_error.html already exists.
10/30/2019 3:45:44 PM Package 2113 from ecom.xml.aspx
10/30/2019 3:45:44 PM Package 2114 from ecom.xml.aspx
10/30/2019 3:45:44 PM Conditional present - escaping.
10/30/2019 3:45:44 PM Package 2115 from ecom.xml.aspx
10/30/2019 3:45:44 PM Conditional present - escaping.
10/30/2019 3:45:44 PM Conditional present - escaping.
10/30/2019 3:45:44 PM Conditional empty - Standard SQL applied.
INSERT INTO DynamicStructureLevels ([DynamicStructureLevelStructureId], [DynamicStructureLevelField], [DynamicStructureLevelSortDirection], [DynamicStructureLevelIndex])
SELECT [DynamicStructureUniqueId], [DynamicStructureField1], [DynamicStructureSortDirection1], 1 from [DynamicStructures] where [DynamicStructureField1] <> ''
UNION ALL
SELECT [DynamicStructureUniqueId], [DynamicStructureField2], [DynamicStructureSortDirection2], 2 from [DynamicStructures] where [DynamicStructureField2] <> ''
UNION ALL
SELECT [DynamicStructureUniqueId], [DynamicStructureField3], [DynamicStructureSortDirection3], 3 from [DynamicStructures] where [DynamicStructureField3] <> ''
UNION ALL
SELECT [DynamicStructureUniqueId], [DynamicStructureField4], [DynamicStructureSortDirection4], 4 from [DynamicStructures] where [DynamicStructureField4] <> ''
UNION ALL
SELECT [DynamicStructureUniqueId], [DynamicStructureField5], [DynamicStructureSortDirection5], 5 from [DynamicStructures] where [DynamicStructureField5] <> ''
10/30/2019 3:45:44 PM Package 2116 from ecom.xml.aspx
10/30/2019 3:45:44 PM Conditional empty - Standard SQL applied.
ALTER TABLE [EcomDiscount] ADD [DiscountExtenderType] [nvarchar](255) NULL
10/30/2019 3:45:44 PM Conditional empty - Standard SQL applied.
ALTER TABLE [EcomDiscount] ADD [DiscountExtenderSettings] [nvarchar](MAX) NULL
10/30/2019 3:45:44 PM Package 2117 from ecom.xml.aspx
10/30/2019 3:45:44 PM Conditional empty - Standard SQL applied.
ALTER TABLE [EcomProductCategoryField] ADD [FieldForeignCategoryId] NVARCHAR(50) NULL
10/30/2019 3:45:44 PM Package 2118 from ecom.xml.aspx
10/30/2019 3:45:44 PM Conditional empty - Standard SQL applied.
DECLARE @ConstraintName NVARCHAR(100);
SELECT @ConstraintName = dc.Name FROM sys.default_constraints dc INNER JOIN sys.columns c ON dc.parent_object_id = c.object_id AND c.column_id = dc.parent_column_id where c.Name = 'CategoryProductProperties';
EXEC('ALTER TABLE EcomProductCategory DROP CONSTRAINT ' + @ConstraintName);
10/30/2019 3:45:44 PM Conditional empty - Standard SQL applied.
ALTER TABLE [EcomProductCategory] ADD [CategoryType] [INT] NULL;
10/30/2019 3:45:44 PM Conditional present - escaping.
10/30/2019 3:45:45 PM Conditional present - escaping.
10/30/2019 3:45:45 PM Package 2119 from ecom.xml.aspx
10/30/2019 3:45:45 PM Package 2120 from ecom.xml.aspx
10/30/2019 3:45:45 PM Standard SQL applied.
ALTER TABLE [EcomCountries] ALTER COLUMN [CountryCultureInfo] [nvarchar](15) NOT NULL;
10/30/2019 3:45:45 PM Package 2121 from ecom.xml.aspx
10/30/2019 3:45:45 PM Package 2122 from ecom.xml.aspx
10/30/2019 3:45:45 PM Conditional empty - Standard SQL applied.
ALTER TABLE [EcomDiscount] ADD [DiscountOrderTotalPriceCurrencyCode] [nvarchar](3) NULL
10/30/2019 3:45:45 PM Package 2123 from ecom.xml.aspx
10/30/2019 3:45:45 PM Standard SQL applied.
ALTER TABLE [EcomProducts] ADD [ProductEAN] [NVARCHAR](255) NULL
ALTER TABLE [EcomProducts] ADD [ProductWidth] FLOAT NULL
ALTER TABLE [EcomProducts] ADD [ProductHeight] FLOAT NULL
ALTER TABLE [EcomProducts] ADD [ProductDepth] FLOAT NULL
ALTER TABLE [EcomProducts] ADD [ProductNeverOutOfStock] BIT NOT NULL DEFAULT 0
10/30/2019 3:45:45 PM Package 2124 from ecom.xml.aspx
10/30/2019 3:45:45 PM Conditional present - escaping.
10/30/2019 3:45:45 PM Package 2125 from ecom.xml.aspx
10/30/2019 3:45:45 PM Setting /Globalsettings/Ecom/Unit/Dimensions has received a value "cm".
10/30/2019 3:45:45 PM Package 2126 from ecom.xml.aspx
10/30/2019 3:45:45 PM Conditional empty - Standard SQL applied.
ALTER TABLE [EcomShops] ADD
[ShopImagePatternMain] NVARCHAR(255) NULL,
[ShopImagePatternVariant] NVARCHAR(255) NULL
10/30/2019 3:45:45 PM Package 2127 from ecom.xml.aspx
10/30/2019 3:45:45 PM Conditional empty - Standard SQL applied.
CREATE TABLE dbo.[EcomGroupFacetRelation] (
[GroupFacetRelationId] [int] IDENTITY(1,1) NOT NULL,
[GroupFacetRelationGroupId] [nvarchar](255) NOT NULL,
[GroupFacetRelationRepository] [nvarchar](100) NOT NULL,
[GroupFacetRelationFacetGroup] [nvarchar](100) NOT NULL,
[GroupFacetRelationFacetField] [nvarchar](255) NOT NULL,
[GroupFacetRelationQueryParameter] [nvarchar](100) NOT NULL,
CONSTRAINT [PK_EcomGroupFacetRelation] PRIMARY KEY CLUSTERED ([GroupFacetRelationId] ASC)
)
10/30/2019 3:45:45 PM Package 2128 from ecom.xml.aspx
10/30/2019 3:45:45 PM Standard SQL applied.
ALTER TABLE [EcomShippings] ADD
[ShippingUserGroups] NVARCHAR(MAX) NULL,
[ShippingAllowAnonymousUsers] BIT NOT NULL DEFAULT 0
10/30/2019 3:45:45 PM Package 2129 from ecom.xml.aspx
10/30/2019 3:45:45 PM Conditional empty - Standard SQL applied.
INSERT INTO [EcomTree] ([Parentid],[Text],[TreeUrl],[TreeChildPopulate],[TreeSort],[TreeHasAccessModuleSystemName],[TreeIcon])
VALUES (1,'Favorite lists','/Admin/Module/eCom_CustomerCenter/FavoriteLists.aspx','FAVORITELISTS',13,'eCom_CustomerCenter','FAVORITELISTS')
10/30/2019 3:45:45 PM Package 2130 from ecom.xml.aspx
10/30/2019 3:45:45 PM Standard SQL applied.
ALTER TABLE [EcomGroupFacetRelation] ADD [GroupFacetRelationOrder] [int] NOT NULL DEFAULT 0
10/30/2019 3:45:45 PM Package 2131 from ecom.xml.aspx
10/30/2019 3:45:45 PM Conditional empty - Standard SQL applied.
ALTER TABLE [EcomGroupFacetRelation] ADD [GroupFacetRelationDisabled] [bit] NOT NULL DEFAULT 0
10/30/2019 3:45:45 PM Standard SQL applied.
ALTER TABLE [EcomGroupFacetRelation] ALTER COLUMN [GroupFacetRelationFacetField] [nvarchar](255) NULL;
ALTER TABLE [EcomGroupFacetRelation] ALTER COLUMN [GroupFacetRelationQueryParameter] [nvarchar](100) NULL;
10/30/2019 3:45:45 PM Package 2132 from ecom.xml.aspx
10/30/2019 3:45:45 PM Standard SQL applied.
UPDATE [EcomShippings] SET [ShippingActive] = 1 WHERE [ShippingActive] IS NULL
10/30/2019 3:45:45 PM Package 2133 from ecom.xml.aspx
10/30/2019 3:45:45 PM Conditional empty - Standard SQL applied.
ALTER TABLE [EcomOrders] ADD [OrderDisplayName] NVARCHAR(255) NULL;
ALTER TABLE [EcomOrders] ADD [OrderDiscountPercentage] [FLOAT] NOT NULL DEFAULT 0;
ALTER TABLE [EcomOrders] ADD [OrderDiscountAmount] [FLOAT] NOT NULL DEFAULT 0;
ALTER TABLE [EcomOrderLines] ADD [OrderLineDiscountPercentage] [FLOAT] NOT NULL DEFAULT 0;
ALTER TABLE [EcomOrderLines] ADD [OrderLineUnitPriceBeforeDiscount] [FLOAT] NOT NULL DEFAULT 0;
12/5/2019 9:18:15 AM Updates initialized
12/5/2019 9:18:15 AM Package 2111 from updates.xml.aspx
12/5/2019 9:18:15 AM Package 2112 from updates.xml.aspx
12/5/2019 9:18:15 AM Package 2113 from updates.xml.aspx
12/5/2019 9:18:16 AM Conditional present - escaping.
12/5/2019 9:18:16 AM Package 2114 from updates.xml.aspx
12/5/2019 9:18:16 AM Standard SQL applied.
DELETE FROM [DashboardWidget] WHERE [DashboardWidgetDashboardID] IN (SELECT d.[DashboardID] FROM [Dashboard] d WHERE d.DashboardType = 'Content')
12/5/2019 9:18:16 AM Standard SQL applied.
DELETE FROM [Dashboard] WHERE DashboardType = 'Content'
12/5/2019 9:18:16 AM Package 2115 from updates.xml.aspx
12/5/2019 9:18:16 AM - error: Column names in each table must be unique. Column name 'AreaNofollow' in table 'Area' is specified more than once. - System.Data.SqlClient.SqlException (0x80131904): Column names in each table must be unique. Column name 'AreaNofollow' in table 'Area' is specified more than once.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Dynamicweb.Frontend.Update.ProcessDatabase(XmlNode& xmlNode)
ClientConnectionId:fa7cd4a8-8870-4dd3-9ec3-f2cd5b43f244
Error Number:2705,State:4,Class:16
ClientConnectionId before routing:f8f4dff3-fc93-4423-b05c-ffa1963612a3
Routing Destination:b307131aedd0.tr21.westeurope1-a.worker.database.windows.net,11140
12/5/2019 9:18:16 AM - error: Column names in each table must be unique. Column name 'AreaNoindex' in table 'Area' is specified more than once. - System.Data.SqlClient.SqlException (0x80131904): Column names in each table must be unique. Column name 'AreaNoindex' in table 'Area' is specified more than once.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Dynamicweb.Frontend.Update.ProcessDatabase(XmlNode& xmlNode)
ClientConnectionId:fa7cd4a8-8870-4dd3-9ec3-f2cd5b43f244
Error Number:2705,State:4,Class:16
ClientConnectionId before routing:f8f4dff3-fc93-4423-b05c-ffa1963612a3
Routing Destination:b307131aedd0.tr21.westeurope1-a.worker.database.windows.net,11140
12/5/2019 9:18:16 AM Package 2116 from updates.xml.aspx
12/5/2019 9:18:16 AM Conditional present - escaping.
12/5/2019 9:18:16 AM Package 2117 from updates.xml.aspx
12/5/2019 9:18:16 AM Standard SQL applied.
WITH duplicateNonBrowserSessions AS (
SELECT
SessionId,
SessionSessionId,
ROW_NUMBER() OVER (
PARTITION BY
SessionSessionId
ORDER BY
SessionSessionId
) row_num
FROM NonBrowserSession
) DELETE FROM NonBrowserSession WHERE SessionId IN (SELECT SessionId FROM duplicateNonBrowserSessions WHERE row_num > 1)
12/5/2019 9:18:16 AM Package 2118 from updates.xml.aspx
12/5/2019 9:18:16 AM Conditional present - escaping.
12/5/2019 9:18:16 AM Package 2119 from updates.xml.aspx
12/5/2019 9:18:16 AM Conditional present - escaping.
12/5/2019 9:18:16 AM Updates initialized
12/5/2019 9:18:16 AM Package 2128 from ecom.xml.aspx
12/5/2019 9:18:16 AM - error: Column names in each table must be unique. Column name 'ShippingUserGroups' in table 'EcomShippings' is specified more than once. - System.Data.SqlClient.SqlException (0x80131904): Column names in each table must be unique. Column name 'ShippingUserGroups' in table 'EcomShippings' is specified more than once.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Dynamicweb.Frontend.Update.ProcessDatabase(XmlNode& xmlNode)
ClientConnectionId:fa7cd4a8-8870-4dd3-9ec3-f2cd5b43f244
Error Number:2705,State:4,Class:16
ClientConnectionId before routing:f8f4dff3-fc93-4423-b05c-ffa1963612a3
Routing Destination:b307131aedd0.tr21.westeurope1-a.worker.database.windows.net,11140
12/5/2019 9:18:16 AM Package 2129 from ecom.xml.aspx
12/5/2019 9:18:16 AM Conditional present - escaping.
12/5/2019 9:18:16 AM Package 2130 from ecom.xml.aspx
12/5/2019 9:18:16 AM - error: Column names in each table must be unique. Column name 'GroupFacetRelationOrder' in table 'EcomGroupFacetRelation' is specified more than once. - System.Data.SqlClient.SqlException (0x80131904): Column names in each table must be unique. Column name 'GroupFacetRelationOrder' in table 'EcomGroupFacetRelation' is specified more than once.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Dynamicweb.Frontend.Update.ProcessDatabase(XmlNode& xmlNode)
ClientConnectionId:fa7cd4a8-8870-4dd3-9ec3-f2cd5b43f244
Error Number:2705,State:4,Class:16
ClientConnectionId before routing:f8f4dff3-fc93-4423-b05c-ffa1963612a3
Routing Destination:b307131aedd0.tr21.westeurope1-a.worker.database.windows.net,11140
12/5/2019 9:18:16 AM Package 2131 from ecom.xml.aspx
12/5/2019 9:18:16 AM Conditional present - escaping.
12/5/2019 9:18:16 AM Standard SQL applied.
ALTER TABLE [EcomGroupFacetRelation] ALTER COLUMN [GroupFacetRelationFacetField] [nvarchar](255) NULL;
ALTER TABLE [EcomGroupFacetRelation] ALTER COLUMN [GroupFacetRelationQueryParameter] [nvarchar](100) NULL;
12/5/2019 9:18:16 AM Package 2132 from ecom.xml.aspx
12/5/2019 9:18:16 AM Standard SQL applied.
UPDATE [EcomShippings] SET [ShippingActive] = 1 WHERE [ShippingActive] IS NULL
12/5/2019 9:18:16 AM Package 2133 from ecom.xml.aspx
12/5/2019 9:18:16 AM Conditional present - escaping.
12/5/2019 9:18:16 AM Package 2134 from ecom.xml.aspx
12/5/2019 9:18:16 AM Folder D:\home\site\wwwroot\Dynamicweb\Solution\Templates\eCom7\CheckoutHandler\DibsEasy\Form does not exist - creating.
12/5/2019 9:18:16 AM file D:\home\site\wwwroot\Dynamicweb\Applications\Application(9.7.4)\Admin\Update\\Files\Templates\eCom7\CheckoutHandler\DibsEasy\Form\EmbededDibs.cshtml added.
12/5/2019 9:18:16 AM Folder D:\home\site\wwwroot\Dynamicweb\Solution\Templates\eCom7\CheckoutHandler\DibsEasy\Error does not exist - creating.
12/5/2019 9:18:16 AM file D:\home\site\wwwroot\Dynamicweb\Applications\Application(9.7.4)\Admin\Update\\Files\Templates\eCom7\CheckoutHandler\DibsEasy\Error\checkouthandler_error.cshtml added.
12/5/2019 9:18:16 AM Package 2135 from ecom.xml.aspx
12/5/2019 9:18:16 AM Conditional present - escaping.
12/5/2019 9:18:16 AM Conditional present - escaping.
12/5/2019 9:18:16 AM Standard SQL applied.
IF EXISTS( SELECT 'Enterprise' AS EngineEdition WHERE SERVERPROPERTY('EngineEdition') = 3 )
BEGIN
IF NOT EXISTS(SELECT object_id FROM sys.indexes WHERE name = 'IX_EcomAssortmentItems_AutoID')
CREATE UNIQUE CLUSTERED INDEX IX_EcomAssortmentItems_AutoID
ON EcomAssortmentItems ( AssortmentItemAutoID ASC )
WITH ( PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = ON );
IF NOT EXISTS(SELECT object_id FROM sys.indexes WHERE name = 'IX_EcomAssortmentItems_AssortmentID')
CREATE NONCLUSTERED INDEX IX_EcomAssortmentItems_AssortmentID
ON EcomAssortmentItems ( AssortmentItemAssortmentID ASC )
INCLUDE ( AssortmentItemAutoID )
WITH ( PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = ON );
IF NOT EXISTS(SELECT object_id FROM sys.indexes WHERE name = 'IX_EcomAssortmentItems_RelationType_RelationAutoID')
CREATE NONCLUSTERED INDEX IX_EcomAssortmentItems_RelationType_RelationAutoID
ON EcomAssortmentItems ( AssortmentItemRelationType ASC, AssortmentItemRelationAutoID ASC )
INCLUDE ( AssortmentItemAutoID )
WITH ( PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = ON );
IF NOT EXISTS(SELECT object_id FROM sys.indexes WHERE name = 'IX_EcomAssortmentItems_LanguageID_ProductID_ProductVariantID')
CREATE NONCLUSTERED INDEX IX_EcomAssortmentItems_LanguageID_ProductID_ProductVariantID
ON EcomAssortmentItems ( AssortmentItemLanguageID ASC, AssortmentItemProductID ASC, AssortmentItemProductVariantID ASC )
INCLUDE ( AssortmentItemAutoID )
WITH ( PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = ON );
END
12/5/2019 9:18:16 AM Standard SQL applied.
IF NOT EXISTS( SELECT 'Enterprise' AS EngineEdition WHERE SERVERPROPERTY('EngineEdition') = 3 )
BEGIN
IF NOT EXISTS(SELECT object_id FROM sys.indexes WHERE name = 'IX_EcomAssortmentItems_AutoID')
CREATE UNIQUE CLUSTERED INDEX IX_EcomAssortmentItems_AutoID
ON EcomAssortmentItems ( AssortmentItemAutoID ASC )
WITH ( PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF );
IF NOT EXISTS(SELECT object_id FROM sys.indexes WHERE name = 'IX_EcomAssortmentItems_AssortmentID')
CREATE NONCLUSTERED INDEX IX_EcomAssortmentItems_AssortmentID
ON EcomAssortmentItems ( AssortmentItemAssortmentID ASC )
INCLUDE ( AssortmentItemAutoID )
WITH ( PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF );
IF NOT EXISTS(SELECT object_id FROM sys.indexes WHERE name = 'IX_EcomAssortmentItems_RelationType_RelationAutoID')
CREATE NONCLUSTERED INDEX IX_EcomAssortmentItems_RelationType_RelationAutoID
ON EcomAssortmentItems ( AssortmentItemRelationType ASC, AssortmentItemRelationAutoID ASC )
INCLUDE ( AssortmentItemAutoID )
WITH ( PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF );
IF NOT EXISTS(SELECT object_id FROM sys.indexes WHERE name = 'IX_EcomAssortmentItems_LanguageID_ProductID_ProductVariantID')
CREATE NONCLUSTERED INDEX IX_EcomAssortmentItems_LanguageID_ProductID_ProductVariantID
ON EcomAssortmentItems ( AssortmentItemLanguageID ASC, AssortmentItemProductID ASC, AssortmentItemProductVariantID ASC )
INCLUDE ( AssortmentItemAutoID )
WITH ( PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF );
END
12/5/2019 9:18:16 AM Package 2136 from ecom.xml.aspx
12/5/2019 9:18:16 AM Conditional present - escaping.
2/10/2020 8:58:01 PM Updates initialized
2/10/2020 8:58:01 PM Package 2114 from updates.xml.aspx
2/10/2020 8:58:01 PM Package 2115 from updates.xml.aspx
2/10/2020 8:58:01 PM - error: Column names in each table must be unique. Column name 'AreaNofollow' in table 'Area' is specified more than once. - System.Data.SqlClient.SqlException (0x80131904): Column names in each table must be unique. Column name 'AreaNofollow' in table 'Area' is specified more than once.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Dynamicweb.Frontend.Update.ProcessDatabase(XmlNode& xmlNode)
ClientConnectionId:4d9cc003-9d91-4add-836f-a6b751369e74
Error Number:2705,State:4,Class:16
ClientConnectionId before routing:e4b487ce-2ec9-432f-9f31-d41905390903
Routing Destination:b307131aedd0.tr21.westeurope1-a.worker.database.windows.net,11101
2/10/2020 8:58:01 PM - error: Column names in each table must be unique. Column name 'AreaNoindex' in table 'Area' is specified more than once. - System.Data.SqlClient.SqlException (0x80131904): Column names in each table must be unique. Column name 'AreaNoindex' in table 'Area' is specified more than once.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Dynamicweb.Frontend.Update.ProcessDatabase(XmlNode& xmlNode)
ClientConnectionId:4d9cc003-9d91-4add-836f-a6b751369e74
Error Number:2705,State:4,Class:16
ClientConnectionId before routing:e4b487ce-2ec9-432f-9f31-d41905390903
Routing Destination:b307131aedd0.tr21.westeurope1-a.worker.database.windows.net,11101
2/10/2020 8:58:01 PM Package 2116 from updates.xml.aspx
2/10/2020 8:58:01 PM Conditional present - escaping.
2/10/2020 8:58:01 PM Conditional present - escaping.
2/10/2020 8:58:01 PM Package 2117 from updates.xml.aspx
2/10/2020 8:58:01 PM Conditional present - escaping.
2/10/2020 8:58:01 PM Conditional present - escaping.
2/10/2020 8:58:01 PM Conditional present - escaping.
2/10/2020 8:58:01 PM Conditional present - escaping.
2/10/2020 8:58:01 PM Package 2118 from updates.xml.aspx
2/10/2020 8:58:01 PM Conditional present - escaping.
2/10/2020 8:58:01 PM Package 2119 from updates.xml.aspx
2/10/2020 8:58:01 PM Package 2120 from updates.xml.aspx
2/10/2020 8:58:01 PM Conditional present - escaping.
2/10/2020 8:58:01 PM Package 2121 from updates.xml.aspx
2/10/2020 8:58:01 PM file D:\home\site\wwwroot\Dynamicweb\Solution\System\OMC\Marketing reports\Visits\Acquisition\Visitors - Campaign.xml already exists.
2/10/2020 8:58:01 PM file D:\home\site\wwwroot\Dynamicweb\Solution\System\OMC\Marketing reports\Visits\Acquisition\Visitors - Referrer type.xml already exists.
2/10/2020 8:58:01 PM file D:\home\site\wwwroot\Dynamicweb\Solution\System\OMC\Marketing reports\Visits\Acquisition\Visitors - Referrer.xml already exists.
2/10/2020 8:58:01 PM file D:\home\site\wwwroot\Dynamicweb\Solution\System\OMC\Marketing reports\Visits\Behavior\Visitors - New vs Returning.xml already exists.
2/10/2020 8:58:01 PM file D:\home\site\wwwroot\Dynamicweb\Solution\System\OMC\Marketing reports\Visits\Geo\Visitors - Country.xml already exists.
2/10/2020 8:58:01 PM file D:\home\site\wwwroot\Dynamicweb\Solution\System\OMC\Marketing reports\Visits\Technology\Visitors - Device.xml already exists.
2/10/2020 8:58:01 PM file D:\home\site\wwwroot\Dynamicweb\Solution\System\OMC\Marketing reports\Visits\Overview\Visitors - Day.xml already exists.
2/10/2020 8:58:01 PM file D:\home\site\wwwroot\Dynamicweb\Solution\System\OMC\Marketing reports\Visits\Overview\Visitors - Time of day.xml already exists.
2/10/2020 8:58:01 PM file D:\home\site\wwwroot\Dynamicweb\Solution\System\OMC\Marketing reports\Visits\Overview\Visitors - Website.xml already exists.
2/10/2020 8:58:01 PM file D:\home\site\wwwroot\Dynamicweb\Solution\System\OMC\Marketing reports\Visits\Overview\Visitors - Year.xml already exists.
2/10/2020 8:58:01 PM Package 2122 from updates.xml.aspx
2/10/2020 8:58:01 PM Conditional present - escaping.
2/10/2020 8:58:01 PM Conditional present - escaping.
2/10/2020 8:58:01 PM Conditional present - escaping.
2/10/2020 8:58:01 PM Conditional present - escaping.
2/10/2020 8:58:01 PM Conditional present - escaping.
2/10/2020 8:58:01 PM Conditional present - escaping.
2/10/2020 8:58:01 PM Conditional present - escaping.
2/10/2020 8:58:01 PM Package 2123 from updates.xml.aspx
2/10/2020 8:58:01 PM Conditional present - escaping.
2/10/2020 8:58:01 PM Package 2124 from updates.xml.aspx
2/10/2020 8:58:01 PM Conditional present - escaping.
2/10/2020 8:58:01 PM Package 2125 from updates.xml.aspx
2/10/2020 8:58:01 PM Conditional present - escaping.
2/10/2020 8:58:01 PM Conditional present - escaping.
2/10/2020 8:58:01 PM Package 2126 from updates.xml.aspx
2/10/2020 8:58:01 PM Conditional present - escaping.
2/10/2020 8:58:01 PM Package 2127 from updates.xml.aspx
2/10/2020 8:58:01 PM file D:\home\site\wwwroot\Dynamicweb\Solution\System\OMC\Marketing reports\Visits\Behavior\Visitors - Most viewed pages.xml already exists.
2/10/2020 8:58:01 PM Package 2128 from updates.xml.aspx
2/10/2020 8:58:01 PM Conditional present - escaping.
2/10/2020 8:58:01 PM Conditional present - escaping.
2/10/2020 8:58:01 PM Conditional present - escaping.
2/10/2020 8:58:01 PM Package 2129 from updates.xml.aspx
2/10/2020 8:58:01 PM Conditional present - escaping.
2/10/2020 8:58:01 PM Conditional present - escaping.
2/10/2020 8:58:01 PM Package 2130 from updates.xml.aspx
2/10/2020 8:58:01 PM Conditional present - escaping.
2/10/2020 8:58:01 PM Package 2131 from updates.xml.aspx
2/10/2020 8:58:01 PM Conditional present - escaping.
2/10/2020 8:58:01 PM Package 2132 from updates.xml.aspx
2/10/2020 8:58:01 PM Conditional present - escaping.
2/10/2020 8:58:01 PM Conditional present - escaping.
2/10/2020 8:58:01 PM Conditional present - escaping.
2/10/2020 8:58:01 PM Conditional present - escaping.
2/10/2020 8:58:01 PM Package 2133 from updates.xml.aspx
2/10/2020 8:58:01 PM Conditional present - escaping.
2/10/2020 8:58:01 PM Updates initialized
2/10/2020 8:58:01 PM Package 2131 from ecom.xml.aspx
2/10/2020 8:58:01 PM Conditional present - escaping.
2/10/2020 8:58:02 PM Standard SQL applied.
ALTER TABLE [EcomGroupFacetRelation] ALTER COLUMN [GroupFacetRelationFacetField] [nvarchar](255) NULL;
ALTER TABLE [EcomGroupFacetRelation] ALTER COLUMN [GroupFacetRelationQueryParameter] [nvarchar](100) NULL;
2/10/2020 8:58:02 PM Package 2132 from ecom.xml.aspx
2/10/2020 8:58:02 PM Package 2133 from ecom.xml.aspx
2/10/2020 8:58:02 PM Conditional empty - Standard SQL applied.
ALTER TABLE [EcomGroups] ADD [GroupCompletionRules] NVARCHAR(MAX) NULL
2/10/2020 8:58:02 PM Conditional empty - Standard SQL applied.
ALTER TABLE [EcomGroups] ADD [GroupCompletionLanguageIds] NVARCHAR(MAX) NULL
2/10/2020 8:58:02 PM Package 2134 from ecom.xml.aspx
2/10/2020 8:58:02 PM Standard SQL applied.
UPDATE [EcomShippings] SET [ShippingActive] = 1 WHERE [ShippingActive] IS NULL
2/10/2020 8:58:02 PM Package 2135 from ecom.xml.aspx
2/10/2020 8:58:04 PM Package 2136 from ecom.xml.aspx
2/10/2020 8:58:04 PM Standard SQL applied.
ALTER TABLE [EcomCustomerFavoriteLists] ADD [IsShared] BIT NOT NULL DEFAULT 0
2/10/2020 8:58:04 PM Package 2137 from ecom.xml.aspx
2/10/2020 8:58:04 PM Folder D:\home\site\wwwroot\Dynamicweb\Solution\Templates\eCom\CustomerCenter does not exist - creating.
2/10/2020 8:58:04 PM file D:\home\site\wwwroot\Dynamicweb\Applications\Application(9.8.0)\Admin\Update\\Files\Templates\eCom\CustomerCenter\CartList.html added.
2/10/2020 8:58:04 PM Folder D:\home\site\wwwroot\Dynamicweb\Solution\Templates\eCom\CustomerCenter does not exist - creating.
2/10/2020 8:58:04 PM file D:\home\site\wwwroot\Dynamicweb\Applications\Application(9.8.0)\Admin\Update\\Files\Templates\eCom\CustomerCenter\CartDetail.html added.
2/10/2020 8:58:04 PM Package 2138 from ecom.xml.aspx
2/10/2020 8:58:05 PM Setting /Globalsettings/Ecom/Product/Details/Extensions has received a value "jpg,jpeg,png,bmp,tiff,pdf,docx,xlsx,ppt,avi".
2/10/2020 8:58:05 PM Standard SQL applied.
ALTER TABLE [EcomDetailsGroup] ADD [DetailsGroupExtensions] [NVARCHAR](255) NULL;
ALTER TABLE [EcomDetailsGroup] ADD [DetailsGroupControlType] [INT] NULL;
2/10/2020 8:58:05 PM Package 2139 from ecom.xml.aspx
2/10/2020 8:58:05 PM Standard SQL applied.
ALTER TABLE [EcomProducts] ADD [ProductPurchaseMinimumQuantity] [FLOAT] NULL;
ALTER TABLE [EcomProducts] ADD [ProductPurchaseQuantityStep] [FLOAT] NULL;
2/10/2020 8:58:05 PM Package 2140 from ecom.xml.aspx
2/10/2020 8:58:05 PM Conditional present - escaping.
2/10/2020 8:58:05 PM Package 2141 from ecom.xml.aspx
2/10/2020 8:58:05 PM Standard SQL applied.
ALTER TABLE [EcomPayments] ADD
[PaymentUserGroups] NVARCHAR(MAX) NULL,
[PaymentAllowAnonymousUsers] BIT NOT NULL DEFAULT 0
2/10/2020 8:58:05 PM Package 2142 from ecom.xml.aspx
2/10/2020 8:58:05 PM Standard SQL applied.
ALTER TABLE [EcomDiscountTranslation] ADD
[DiscountTranslationDescription] NVARCHAR(MAX) NULL,
[DiscountTranslationCampaignName] NVARCHAR(255) NULL
2/10/2020 8:58:05 PM Package 2143 from ecom.xml.aspx
2/10/2020 8:58:05 PM file D:\home\site\wwwroot\Dynamicweb\Solution\Templates\eCom7\CheckoutHandler\DibsEasy\Form\EmbededDibs.cshtml already exists.
2/10/2020 8:58:05 PM file D:\home\site\wwwroot\Dynamicweb\Solution\Templates\eCom7\CheckoutHandler\DibsEasy\Error\checkouthandler_error.cshtml already exists.
2/10/2020 8:58:05 PM Package 2144 from ecom.xml.aspx
2/10/2020 8:58:05 PM Conditional present - escaping.
2/10/2020 8:58:05 PM Conditional present - escaping.
2/10/2020 8:58:05 PM Standard SQL applied.
IF EXISTS( SELECT 'Enterprise' AS EngineEdition WHERE SERVERPROPERTY('EngineEdition') = 3 )
BEGIN
IF NOT EXISTS(SELECT object_id FROM sys.indexes WHERE name = 'IX_EcomAssortmentItems_AutoID')
CREATE UNIQUE CLUSTERED INDEX IX_EcomAssortmentItems_AutoID
ON EcomAssortmentItems ( AssortmentItemAutoID ASC )
WITH ( PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = ON );
IF NOT EXISTS(SELECT object_id FROM sys.indexes WHERE name = 'IX_EcomAssortmentItems_AssortmentID')
CREATE NONCLUSTERED INDEX IX_EcomAssortmentItems_AssortmentID
ON EcomAssortmentItems ( AssortmentItemAssortmentID ASC )
INCLUDE ( AssortmentItemAutoID )
WITH ( PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = ON );
IF NOT EXISTS(SELECT object_id FROM sys.indexes WHERE name = 'IX_EcomAssortmentItems_RelationType_RelationAutoID')
CREATE NONCLUSTERED INDEX IX_EcomAssortmentItems_RelationType_RelationAutoID
ON EcomAssortmentItems ( AssortmentItemRelationType ASC, AssortmentItemRelationAutoID ASC )
INCLUDE ( AssortmentItemAutoID )
WITH ( PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = ON );
IF NOT EXISTS(SELECT object_id FROM sys.indexes WHERE name = 'IX_EcomAssortmentItems_LanguageID_ProductID_ProductVariantID')
CREATE NONCLUSTERED INDEX IX_EcomAssortmentItems_LanguageID_ProductID_ProductVariantID
ON EcomAssortmentItems ( AssortmentItemLanguageID ASC, AssortmentItemProductID ASC, AssortmentItemProductVariantID ASC )
INCLUDE ( AssortmentItemAutoID )
WITH ( PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = ON );
END
2/10/2020 8:58:05 PM Standard SQL applied.
IF NOT EXISTS( SELECT 'Enterprise' AS EngineEdition WHERE SERVERPROPERTY('EngineEdition') = 3 )
BEGIN
IF NOT EXISTS(SELECT object_id FROM sys.indexes WHERE name = 'IX_EcomAssortmentItems_AutoID')
CREATE UNIQUE CLUSTERED INDEX IX_EcomAssortmentItems_AutoID
ON EcomAssortmentItems ( AssortmentItemAutoID ASC )
WITH ( PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF );
IF NOT EXISTS(SELECT object_id FROM sys.indexes WHERE name = 'IX_EcomAssortmentItems_AssortmentID')
CREATE NONCLUSTERED INDEX IX_EcomAssortmentItems_AssortmentID
ON EcomAssortmentItems ( AssortmentItemAssortmentID ASC )
INCLUDE ( AssortmentItemAutoID )
WITH ( PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF );
IF NOT EXISTS(SELECT object_id FROM sys.indexes WHERE name = 'IX_EcomAssortmentItems_RelationType_RelationAutoID')
CREATE NONCLUSTERED INDEX IX_EcomAssortmentItems_RelationType_RelationAutoID
ON EcomAssortmentItems ( AssortmentItemRelationType ASC, AssortmentItemRelationAutoID ASC )
INCLUDE ( AssortmentItemAutoID )
WITH ( PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF );
IF NOT EXISTS(SELECT object_id FROM sys.indexes WHERE name = 'IX_EcomAssortmentItems_LanguageID_ProductID_ProductVariantID')
CREATE NONCLUSTERED INDEX IX_EcomAssortmentItems_LanguageID_ProductID_ProductVariantID
ON EcomAssortmentItems ( AssortmentItemLanguageID ASC, AssortmentItemProductID ASC, AssortmentItemProductVariantID ASC )
INCLUDE ( AssortmentItemAutoID )
WITH ( PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF );
END
2/10/2020 8:58:05 PM Package 2145 from ecom.xml.aspx
2/10/2020 8:58:05 PM Folder D:\home\site\wwwroot\Dynamicweb\Solution\Templates\Feeds does not exist - creating.
2/10/2020 8:58:05 PM file D:\home\site\wwwroot\Dynamicweb\Applications\Application(9.8.0)\Admin\Update\\Files\Templates\Feeds\channable_products_transformer.xslt added.
2/10/2020 8:58:05 PM Folder D:\home\site\wwwroot\Dynamicweb\Solution\System\Integration does not exist - creating.
2/10/2020 8:58:05 PM file D:\home\site\wwwroot\Dynamicweb\Applications\Application(9.8.0)\Admin\Update\\Files\System\Integration\ChannableFeedSetUp.xml added.
2/10/2020 8:58:05 PM Folder D:\home\site\wwwroot\Dynamicweb\Solution\System\Integration\Jobs does not exist - creating.
2/10/2020 8:58:05 PM file D:\home\site\wwwroot\Dynamicweb\Applications\Application(9.8.0)\Admin\Update\\Files\System\Integration\Jobs\ChannableFeedQuickSetup.xml added.
2/10/2020 8:58:06 PM Setting /Globalsettings/Ecom/Required/ProductCategories/ChannableFieds.Brand has received a value "True".
2/10/2020 8:58:06 PM Setting /Globalsettings/Ecom/Required/ProductCategories/ChannableFieds.Ean has received a value "True".
2/10/2020 8:58:06 PM Package 2146 from ecom.xml.aspx
2/10/2020 8:58:06 PM Package 2147 from ecom.xml.aspx
2/10/2020 8:58:06 PM Conditional present - escaping.
2/10/2020 8:58:06 PM Package 2148 from ecom.xml.aspx
2/10/2020 8:58:06 PM Conditional empty - Standard SQL applied.
ALTER TABLE [EcomOrders] ADD [OrderVATCountryCode] NVARCHAR(50) NULL;
2/10/2020 8:58:06 PM Package 2149 from ecom.xml.aspx
2/10/2020 8:58:06 PM Conditional present - escaping.
2/10/2020 8:58:06 PM Package 2150 from ecom.xml.aspx
2/10/2020 8:58:06 PM Folder D:\home\site\wwwroot\Dynamicweb\Solution\System\Integration\OpenCatalog\IceCat does not exist - creating.
2/10/2020 8:58:06 PM file D:\home\site\wwwroot\Dynamicweb\Applications\Application(9.8.0)\Admin\Update\\Files\System\Integration\OpenCatalog\IceCat\\icecatProducts.xslt added.
2/10/2020 8:58:06 PM Package 2151 from ecom.xml.aspx
2/10/2020 8:58:06 PM Conditional empty - Standard SQL applied.
INSERT INTO [EcomTree] ([Parentid], [Text], [TreeIcon], [TreeUrl], [TreeChildPopulate], [TreeSort], [TreeHasAccessModuleSystemName])
VALUES (1, N'Carts', N'/Admin/Module/eCom_Catalog/dw7/images/buttons/shoppingcart.png', N'Lists/EcomList.aspx?type=CART', 'CARTS', 5, 'eCom_Catalog');
2/10/2020 8:58:06 PM Package 2152 from ecom.xml.aspx
2/10/2020 8:58:06 PM Folder D:\home\site\wwwroot\Dynamicweb\Solution\Templates\eCom7\CheckoutHandler\ErrorTemplate does not exist - creating.
2/10/2020 8:58:06 PM file D:\home\site\wwwroot\Dynamicweb\Applications\Application(9.8.0)\Admin\Update\\Files\Templates\eCom7\CheckoutHandler\ErrorTemplate\checkouthandler_error.cshtml added.
2/10/2020 8:58:06 PM Package 2153 from ecom.xml.aspx
2/10/2020 8:58:06 PM Conditional empty - Standard SQL applied.
INSERT INTO [Ecom7Tree] ([ParentId], [Text], [Alt], [TreeIcon], [TreeIconOpen], [TreeUrl], [TreeChildPopulate], [TreeSort], [TreeHasAccessModuleSystemName])
VALUES(92, N'Cart flows', NULL, N'/Admin/Module/eCom_Catalog/images/buttons/shoppingcart.png', NULL, N'Lists/EcomOrderFlow_List.aspx?OrderType=cart', N'CARTSFLOW', 71, N'eCom_CartV2')
2/10/2020 9:32:46 PM Updates initialized
2/10/2020 9:32:46 PM Updates initialized
4/28/2020 7:19:03 AM Updates initialized
4/28/2020 7:19:03 AM Package 2114 from updates.xml.aspx
4/28/2020 7:19:03 AM Package 2115 from updates.xml.aspx
4/28/2020 7:19:03 AM - error: Column names in each table must be unique. Column name 'AreaNofollow' in table 'Area' is specified more than once. - System.Data.SqlClient.SqlException (0x80131904): Column names in each table must be unique. Column name 'AreaNofollow' in table 'Area' is specified more than once.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Dynamicweb.Frontend.Update.ProcessDatabase(XmlNode& xmlNode)
ClientConnectionId:6051bb4a-54eb-4c9c-b90e-dddc275dde1c
Error Number:2705,State:4,Class:16
ClientConnectionId before routing:ce43fa98-bf41-43c4-b328-cba7b7815a6b
Routing Destination:ea107b5d8e20.tr2065.northeurope1-a.worker.database.windows.net,11103
4/28/2020 7:19:03 AM - error: Column names in each table must be unique. Column name 'AreaNoindex' in table 'Area' is specified more than once. - System.Data.SqlClient.SqlException (0x80131904): Column names in each table must be unique. Column name 'AreaNoindex' in table 'Area' is specified more than once.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Dynamicweb.Frontend.Update.ProcessDatabase(XmlNode& xmlNode)
ClientConnectionId:6051bb4a-54eb-4c9c-b90e-dddc275dde1c
Error Number:2705,State:4,Class:16
ClientConnectionId before routing:ce43fa98-bf41-43c4-b328-cba7b7815a6b
Routing Destination:ea107b5d8e20.tr2065.northeurope1-a.worker.database.windows.net,11103
4/28/2020 7:19:03 AM Package 2116 from updates.xml.aspx
4/28/2020 7:19:03 AM Conditional present - escaping.
4/28/2020 7:19:03 AM Conditional present - escaping.
4/28/2020 7:19:03 AM Package 2117 from updates.xml.aspx
4/28/2020 7:19:03 AM Conditional present - escaping.
4/28/2020 7:19:03 AM Conditional present - escaping.
4/28/2020 7:19:03 AM Conditional present - escaping.
4/28/2020 7:19:03 AM Conditional present - escaping.
4/28/2020 7:19:03 AM Package 2118 from updates.xml.aspx
4/28/2020 7:19:03 AM Conditional present - escaping.
4/28/2020 7:19:03 AM Package 2119 from updates.xml.aspx
4/28/2020 7:19:03 AM Package 2120 from updates.xml.aspx
4/28/2020 7:19:03 AM Conditional present - escaping.
4/28/2020 7:19:03 AM Package 2121 from updates.xml.aspx
4/28/2020 7:19:03 AM file D:\home\site\wwwroot\Dynamicweb\Solution\System\OMC\Marketing reports\Visits\Acquisition\Visitors - Campaign.xml already exists.
4/28/2020 7:19:03 AM file D:\home\site\wwwroot\Dynamicweb\Solution\System\OMC\Marketing reports\Visits\Acquisition\Visitors - Referrer type.xml already exists.
4/28/2020 7:19:03 AM file D:\home\site\wwwroot\Dynamicweb\Solution\System\OMC\Marketing reports\Visits\Acquisition\Visitors - Referrer.xml already exists.
4/28/2020 7:19:03 AM file D:\home\site\wwwroot\Dynamicweb\Solution\System\OMC\Marketing reports\Visits\Behavior\Visitors - New vs Returning.xml already exists.
4/28/2020 7:19:03 AM file D:\home\site\wwwroot\Dynamicweb\Solution\System\OMC\Marketing reports\Visits\Geo\Visitors - Country.xml already exists.
4/28/2020 7:19:03 AM file D:\home\site\wwwroot\Dynamicweb\Solution\System\OMC\Marketing reports\Visits\Technology\Visitors - Device.xml already exists.
4/28/2020 7:19:03 AM file D:\home\site\wwwroot\Dynamicweb\Solution\System\OMC\Marketing reports\Visits\Overview\Visitors - Day.xml already exists.
4/28/2020 7:19:03 AM file D:\home\site\wwwroot\Dynamicweb\Solution\System\OMC\Marketing reports\Visits\Overview\Visitors - Time of day.xml already exists.
4/28/2020 7:19:03 AM file D:\home\site\wwwroot\Dynamicweb\Solution\System\OMC\Marketing reports\Visits\Overview\Visitors - Website.xml already exists.
4/28/2020 7:19:03 AM file D:\home\site\wwwroot\Dynamicweb\Solution\System\OMC\Marketing reports\Visits\Overview\Visitors - Year.xml already exists.
4/28/2020 7:19:03 AM Package 2122 from updates.xml.aspx
4/28/2020 7:19:03 AM Conditional present - escaping.
4/28/2020 7:19:03 AM Conditional present - escaping.
4/28/2020 7:19:03 AM Conditional present - escaping.
4/28/2020 7:19:03 AM Conditional present - escaping.
4/28/2020 7:19:03 AM Conditional present - escaping.
4/28/2020 7:19:04 AM Conditional present - escaping.
4/28/2020 7:19:04 AM Conditional present - escaping.
4/28/2020 7:19:04 AM Package 2123 from updates.xml.aspx
4/28/2020 7:19:04 AM Conditional present - escaping.
4/28/2020 7:19:04 AM Package 2124 from updates.xml.aspx
4/28/2020 7:19:04 AM Conditional present - escaping.
4/28/2020 7:19:04 AM Package 2125 from updates.xml.aspx
4/28/2020 7:19:04 AM Conditional present - escaping.
4/28/2020 7:19:04 AM Conditional present - escaping.
4/28/2020 7:19:04 AM Package 2126 from updates.xml.aspx
4/28/2020 7:19:04 AM Conditional present - escaping.
4/28/2020 7:19:04 AM Package 2127 from updates.xml.aspx
4/28/2020 7:19:04 AM file D:\home\site\wwwroot\Dynamicweb\Solution\System\OMC\Marketing reports\Visits\Behavior\Visitors - Most viewed pages.xml already exists.
4/28/2020 7:19:04 AM Package 2128 from updates.xml.aspx
4/28/2020 7:19:04 AM Conditional present - escaping.
4/28/2020 7:19:04 AM Conditional present - escaping.
4/28/2020 7:19:04 AM Conditional present - escaping.
4/28/2020 7:19:04 AM Package 2129 from updates.xml.aspx
4/28/2020 7:19:04 AM Conditional present - escaping.
4/28/2020 7:19:04 AM Conditional present - escaping.
4/28/2020 7:19:04 AM Package 2130 from updates.xml.aspx
4/28/2020 7:19:04 AM Conditional present - escaping.
4/28/2020 7:19:04 AM Package 2131 from updates.xml.aspx
4/28/2020 7:19:04 AM Conditional present - escaping.
4/28/2020 7:19:04 AM Package 2132 from updates.xml.aspx
4/28/2020 7:19:04 AM Conditional present - escaping.
4/28/2020 7:19:04 AM Conditional present - escaping.
4/28/2020 7:19:04 AM Conditional present - escaping.
4/28/2020 7:19:04 AM Conditional present - escaping.
4/28/2020 7:19:04 AM Package 2133 from updates.xml.aspx
4/28/2020 7:19:04 AM Conditional present - escaping.
4/28/2020 7:19:04 AM Package 2134 from updates.xml.aspx
4/28/2020 7:19:04 AM file D:\home\site\wwwroot\Dynamicweb\Solution\Templates\CookieWarning\ModalDialogWarning_Categories.cshtml already exists.
4/28/2020 7:19:05 AM Updates initialized
4/28/2020 7:19:05 AM Package 2131 from ecom.xml.aspx
4/28/2020 7:19:05 AM Conditional present - escaping.
4/28/2020 7:19:05 AM Standard SQL applied.
ALTER TABLE [EcomGroupFacetRelation] ALTER COLUMN [GroupFacetRelationFacetField] [nvarchar](255) NULL;
ALTER TABLE [EcomGroupFacetRelation] ALTER COLUMN [GroupFacetRelationQueryParameter] [nvarchar](100) NULL;
4/28/2020 7:19:05 AM Package 2132 from ecom.xml.aspx
4/28/2020 7:19:05 AM Package 2133 from ecom.xml.aspx
4/28/2020 7:19:05 AM Conditional present - escaping.
4/28/2020 7:19:05 AM Conditional present - escaping.
4/28/2020 7:19:05 AM Package 2134 from ecom.xml.aspx
4/28/2020 7:19:05 AM Standard SQL applied.
UPDATE [EcomShippings] SET [ShippingActive] = 1 WHERE [ShippingActive] IS NULL
4/28/2020 7:19:05 AM Package 2135 from ecom.xml.aspx
4/28/2020 7:19:10 AM Package 2136 from ecom.xml.aspx
4/28/2020 7:19:10 AM - error: Column names in each table must be unique. Column name 'IsShared' in table 'EcomCustomerFavoriteLists' is specified more than once. - System.Data.SqlClient.SqlException (0x80131904): Column names in each table must be unique. Column name 'IsShared' in table 'EcomCustomerFavoriteLists' is specified more than once.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Dynamicweb.Frontend.Update.ProcessDatabase(XmlNode& xmlNode)
ClientConnectionId:6051bb4a-54eb-4c9c-b90e-dddc275dde1c
Error Number:2705,State:4,Class:16
ClientConnectionId before routing:ce43fa98-bf41-43c4-b328-cba7b7815a6b
Routing Destination:ea107b5d8e20.tr2065.northeurope1-a.worker.database.windows.net,11103
4/28/2020 7:19:10 AM Package 2137 from ecom.xml.aspx
4/28/2020 7:19:10 AM file D:\home\site\wwwroot\Dynamicweb\Solution\Templates\eCom\CustomerCenter\CartList.html already exists.
4/28/2020 7:19:10 AM file D:\home\site\wwwroot\Dynamicweb\Solution\Templates\eCom\CustomerCenter\CartDetail.html already exists.
4/28/2020 7:19:10 AM Package 2138 from ecom.xml.aspx
4/28/2020 7:19:10 AM Setting /Globalsettings/Ecom/Product/Details/Extensions already exists.
4/28/2020 7:19:10 AM - error: Column names in each table must be unique. Column name 'DetailsGroupExtensions' in table 'EcomDetailsGroup' is specified more than once. - System.Data.SqlClient.SqlException (0x80131904): Column names in each table must be unique. Column name 'DetailsGroupExtensions' in table 'EcomDetailsGroup' is specified more than once.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Dynamicweb.Frontend.Update.ProcessDatabase(XmlNode& xmlNode)
ClientConnectionId:6051bb4a-54eb-4c9c-b90e-dddc275dde1c
Error Number:2705,State:4,Class:16
ClientConnectionId before routing:ce43fa98-bf41-43c4-b328-cba7b7815a6b
Routing Destination:ea107b5d8e20.tr2065.northeurope1-a.worker.database.windows.net,11103
4/28/2020 7:19:10 AM Package 2139 from ecom.xml.aspx
4/28/2020 7:19:10 AM - error: Column names in each table must be unique. Column name 'ProductPurchaseMinimumQuantity' in table 'EcomProducts' is specified more than once. - System.Data.SqlClient.SqlException (0x80131904): Column names in each table must be unique. Column name 'ProductPurchaseMinimumQuantity' in table 'EcomProducts' is specified more than once.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Dynamicweb.Frontend.Update.ProcessDatabase(XmlNode& xmlNode)
ClientConnectionId:6051bb4a-54eb-4c9c-b90e-dddc275dde1c
Error Number:2705,State:4,Class:16
ClientConnectionId before routing:ce43fa98-bf41-43c4-b328-cba7b7815a6b
Routing Destination:ea107b5d8e20.tr2065.northeurope1-a.worker.database.windows.net,11103
4/28/2020 7:19:10 AM Package 2140 from ecom.xml.aspx
4/28/2020 7:19:10 AM Conditional present - escaping.
4/28/2020 7:19:10 AM Package 2141 from ecom.xml.aspx
4/28/2020 7:19:10 AM - error: Column names in each table must be unique. Column name 'PaymentUserGroups' in table 'EcomPayments' is specified more than once. - System.Data.SqlClient.SqlException (0x80131904): Column names in each table must be unique. Column name 'PaymentUserGroups' in table 'EcomPayments' is specified more than once.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Dynamicweb.Frontend.Update.ProcessDatabase(XmlNode& xmlNode)
ClientConnectionId:6051bb4a-54eb-4c9c-b90e-dddc275dde1c
Error Number:2705,State:4,Class:16
ClientConnectionId before routing:ce43fa98-bf41-43c4-b328-cba7b7815a6b
Routing Destination:ea107b5d8e20.tr2065.northeurope1-a.worker.database.windows.net,11103
4/28/2020 7:19:10 AM Package 2142 from ecom.xml.aspx
4/28/2020 7:19:10 AM - error: Column names in each table must be unique. Column name 'DiscountTranslationDescription' in table 'EcomDiscountTranslation' is specified more than once. - System.Data.SqlClient.SqlException (0x80131904): Column names in each table must be unique. Column name 'DiscountTranslationDescription' in table 'EcomDiscountTranslation' is specified more than once.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Dynamicweb.Frontend.Update.ProcessDatabase(XmlNode& xmlNode)
ClientConnectionId:6051bb4a-54eb-4c9c-b90e-dddc275dde1c
Error Number:2705,State:4,Class:16
ClientConnectionId before routing:ce43fa98-bf41-43c4-b328-cba7b7815a6b
Routing Destination:ea107b5d8e20.tr2065.northeurope1-a.worker.database.windows.net,11103
4/28/2020 7:19:10 AM Package 2143 from ecom.xml.aspx
4/28/2020 7:19:10 AM file D:\home\site\wwwroot\Dynamicweb\Solution\Templates\eCom7\CheckoutHandler\DibsEasy\Form\EmbededDibs.cshtml already exists.
4/28/2020 7:19:10 AM file D:\home\site\wwwroot\Dynamicweb\Solution\Templates\eCom7\CheckoutHandler\DibsEasy\Error\checkouthandler_error.cshtml already exists.
4/28/2020 7:19:10 AM Package 2144 from ecom.xml.aspx
4/28/2020 7:19:10 AM Conditional present - escaping.
4/28/2020 7:19:10 AM Conditional present - escaping.
4/28/2020 7:19:10 AM Standard SQL applied.
IF EXISTS( SELECT 'Enterprise' AS EngineEdition WHERE SERVERPROPERTY('EngineEdition') = 3 )
BEGIN
IF NOT EXISTS(SELECT object_id FROM sys.indexes WHERE name = 'IX_EcomAssortmentItems_AutoID')
CREATE UNIQUE CLUSTERED INDEX IX_EcomAssortmentItems_AutoID
ON EcomAssortmentItems ( AssortmentItemAutoID ASC )
WITH ( PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = ON );
IF NOT EXISTS(SELECT object_id FROM sys.indexes WHERE name = 'IX_EcomAssortmentItems_AssortmentID')
CREATE NONCLUSTERED INDEX IX_EcomAssortmentItems_AssortmentID
ON EcomAssortmentItems ( AssortmentItemAssortmentID ASC )
INCLUDE ( AssortmentItemAutoID )
WITH ( PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = ON );
IF NOT EXISTS(SELECT object_id FROM sys.indexes WHERE name = 'IX_EcomAssortmentItems_RelationType_RelationAutoID')
CREATE NONCLUSTERED INDEX IX_EcomAssortmentItems_RelationType_RelationAutoID
ON EcomAssortmentItems ( AssortmentItemRelationType ASC, AssortmentItemRelationAutoID ASC )
INCLUDE ( AssortmentItemAutoID )
WITH ( PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = ON );
IF NOT EXISTS(SELECT object_id FROM sys.indexes WHERE name = 'IX_EcomAssortmentItems_LanguageID_ProductID_ProductVariantID')
CREATE NONCLUSTERED INDEX IX_EcomAssortmentItems_LanguageID_ProductID_ProductVariantID
ON EcomAssortmentItems ( AssortmentItemLanguageID ASC, AssortmentItemProductID ASC, AssortmentItemProductVariantID ASC )
INCLUDE ( AssortmentItemAutoID )
WITH ( PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = ON );
END
4/28/2020 7:19:10 AM Standard SQL applied.
IF NOT EXISTS( SELECT 'Enterprise' AS EngineEdition WHERE SERVERPROPERTY('EngineEdition') = 3 )
BEGIN
IF NOT EXISTS(SELECT object_id FROM sys.indexes WHERE name = 'IX_EcomAssortmentItems_AutoID')
CREATE UNIQUE CLUSTERED INDEX IX_EcomAssortmentItems_AutoID
ON EcomAssortmentItems ( AssortmentItemAutoID ASC )
WITH ( PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF );
IF NOT EXISTS(SELECT object_id FROM sys.indexes WHERE name = 'IX_EcomAssortmentItems_AssortmentID')
CREATE NONCLUSTERED INDEX IX_EcomAssortmentItems_AssortmentID
ON EcomAssortmentItems ( AssortmentItemAssortmentID ASC )
INCLUDE ( AssortmentItemAutoID )
WITH ( PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF );
IF NOT EXISTS(SELECT object_id FROM sys.indexes WHERE name = 'IX_EcomAssortmentItems_RelationType_RelationAutoID')
CREATE NONCLUSTERED INDEX IX_EcomAssortmentItems_RelationType_RelationAutoID
ON EcomAssortmentItems ( AssortmentItemRelationType ASC, AssortmentItemRelationAutoID ASC )
INCLUDE ( AssortmentItemAutoID )
WITH ( PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF );
IF NOT EXISTS(SELECT object_id FROM sys.indexes WHERE name = 'IX_EcomAssortmentItems_LanguageID_ProductID_ProductVariantID')
CREATE NONCLUSTERED INDEX IX_EcomAssortmentItems_LanguageID_ProductID_ProductVariantID
ON EcomAssortmentItems ( AssortmentItemLanguageID ASC, AssortmentItemProductID ASC, AssortmentItemProductVariantID ASC )
INCLUDE ( AssortmentItemAutoID )
WITH ( PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF );
END
4/28/2020 7:19:10 AM Package 2145 from ecom.xml.aspx
4/28/2020 7:19:10 AM file D:\home\site\wwwroot\Dynamicweb\Solution\Templates\Feeds\channable_products_transformer.xslt already exists.
4/28/2020 7:19:10 AM file D:\home\site\wwwroot\Dynamicweb\Solution\System\Integration\ChannableFeedSetUp.xml already exists.
4/28/2020 7:19:10 AM file D:\home\site\wwwroot\Dynamicweb\Solution\System\Integration\Jobs\ChannableFeedQuickSetup.xml already exists.
4/28/2020 7:19:10 AM Setting /Globalsettings/Ecom/Required/ProductCategories/ChannableFieds.Brand already exists.
4/28/2020 7:19:10 AM Setting /Globalsettings/Ecom/Required/ProductCategories/ChannableFieds.Ean already exists.
4/28/2020 7:19:10 AM Package 2146 from ecom.xml.aspx
4/28/2020 7:19:10 AM Package 2147 from ecom.xml.aspx
4/28/2020 7:19:10 AM Conditional present - escaping.
4/28/2020 7:19:10 AM Package 2148 from ecom.xml.aspx
4/28/2020 7:19:10 AM Conditional present - escaping.
4/28/2020 7:19:10 AM Package 2149 from ecom.xml.aspx
4/28/2020 7:19:10 AM Conditional present - escaping.
4/28/2020 7:19:10 AM Package 2150 from ecom.xml.aspx
4/28/2020 7:19:10 AM file D:\home\site\wwwroot\Dynamicweb\Solution\System\Integration\OpenCatalog\IceCat\icecatProducts.xslt already exists.
4/28/2020 7:19:10 AM Package 2151 from ecom.xml.aspx
4/28/2020 7:19:10 AM Conditional present - escaping.
4/28/2020 7:19:10 AM Package 2152 from ecom.xml.aspx
4/28/2020 7:19:10 AM file D:\home\site\wwwroot\Dynamicweb\Solution\Templates\eCom7\CheckoutHandler\ErrorTemplate\checkouthandler_error.cshtml already exists.
4/28/2020 7:19:10 AM Package 2153 from ecom.xml.aspx
4/28/2020 7:19:10 AM Conditional present - escaping.
4/28/2020 7:19:10 AM Package 2154 from ecom.xml.aspx
4/28/2020 7:19:10 AM file D:\home\site\wwwroot\Dynamicweb\Solution\Templates\Feeds\channable_products_transformer.xslt already exists.
4/28/2020 8:42:28 AM Updates initialized
4/28/2020 8:42:29 AM Updates initialized
4/28/2020 8:58:16 AM Updates initialized
4/28/2020 8:58:16 AM Package 2114 from updates.xml.aspx
4/28/2020 8:58:16 AM Package 2115 from updates.xml.aspx
4/28/2020 8:58:16 AM - error: Column names in each table must be unique. Column name 'AreaNofollow' in table 'Area' is specified more than once. - System.Data.SqlClient.SqlException (0x80131904): Column names in each table must be unique. Column name 'AreaNofollow' in table 'Area' is specified more than once.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Dynamicweb.Frontend.Update.ProcessDatabase(XmlNode& xmlNode)
ClientConnectionId:f7098c7c-b44b-4d7d-8c2d-ac77ac0cadee
Error Number:2705,State:4,Class:16
ClientConnectionId before routing:488114d3-1e8f-405f-a674-d5a2ea51019e
Routing Destination:ea107b5d8e20.tr2065.northeurope1-a.worker.database.windows.net,11103
4/28/2020 8:58:16 AM - error: Column names in each table must be unique. Column name 'AreaNoindex' in table 'Area' is specified more than once. - System.Data.SqlClient.SqlException (0x80131904): Column names in each table must be unique. Column name 'AreaNoindex' in table 'Area' is specified more than once.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Dynamicweb.Frontend.Update.ProcessDatabase(XmlNode& xmlNode)
ClientConnectionId:f7098c7c-b44b-4d7d-8c2d-ac77ac0cadee
Error Number:2705,State:4,Class:16
ClientConnectionId before routing:488114d3-1e8f-405f-a674-d5a2ea51019e
Routing Destination:ea107b5d8e20.tr2065.northeurope1-a.worker.database.windows.net,11103
4/28/2020 8:58:16 AM Package 2116 from updates.xml.aspx
4/28/2020 8:58:16 AM Conditional present - escaping.
4/28/2020 8:58:16 AM Conditional present - escaping.
4/28/2020 8:58:16 AM Package 2117 from updates.xml.aspx
4/28/2020 8:58:16 AM Conditional present - escaping.
4/28/2020 8:58:16 AM Conditional present - escaping.
4/28/2020 8:58:16 AM Conditional present - escaping.
4/28/2020 8:58:16 AM Conditional present - escaping.
4/28/2020 8:58:16 AM Package 2118 from updates.xml.aspx
4/28/2020 8:58:16 AM Conditional present - escaping.
4/28/2020 8:58:16 AM Package 2119 from updates.xml.aspx
4/28/2020 8:58:16 AM Package 2120 from updates.xml.aspx
4/28/2020 8:58:16 AM Conditional present - escaping.
4/28/2020 8:58:16 AM Package 2121 from updates.xml.aspx
4/28/2020 8:58:16 AM file D:\home\site\wwwroot\Dynamicweb\Solution\System\OMC\Marketing reports\Visits\Acquisition\Visitors - Campaign.xml already exists.
4/28/2020 8:58:16 AM file D:\home\site\wwwroot\Dynamicweb\Solution\System\OMC\Marketing reports\Visits\Acquisition\Visitors - Referrer type.xml already exists.
4/28/2020 8:58:16 AM file D:\home\site\wwwroot\Dynamicweb\Solution\System\OMC\Marketing reports\Visits\Acquisition\Visitors - Referrer.xml already exists.
4/28/2020 8:58:16 AM file D:\home\site\wwwroot\Dynamicweb\Solution\System\OMC\Marketing reports\Visits\Behavior\Visitors - New vs Returning.xml already exists.
4/28/2020 8:58:16 AM file D:\home\site\wwwroot\Dynamicweb\Solution\System\OMC\Marketing reports\Visits\Geo\Visitors - Country.xml already exists.
4/28/2020 8:58:16 AM file D:\home\site\wwwroot\Dynamicweb\Solution\System\OMC\Marketing reports\Visits\Technology\Visitors - Device.xml already exists.
4/28/2020 8:58:16 AM file D:\home\site\wwwroot\Dynamicweb\Solution\System\OMC\Marketing reports\Visits\Overview\Visitors - Day.xml already exists.
4/28/2020 8:58:16 AM file D:\home\site\wwwroot\Dynamicweb\Solution\System\OMC\Marketing reports\Visits\Overview\Visitors - Time of day.xml already exists.
4/28/2020 8:58:16 AM file D:\home\site\wwwroot\Dynamicweb\Solution\System\OMC\Marketing reports\Visits\Overview\Visitors - Website.xml already exists.
4/28/2020 8:58:16 AM file D:\home\site\wwwroot\Dynamicweb\Solution\System\OMC\Marketing reports\Visits\Overview\Visitors - Year.xml already exists.
4/28/2020 8:58:16 AM Package 2122 from updates.xml.aspx
4/28/2020 8:58:16 AM Conditional present - escaping.
4/28/2020 8:58:16 AM Conditional present - escaping.
4/28/2020 8:58:16 AM Conditional present - escaping.
4/28/2020 8:58:16 AM Conditional present - escaping.
4/28/2020 8:58:16 AM Conditional present - escaping.
4/28/2020 8:58:16 AM Conditional present - escaping.
4/28/2020 8:58:16 AM Conditional present - escaping.
4/28/2020 8:58:16 AM Package 2123 from updates.xml.aspx
4/28/2020 8:58:16 AM Conditional present - escaping.
4/28/2020 8:58:16 AM Package 2124 from updates.xml.aspx
4/28/2020 8:58:16 AM Conditional present - escaping.
4/28/2020 8:58:16 AM Package 2125 from updates.xml.aspx
4/28/2020 8:58:16 AM Conditional present - escaping.
4/28/2020 8:58:16 AM Conditional present - escaping.
4/28/2020 8:58:16 AM Package 2126 from updates.xml.aspx
4/28/2020 8:58:16 AM Conditional present - escaping.
4/28/2020 8:58:16 AM Package 2127 from updates.xml.aspx
4/28/2020 8:58:16 AM file D:\home\site\wwwroot\Dynamicweb\Solution\System\OMC\Marketing reports\Visits\Behavior\Visitors - Most viewed pages.xml already exists.
4/28/2020 8:58:16 AM Package 2128 from updates.xml.aspx
4/28/2020 8:58:16 AM Conditional present - escaping.
4/28/2020 8:58:16 AM Conditional present - escaping.
4/28/2020 8:58:16 AM Conditional present - escaping.
4/28/2020 8:58:16 AM Package 2129 from updates.xml.aspx
4/28/2020 8:58:16 AM Conditional present - escaping.
4/28/2020 8:58:16 AM Conditional present - escaping.
4/28/2020 8:58:16 AM Package 2130 from updates.xml.aspx
4/28/2020 8:58:16 AM Conditional present - escaping.
4/28/2020 8:58:16 AM Package 2131 from updates.xml.aspx
4/28/2020 8:58:16 AM Conditional present - escaping.
4/28/2020 8:58:16 AM Package 2132 from updates.xml.aspx
4/28/2020 8:58:16 AM Conditional present - escaping.
4/28/2020 8:58:16 AM Conditional present - escaping.
4/28/2020 8:58:16 AM Conditional present - escaping.
4/28/2020 8:58:16 AM Conditional present - escaping.
4/28/2020 8:58:16 AM Package 2133 from updates.xml.aspx
4/28/2020 8:58:16 AM Conditional present - escaping.
4/28/2020 8:58:16 AM Package 2134 from updates.xml.aspx
4/28/2020 8:58:16 AM file D:\home\site\wwwroot\Dynamicweb\Solution\Templates\CookieWarning\ModalDialogWarning_Categories.cshtml already exists.
4/28/2020 8:58:19 AM Updates initialized
4/28/2020 8:58:19 AM Package 2131 from ecom.xml.aspx
4/28/2020 8:58:19 AM Conditional present - escaping.
4/28/2020 8:58:19 AM Standard SQL applied.
ALTER TABLE [EcomGroupFacetRelation] ALTER COLUMN [GroupFacetRelationFacetField] [nvarchar](255) NULL;
ALTER TABLE [EcomGroupFacetRelation] ALTER COLUMN [GroupFacetRelationQueryParameter] [nvarchar](100) NULL;
4/28/2020 8:58:19 AM Package 2132 from ecom.xml.aspx
4/28/2020 8:58:19 AM Package 2133 from ecom.xml.aspx
4/28/2020 8:58:19 AM Conditional present - escaping.
4/28/2020 8:58:19 AM Conditional present - escaping.
4/28/2020 8:58:19 AM Package 2134 from ecom.xml.aspx
4/28/2020 8:58:19 AM Standard SQL applied.
UPDATE [EcomShippings] SET [ShippingActive] = 1 WHERE [ShippingActive] IS NULL
4/28/2020 8:58:19 AM Package 2135 from ecom.xml.aspx
4/28/2020 8:58:20 AM Package 2136 from ecom.xml.aspx
4/28/2020 8:58:20 AM - error: Column names in each table must be unique. Column name 'IsShared' in table 'EcomCustomerFavoriteLists' is specified more than once. - System.Data.SqlClient.SqlException (0x80131904): Column names in each table must be unique. Column name 'IsShared' in table 'EcomCustomerFavoriteLists' is specified more than once.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Dynamicweb.Frontend.Update.ProcessDatabase(XmlNode& xmlNode)
ClientConnectionId:f7098c7c-b44b-4d7d-8c2d-ac77ac0cadee
Error Number:2705,State:4,Class:16
ClientConnectionId before routing:488114d3-1e8f-405f-a674-d5a2ea51019e
Routing Destination:ea107b5d8e20.tr2065.northeurope1-a.worker.database.windows.net,11103
4/28/2020 8:58:20 AM Package 2137 from ecom.xml.aspx
4/28/2020 8:58:20 AM file D:\home\site\wwwroot\Dynamicweb\Solution\Templates\eCom\CustomerCenter\CartList.html already exists.
4/28/2020 8:58:20 AM file D:\home\site\wwwroot\Dynamicweb\Solution\Templates\eCom\CustomerCenter\CartDetail.html already exists.
4/28/2020 8:58:20 AM Package 2138 from ecom.xml.aspx
4/28/2020 8:58:20 AM Setting /Globalsettings/Ecom/Product/Details/Extensions already exists.
4/28/2020 8:58:20 AM - error: Column names in each table must be unique. Column name 'DetailsGroupExtensions' in table 'EcomDetailsGroup' is specified more than once. - System.Data.SqlClient.SqlException (0x80131904): Column names in each table must be unique. Column name 'DetailsGroupExtensions' in table 'EcomDetailsGroup' is specified more than once.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Dynamicweb.Frontend.Update.ProcessDatabase(XmlNode& xmlNode)
ClientConnectionId:f7098c7c-b44b-4d7d-8c2d-ac77ac0cadee
Error Number:2705,State:4,Class:16
ClientConnectionId before routing:488114d3-1e8f-405f-a674-d5a2ea51019e
Routing Destination:ea107b5d8e20.tr2065.northeurope1-a.worker.database.windows.net,11103
4/28/2020 8:58:20 AM Package 2139 from ecom.xml.aspx
4/28/2020 8:58:20 AM - error: Column names in each table must be unique. Column name 'ProductPurchaseMinimumQuantity' in table 'EcomProducts' is specified more than once. - System.Data.SqlClient.SqlException (0x80131904): Column names in each table must be unique. Column name 'ProductPurchaseMinimumQuantity' in table 'EcomProducts' is specified more than once.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Dynamicweb.Frontend.Update.ProcessDatabase(XmlNode& xmlNode)
ClientConnectionId:f7098c7c-b44b-4d7d-8c2d-ac77ac0cadee
Error Number:2705,State:4,Class:16
ClientConnectionId before routing:488114d3-1e8f-405f-a674-d5a2ea51019e
Routing Destination:ea107b5d8e20.tr2065.northeurope1-a.worker.database.windows.net,11103
4/28/2020 8:58:20 AM Package 2140 from ecom.xml.aspx
4/28/2020 8:58:20 AM Conditional present - escaping.
4/28/2020 8:58:20 AM Package 2141 from ecom.xml.aspx
4/28/2020 8:58:20 AM - error: Column names in each table must be unique. Column name 'PaymentUserGroups' in table 'EcomPayments' is specified more than once. - System.Data.SqlClient.SqlException (0x80131904): Column names in each table must be unique. Column name 'PaymentUserGroups' in table 'EcomPayments' is specified more than once.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Dynamicweb.Frontend.Update.ProcessDatabase(XmlNode& xmlNode)
ClientConnectionId:f7098c7c-b44b-4d7d-8c2d-ac77ac0cadee
Error Number:2705,State:4,Class:16
ClientConnectionId before routing:488114d3-1e8f-405f-a674-d5a2ea51019e
Routing Destination:ea107b5d8e20.tr2065.northeurope1-a.worker.database.windows.net,11103
4/28/2020 8:58:20 AM Package 2142 from ecom.xml.aspx
4/28/2020 8:58:20 AM - error: Column names in each table must be unique. Column name 'DiscountTranslationDescription' in table 'EcomDiscountTranslation' is specified more than once. - System.Data.SqlClient.SqlException (0x80131904): Column names in each table must be unique. Column name 'DiscountTranslationDescription' in table 'EcomDiscountTranslation' is specified more than once.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Dynamicweb.Frontend.Update.ProcessDatabase(XmlNode& xmlNode)
ClientConnectionId:f7098c7c-b44b-4d7d-8c2d-ac77ac0cadee
Error Number:2705,State:4,Class:16
ClientConnectionId before routing:488114d3-1e8f-405f-a674-d5a2ea51019e
Routing Destination:ea107b5d8e20.tr2065.northeurope1-a.worker.database.windows.net,11103
4/28/2020 8:58:20 AM Package 2143 from ecom.xml.aspx
4/28/2020 8:58:20 AM file D:\home\site\wwwroot\Dynamicweb\Solution\Templates\eCom7\CheckoutHandler\DibsEasy\Form\EmbededDibs.cshtml already exists.
4/28/2020 8:58:20 AM file D:\home\site\wwwroot\Dynamicweb\Solution\Templates\eCom7\CheckoutHandler\DibsEasy\Error\checkouthandler_error.cshtml already exists.
4/28/2020 8:58:20 AM Package 2144 from ecom.xml.aspx
4/28/2020 8:58:20 AM Conditional present - escaping.
4/28/2020 8:58:20 AM Conditional present - escaping.
4/28/2020 8:58:20 AM Standard SQL applied.
IF EXISTS( SELECT 'Enterprise' AS EngineEdition WHERE SERVERPROPERTY('EngineEdition') = 3 )
BEGIN
IF NOT EXISTS(SELECT object_id FROM sys.indexes WHERE name = 'IX_EcomAssortmentItems_AutoID')
CREATE UNIQUE CLUSTERED INDEX IX_EcomAssortmentItems_AutoID
ON EcomAssortmentItems ( AssortmentItemAutoID ASC )
WITH ( PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = ON );
IF NOT EXISTS(SELECT object_id FROM sys.indexes WHERE name = 'IX_EcomAssortmentItems_AssortmentID')
CREATE NONCLUSTERED INDEX IX_EcomAssortmentItems_AssortmentID
ON EcomAssortmentItems ( AssortmentItemAssortmentID ASC )
INCLUDE ( AssortmentItemAutoID )
WITH ( PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = ON );
IF NOT EXISTS(SELECT object_id FROM sys.indexes WHERE name = 'IX_EcomAssortmentItems_RelationType_RelationAutoID')
CREATE NONCLUSTERED INDEX IX_EcomAssortmentItems_RelationType_RelationAutoID
ON EcomAssortmentItems ( AssortmentItemRelationType ASC, AssortmentItemRelationAutoID ASC )
INCLUDE ( AssortmentItemAutoID )
WITH ( PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = ON );
IF NOT EXISTS(SELECT object_id FROM sys.indexes WHERE name = 'IX_EcomAssortmentItems_LanguageID_ProductID_ProductVariantID')
CREATE NONCLUSTERED INDEX IX_EcomAssortmentItems_LanguageID_ProductID_ProductVariantID
ON EcomAssortmentItems ( AssortmentItemLanguageID ASC, AssortmentItemProductID ASC, AssortmentItemProductVariantID ASC )
INCLUDE ( AssortmentItemAutoID )
WITH ( PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = ON );
END
4/28/2020 8:58:20 AM Standard SQL applied.
IF NOT EXISTS( SELECT 'Enterprise' AS EngineEdition WHERE SERVERPROPERTY('EngineEdition') = 3 )
BEGIN
IF NOT EXISTS(SELECT object_id FROM sys.indexes WHERE name = 'IX_EcomAssortmentItems_AutoID')
CREATE UNIQUE CLUSTERED INDEX IX_EcomAssortmentItems_AutoID
ON EcomAssortmentItems ( AssortmentItemAutoID ASC )
WITH ( PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF );
IF NOT EXISTS(SELECT object_id FROM sys.indexes WHERE name = 'IX_EcomAssortmentItems_AssortmentID')
CREATE NONCLUSTERED INDEX IX_EcomAssortmentItems_AssortmentID
ON EcomAssortmentItems ( AssortmentItemAssortmentID ASC )
INCLUDE ( AssortmentItemAutoID )
WITH ( PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF );
IF NOT EXISTS(SELECT object_id FROM sys.indexes WHERE name = 'IX_EcomAssortmentItems_RelationType_RelationAutoID')
CREATE NONCLUSTERED INDEX IX_EcomAssortmentItems_RelationType_RelationAutoID
ON EcomAssortmentItems ( AssortmentItemRelationType ASC, AssortmentItemRelationAutoID ASC )
INCLUDE ( AssortmentItemAutoID )
WITH ( PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF );
IF NOT EXISTS(SELECT object_id FROM sys.indexes WHERE name = 'IX_EcomAssortmentItems_LanguageID_ProductID_ProductVariantID')
CREATE NONCLUSTERED INDEX IX_EcomAssortmentItems_LanguageID_ProductID_ProductVariantID
ON EcomAssortmentItems ( AssortmentItemLanguageID ASC, AssortmentItemProductID ASC, AssortmentItemProductVariantID ASC )
INCLUDE ( AssortmentItemAutoID )
WITH ( PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF );
END
4/28/2020 8:58:20 AM Package 2145 from ecom.xml.aspx
4/28/2020 8:58:20 AM file D:\home\site\wwwroot\Dynamicweb\Solution\Templates\Feeds\channable_products_transformer.xslt already exists.
4/28/2020 8:58:20 AM file D:\home\site\wwwroot\Dynamicweb\Solution\System\Integration\ChannableFeedSetUp.xml already exists.
4/28/2020 8:58:20 AM file D:\home\site\wwwroot\Dynamicweb\Solution\System\Integration\Jobs\ChannableFeedQuickSetup.xml already exists.
4/28/2020 8:58:20 AM Setting /Globalsettings/Ecom/Required/ProductCategories/ChannableFieds.Brand already exists.
4/28/2020 8:58:20 AM Setting /Globalsettings/Ecom/Required/ProductCategories/ChannableFieds.Ean already exists.
4/28/2020 8:58:20 AM Package 2146 from ecom.xml.aspx
4/28/2020 8:58:20 AM Package 2147 from ecom.xml.aspx
4/28/2020 8:58:20 AM Conditional present - escaping.
4/28/2020 8:58:20 AM Package 2148 from ecom.xml.aspx
4/28/2020 8:58:20 AM Conditional present - escaping.
4/28/2020 8:58:20 AM Package 2149 from ecom.xml.aspx
4/28/2020 8:58:20 AM Conditional present - escaping.
4/28/2020 8:58:20 AM Package 2150 from ecom.xml.aspx
4/28/2020 8:58:20 AM file D:\home\site\wwwroot\Dynamicweb\Solution\System\Integration\OpenCatalog\IceCat\icecatProducts.xslt already exists.
4/28/2020 8:58:20 AM Package 2151 from ecom.xml.aspx
4/28/2020 8:58:20 AM Conditional present - escaping.
4/28/2020 8:58:20 AM Package 2152 from ecom.xml.aspx
4/28/2020 8:58:20 AM file D:\home\site\wwwroot\Dynamicweb\Solution\Templates\eCom7\CheckoutHandler\ErrorTemplate\checkouthandler_error.cshtml already exists.
4/28/2020 8:58:20 AM Package 2153 from ecom.xml.aspx
4/28/2020 8:58:20 AM Conditional present - escaping.
4/28/2020 8:58:20 AM Package 2154 from ecom.xml.aspx
4/28/2020 8:58:20 AM file D:\home\site\wwwroot\Dynamicweb\Solution\Templates\Feeds\channable_products_transformer.xslt already exists.
4/28/2020 9:03:36 AM Updates initialized
4/28/2020 9:03:36 AM Package 1995 from updates.xml.aspx
4/28/2020 9:03:36 AM Package 1996 from updates.xml.aspx
4/28/2020 9:03:36 AM Package 1997 from updates.xml.aspx
4/28/2020 9:03:36 AM Package 1998 from updates.xml.aspx
4/28/2020 9:03:36 AM Package 1999 from updates.xml.aspx
4/28/2020 9:03:36 AM Package 2000 from updates.xml.aspx
4/28/2020 9:03:36 AM - error: There is already an object named 'RecycleBin' in the database. - System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'RecycleBin' in the database.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Dynamicweb.Frontend.Update.ProcessDatabase(XmlNode& xmlNode)
ClientConnectionId:24a22f0b-47b6-4ec9-97a9-bd864ed7230c
Error Number:2714,State:6,Class:16
ClientConnectionId before routing:913390d9-762d-453d-a6b8-cfa7f45ae528
Routing Destination:ea107b5d8e20.tr2065.northeurope1-a.worker.database.windows.net,11103
4/28/2020 9:03:36 AM Package 2001 from updates.xml.aspx
4/28/2020 9:03:36 AM Standard SQL applied.
DELETE FROM [Module]
WHERE ModuleSystemName = 'Accessibility' OR
ModuleSystemName = 'Audit' OR
ModuleSystemName = 'Booking' OR
ModuleSystemName = 'eCards' OR
ModuleSystemName = 'Calender' OR
ModuleSystemName = 'Calendar' OR
ModuleSystemName = 'CalendarV2' OR
ModuleSystemName = 'Contentsubscription' OR
ModuleSystemName = 'CRMIntegration' OR
ModuleSystemName = 'DealerSearch' OR
ModuleSystemName = 'eCards' OR
ModuleSystemName = 'CRMIntegration' OR
ModuleSystemName = 'DbPub' OR
ModuleSystemName = 'DBIntegration' OR
ModuleSystemName = 'DealerSearch' OR
ModuleSystemName = 'eCards' OR
ModuleSystemName = 'Employee' OR
ModuleSystemName = 'FactBoxes' OR
ModuleSystemName = 'FAQ' OR
ModuleSystemName = 'Form' OR
ModuleSystemName = 'FormExtended' OR
ModuleSystemName = 'Forum' OR
ModuleSystemName = 'ForumV2' OR
ModuleSystemName = 'ImageGallery' OR
ModuleSystemName = 'DW_Integration_ImportExport' OR
ModuleSystemName = 'DW_Integration_ImportExportExtended' OR
ModuleSystemName = 'IndexingSearching' OR
ModuleSystemName = 'ControlLoader' OR
ModuleSystemName = 'iPaper' OR
ModuleSystemName = 'IpaperExtended' OR
ModuleSystemName = 'Keywordfinder' OR
ModuleSystemName = 'LanguagePack' OR
ModuleSystemName = 'LinkSearch' OR
ModuleSystemName = 'MediaDatabase' OR
ModuleSystemName = 'Metadata' OR
ModuleSystemName = 'Mindwork' OR
ModuleSystemName = 'PaymentGateway' OR
ModuleSystemName = 'ProductGallery' OR
ModuleSystemName = 'News' OR
ModuleSystemName = 'NewsLetter' OR
ModuleSystemName = 'NewsLetterExtended' OR
ModuleSystemName = 'NewsLetterV3' OR
ModuleSystemName = 'Poll' OR
ModuleSystemName = 'Rotation' OR
ModuleSystemName = 'RSSFeed' OR
ModuleSystemName = 'Seo' OR
ModuleSystemName = 'ShoppingCart' OR
ModuleSystemName = 'ShoppingCartV1' OR
ModuleSystemName = 'Sitemap' OR
ModuleSystemName = 'SmsOld' OR
ModuleSystemName = 'Statistics' OR
ModuleSystemName = 'StatisticsExtended' OR
ModuleSystemName = 'StatisticsV3' OR
ModuleSystemName = 'Survey' OR
ModuleSystemName = 'Tagwall' OR
ModuleSystemName = 'Template' OR
ModuleSystemName = 'Weblog' OR
ModuleSystemName = 'Recommendation'
4/28/2020 9:03:36 AM Package 2002 from updates.xml.aspx
4/28/2020 9:03:36 AM Folder D:\home\site\wwwroot\Dynamicweb\Solution\System\Editor\ckeditor\config does not exist - creating.
4/28/2020 9:03:36 AM file D:\home\site\wwwroot\Dynamicweb\Applications\Application(9.8.5)\Admin\Update\\Files\System\Editor\ckeditor\config\\advanced.js added.
4/28/2020 9:03:36 AM Folder D:\home\site\wwwroot\Dynamicweb\Solution\System\Editor\ckeditor\config does not exist - creating.
4/28/2020 9:03:37 AM file D:\home\site\wwwroot\Dynamicweb\Applications\Application(9.8.5)\Admin\Update\\Files\System\Editor\ckeditor\config\\basic.js added.
4/28/2020 9:03:37 AM Folder D:\home\site\wwwroot\Dynamicweb\Solution\System\Editor\ckeditor\config does not exist - creating.
4/28/2020 9:03:37 AM file D:\home\site\wwwroot\Dynamicweb\Applications\Application(9.8.5)\Admin\Update\\Files\System\Editor\ckeditor\config\\clean.js added.
4/28/2020 9:03:37 AM Folder D:\home\site\wwwroot\Dynamicweb\Solution\System\Editor\ckeditor\config does not exist - creating.
4/28/2020 9:03:37 AM file D:\home\site\wwwroot\Dynamicweb\Applications\Application(9.8.5)\Admin\Update\\Files\System\Editor\ckeditor\config\\default.js added.
4/28/2020 9:03:37 AM Folder D:\home\site\wwwroot\Dynamicweb\Solution\System\Editor\ckeditor\config does not exist - creating.
4/28/2020 9:03:37 AM file D:\home\site\wwwroot\Dynamicweb\Applications\Application(9.8.5)\Admin\Update\\Files\System\Editor\ckeditor\config\\developer.js added.
4/28/2020 9:03:37 AM Folder D:\home\site\wwwroot\Dynamicweb\Solution\System\Editor\ckeditor\config does not exist - creating.
4/28/2020 9:03:37 AM file D:\home\site\wwwroot\Dynamicweb\Applications\Application(9.8.5)\Admin\Update\\Files\System\Editor\ckeditor\config\\email.js added.
4/28/2020 9:03:37 AM Package 2003 from updates.xml.aspx
4/28/2020 9:03:37 AM Folder D:\home\site\wwwroot\Dynamicweb\Solution\System\Integration\Jobs\ModuleSpecificJobs\UserManagementModuleJobs\ExportJobs does not exist - creating.
4/28/2020 9:03:38 AM file D:\home\site\wwwroot\Dynamicweb\Applications\Application(9.8.5)\Admin\Update\\Files\System\Integration\Jobs\ModuleSpecificJobs\UserManagementModuleJobs\ExportJobs\ExportUsers.xml added.
4/28/2020 9:03:38 AM Folder D:\home\site\wwwroot\Dynamicweb\Solution\System\Integration\Jobs\ModuleSpecificJobs\UserManagementModuleJobs\ExportJobs does not exist - creating.
4/28/2020 9:03:38 AM file D:\home\site\wwwroot\Dynamicweb\Applications\Application(9.8.5)\Admin\Update\\Files\System\Integration\Jobs\ModuleSpecificJobs\UserManagementModuleJobs\ExportJobs\ExportUsersWithSelectedColumns.xml added.
4/28/2020 9:03:38 AM Folder D:\home\site\wwwroot\Dynamicweb\Solution\System\Integration\Jobs\ModuleSpecificJobs\UserManagementModuleJobs\ImportJobs does not exist - creating.
4/28/2020 9:03:38 AM file D:\home\site\wwwroot\Dynamicweb\Applications\Application(9.8.5)\Admin\Update\\Files\System\Integration\Jobs\ModuleSpecificJobs\UserManagementModuleJobs\ImportJobs\ImportUsers.xml added.
4/28/2020 9:03:38 AM Folder D:\home\site\wwwroot\Dynamicweb\Solution\System\Integration\Jobs\ModuleSpecificJobs\UserManagementModuleJobs\ImportJobs does not exist - creating.
4/28/2020 9:03:38 AM file D:\home\site\wwwroot\Dynamicweb\Applications\Application(9.8.5)\Admin\Update\\Files\System\Integration\Jobs\ModuleSpecificJobs\UserManagementModuleJobs\ImportJobs\ImportUsersFromExcel.xml added.
4/28/2020 9:03:38 AM Folder D:\home\site\wwwroot\Dynamicweb\Solution\System\Integration\Jobs does not exist - creating.
4/28/2020 9:03:38 AM file D:\home\site\wwwroot\Dynamicweb\Applications\Application(9.8.5)\Admin\Update\\Files\System\Integration\Jobs\ErpDataImport.xml added.
4/28/2020 9:03:38 AM Folder D:\home\site\wwwroot\Dynamicweb\Solution\System\Integration\Jobs does not exist - creating.
4/28/2020 9:03:38 AM file D:\home\site\wwwroot\Dynamicweb\Applications\Application(9.8.5)\Admin\Update\\Files\System\Integration\Jobs\ErpOrderExport.xml added.
4/28/2020 9:03:38 AM Folder D:\home\site\wwwroot\Dynamicweb\Solution\System\Integration\Jobs does not exist - creating.
4/28/2020 9:03:39 AM file D:\home\site\wwwroot\Dynamicweb\Applications\Application(9.8.5)\Admin\Update\\Files\System\Integration\Jobs\ErpUserExport.xml added.
4/28/2020 9:03:39 AM Folder D:\home\site\wwwroot\Dynamicweb\Solution\System\Integration\Jobs does not exist - creating.
4/28/2020 9:03:39 AM file D:\home\site\wwwroot\Dynamicweb\Applications\Application(9.8.5)\Admin\Update\\Files\System\Integration\Jobs\ErpUserImport.xml added.
4/28/2020 9:03:39 AM Package 2004 from updates.xml.aspx
4/28/2020 9:03:39 AM Standard SQL applied.
ALTER TABLE Area ALTER COLUMN AreaDomain nvarchar(255) NULL
4/28/2020 9:03:39 AM Package 2005 from updates.xml.aspx
4/28/2020 9:03:39 AM Standard SQL applied.
UPDATE [Module] SET [ModuleName] = 'Ecom varekatalog' WHERE ModuleSystemName = 'eCom_Catalog'
4/28/2020 9:03:39 AM Package 2006 from updates.xml.aspx
4/28/2020 9:03:39 AM - error: Column names in each table must be unique. Column name 'ModuleIconClass' in table 'Module' is specified more than once. - System.Data.SqlClient.SqlException (0x80131904): Column names in each table must be unique. Column name 'ModuleIconClass' in table 'Module' is specified more than once.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Dynamicweb.Frontend.Update.ProcessDatabase(XmlNode& xmlNode)
ClientConnectionId:24a22f0b-47b6-4ec9-97a9-bd864ed7230c
Error Number:2705,State:4,Class:16
ClientConnectionId before routing:913390d9-762d-453d-a6b8-cfa7f45ae528
Routing Destination:ea107b5d8e20.tr2065.northeurope1-a.worker.database.windows.net,11103
4/28/2020 9:03:39 AM Package 2007 from updates.xml.aspx
4/28/2020 9:03:39 AM Standard SQL applied.
UPDATE [Module] SET [ModuleName] = 'Websites' WHERE ModuleSystemName = 'Area'
4/28/2020 9:03:39 AM Package 2008 from updates.xml.aspx
4/28/2020 9:03:39 AM Standard SQL applied.
UPDATE [ScheduledTask] SET [TaskAssembly] = 'Dynamicweb.Scheduling.Providers.AssortmentItemBuilderScheduledTaskAddIn.AssortmentItemBuilderScheduledTaskAddIn' WHERE [TaskAssembly] = 'Dynamicweb.Ecommerce.Assortments.AssortmentItemBuilderScheduledTaskAddIn';
UPDATE [ScheduledTask] SET [TaskAssembly] = 'Dynamicweb.Scheduling.Providers.CalculatedFieldsScheduledTaskAddIn.CalculatedFieldsScheduledTaskAddIn' WHERE [TaskAssembly] = 'Dynamicweb.eCommerce.CalculatedFields.CalculatedFieldsScheduledTaskAddIn';
UPDATE [ScheduledTask] SET [TaskAssembly] = 'Dynamicweb.Scheduling.Providers.CalculateSmartSearchScheduledTaskAddIn.CalculateSmartSearchScheduledTaskAddIn' WHERE [TaskAssembly] = 'Dynamicweb.Modules.Searching.SmartSearch.CalculateSmartSearchScheduledTastAddIn';
UPDATE [ScheduledTask] SET [TaskAssembly] = 'Dynamicweb.Scheduling.Providers.GroupsAsSmartSearchesScheduledTaskAddIn.GroupsAsSmartSearchesScheduledTaskAddIn' WHERE [TaskAssembly] = 'Dynamicweb.Modules.UserManagement.GroupsAsSmartSearchesScheduledTaskAddIn';
UPDATE [ScheduledTask] SET [TaskAssembly] = 'Dynamicweb.Scheduling.Providers.PointExpirationScheduledTaskAddIn.PointExpirationScheduledTaskAddIn' WHERE [TaskAssembly] = 'Dynamicweb.Ecommerce.Loyalty.PointExpirationScheduledTaskAddIn';
UPDATE [ScheduledTask] SET [TaskAssembly] = 'Dynamicweb.Scheduling.Providers.RecurringOrdersScheduledTaskAddIn.RecurringOrdersScheduledTaskAddIn' WHERE [TaskAssembly] = 'Dynamicweb.eCommerce.Orders.RecurringOrdersScheduledTaskAddIn';
4/28/2020 9:03:39 AM Package 2009 from updates.xml.aspx
4/28/2020 9:03:39 AM Standard SQL applied.
WITH cte AS (
SELECT [ModuleSystemName], [ModuleAccess], ROW_NUMBER() OVER(PARTITION BY [ModuleSystemName] ORDER BY [ModuleSystemName], [ModuleAccess] DESC ) rnk
FROM [Module]
)
DELETE FROM cte WHERE rnk > 1;
4/28/2020 9:03:39 AM Package 2010 from updates.xml.aspx
4/28/2020 9:03:39 AM Standard SQL applied.
UPDATE [Module] SET [ModuleParagraph] = 0 WHERE [ModuleSystemName] = 'eCom_ShowList'
4/28/2020 9:03:39 AM Package 2011 from updates.xml.aspx
4/28/2020 9:03:39 AM Standard SQL applied.
UPDATE [Paragraph] Set [ParagraphSort] = 1 WHERE [ParagraphSort] = 0
4/28/2020 9:03:39 AM Package 2012 from updates.xml.aspx
4/28/2020 9:03:39 AM Package 2013 from updates.xml.aspx
4/28/2020 9:03:39 AM Standard SQL applied.
UPDATE [Module] SET [ModuleIconClass] = 'LibraryBooks' WHERE [ModuleSystemName] = 'RemoteHttp';
UPDATE [Module] SET [ModuleIconClass] = 'Assignment' WHERE [ModuleSystemName] = 'eCom_ContextOrderRenderer';
UPDATE [Module] SET [ModuleIconClass] = 'Ticket' WHERE [ModuleSystemName] = 'eCom_ContextVoucherRenderer';
UPDATE [Module] SET [ModuleIconClass] = 'AssignmentInd' WHERE [ModuleSystemName] = 'eCom_CustomerCenter';
UPDATE [Module] SET [ModuleIconClass] = 'SignIn' WHERE [ModuleSystemName] = 'ImportExport_DW8';
UPDATE [Module] SET [ModuleIconClass] = 'List' WHERE [ModuleSystemName] = 'DM_Publishing';
UPDATE [Module] SET [ModuleIconClass] = 'Email' WHERE [ModuleSystemName] = 'EmailMarketing';
UPDATE [Module] SET [ModuleIconClass] = 'Lock' WHERE [ModuleSystemName] = 'UserManagementFrontend';
UPDATE [Module] SET [ModuleIconClass] = 'FolderOpen' WHERE [ModuleSystemName] = 'Filepublish';
UPDATE [Module] SET [ModuleIconClass] = 'Tasks' WHERE [ModuleSystemName] = 'DM_Form';
UPDATE [Module] SET [ModuleIconClass] = 'Tasks' WHERE [ModuleSystemName] = 'BasicForms';
UPDATE [Module] SET [ModuleIconClass] = 'Forum' WHERE [ModuleSystemName] = 'BasicForum';
UPDATE [Module] SET [ModuleIconClass] = 'PhotoLibrary' WHERE [ModuleSystemName] = 'Gallery';
UPDATE [Module] SET [ModuleIconClass] = 'AssignmentInd' WHERE [ModuleSystemName] = 'eCom_IntegrationCustomerCenter';
UPDATE [Module] SET [ModuleIconClass] = 'Cube' WHERE [ModuleSystemName] = 'ItemCreator';
UPDATE [Module] SET [ModuleIconClass] = 'Cube' WHERE [ModuleSystemName] = 'ItemPublisher';
UPDATE [Module] SET [ModuleIconClass] = 'Language' WHERE [ModuleSystemName] = 'LanguageManagement';
UPDATE [Module] SET [ModuleIconClass] = 'Flag' WHERE [ModuleSystemName] = 'Leads';
UPDATE [Module] SET [ModuleIconClass] = 'CodeFork' WHERE [ModuleSystemName] = 'LoadBalancing';
UPDATE [Module] SET [ModuleIconClass] = 'Loyalty' WHERE [ModuleSystemName] = 'LoyaltyPoints';
UPDATE [Module] SET [ModuleIconClass] = 'MapMaker' WHERE [ModuleSystemName] = 'Maps';
UPDATE [Module] SET [ModuleIconClass] = 'Equalizer' WHERE [ModuleSystemName] = 'OMC';
UPDATE [Module] SET [ModuleIconClass] = 'ViewArray' WHERE [ModuleSystemName] = 'NewsV2';
UPDATE [Module] SET [ModuleIconClass] = 'AccountBox' WHERE [ModuleSystemName] = 'Profiling';
UPDATE [Module] SET [ModuleIconClass] = 'Archive' WHERE [ModuleSystemName] = 'eCom_Catalog';
UPDATE [Module] SET [ModuleIconClass] = 'FilterList' WHERE [ModuleSystemName] = 'QueryPublisher';
UPDATE [Module] SET [ModuleIconClass] = 'Search' WHERE [ModuleSystemName] = 'Searchv1';
UPDATE [Module] SET [ModuleIconClass] = 'Assignment' WHERE [ModuleSystemName] = 'eCom_CartV2';
UPDATE [Module] SET [ModuleIconClass] = 'Sitemap' WHERE [ModuleSystemName] = 'SitemapV2';
UPDATE [Module] SET [ModuleIconClass] = 'Sms' WHERE [ModuleSystemName] = 'Sms';
UPDATE [Module] SET [ModuleIconClass] = 'Users' WHERE [ModuleSystemName] = 'SocialMediaPublishing';
UPDATE [Module] SET [ModuleIconClass] = 'Clipboard' WHERE [ModuleSystemName] = 'Update';
UPDATE [Module] SET [ModuleIconClass] = 'Person' WHERE [ModuleSystemName] = 'UserManagementBackend';
UPDATE [Module] SET [ModuleIconClass] = 'Filter9' WHERE [ModuleSystemName] = 'VersionControl';
UPDATE [Module] SET [ModuleIconClass] = 'Layers' WHERE [ModuleSystemName] = 'Area';
UPDATE [Module] SET [ModuleIconClass] = 'PlayInstall' WHERE [ModuleSystemName] = 'Workflow';
4/28/2020 9:03:39 AM Package 2014 from updates.xml.aspx
4/28/2020 9:03:39 AM Standard SQL applied.
UPDATE [Module] SET [ModuleIconClass] = 'Lock' WHERE [ModuleSystemName] = 'UserManagementFrontendExtended';
UPDATE [Module] SET [ModuleIconClass] = 'Star' WHERE [ModuleSystemName] = 'eCom_ShowList';
UPDATE [Module] SET [ModuleIconClass] = 'ViewQuilt' WHERE [ModuleSystemName] = 'eCom_Assortments';
UPDATE [Module] SET [ModuleIconClass] = 'Archive' WHERE [ModuleSystemName] = 'eCom_BackCatalog';
UPDATE [Module] SET [ModuleIconClass] = 'WalletGiftcard' WHERE [ModuleSystemName] = 'GiftCards';
UPDATE [Module] SET [ModuleIconClass] = 'Public' WHERE [ModuleSystemName] = 'eCom_International';
UPDATE [Module] SET [ModuleIconClass] = 'Store' WHERE [ModuleSystemName] = 'eCom_MultiShopAdvanced';
UPDATE [Module] SET [ModuleIconClass] = 'Tags' WHERE [ModuleSystemName] = 'eCom_DiscountMatrix';
UPDATE [Module] SET [ModuleIconClass] = 'List' WHERE [ModuleSystemName] = 'eCom_PartsListsExtended';
UPDATE [Module] SET [ModuleIconClass] = 'List' WHERE [ModuleSystemName] = 'eCom_PartsLists';
UPDATE [Module] SET [ModuleIconClass] = 'Payment' WHERE [ModuleSystemName] = 'eCom_Payment';
UPDATE [Module] SET [ModuleIconClass] = 'FlashOn' WHERE [ModuleSystemName] = 'eCom_PowerPack';
UPDATE [Module] SET [ModuleIconClass] = 'Money' WHERE [ModuleSystemName] = 'eCom_PricingExtended';
UPDATE [Module] SET [ModuleIconClass] = 'Money' WHERE [ModuleSystemName] = 'eCom_Pricing';
UPDATE [Module] SET [ModuleIconClass] = 'Search' WHERE [ModuleSystemName] = 'eCom_Search';
UPDATE [Module] SET [ModuleIconClass] = 'Search' WHERE [ModuleSystemName] = 'eCom_SearchExtended';
UPDATE [Module] SET [ModuleIconClass] = 'CircleO' WHERE [ModuleSystemName] = 'eCom_Units';
UPDATE [Module] SET [ModuleIconClass] = 'AssignmentTurnedIn' WHERE [ModuleSystemName] = 'eCom_Quotes';
UPDATE [Module] SET [ModuleIconClass] = 'AvTimer' WHERE [ModuleSystemName] = 'eCom_RecurringOrders';
UPDATE [Module] SET [ModuleIconClass] = 'GroupWork' WHERE [ModuleSystemName] = 'eCom_Related';
UPDATE [Module] SET [ModuleIconClass] = 'Tag' WHERE [ModuleSystemName] = 'eCom_SalesDiscount';
UPDATE [Module] SET [ModuleIconClass] = 'Tag' WHERE [ModuleSystemName] = 'eCom_SalesDiscountExtended';
UPDATE [Module] SET [ModuleIconClass] = 'ShoppingCart' WHERE [ModuleSystemName] = 'eCom_CartV2';
UPDATE [Module] SET [ModuleIconClass] = 'PieChart' WHERE [ModuleSystemName] = 'eCom_Statistics';
UPDATE [Module] SET [ModuleIconClass] = 'HdrWeak' WHERE [ModuleSystemName] = 'eCom_Variants';
UPDATE [Module] SET [ModuleIconClass] = 'HdrWeak' WHERE [ModuleSystemName] = 'eCom_VariantsExtended';
UPDATE [Module] SET [ModuleIconClass] = 'Ticket' WHERE [ModuleSystemName] = 'eCom_Vouchers';
UPDATE [Module] SET [ModuleIconClass] = 'AccountBalanceWallet' WHERE [ModuleSystemName] = 'eCom_economic';
UPDATE [Module] SET [ModuleIconClass] = 'ImportExport' WHERE [ModuleSystemName] = 'eCom_DataIntegrationERPBatch';
UPDATE [Module] SET [ModuleIconClass] = 'ImportExport' WHERE [ModuleSystemName] = 'eCom_DataIntegrationERPLiveIntegration';
UPDATE [Module] SET [ModuleIconClass] = 'Tachometer' WHERE [ModuleSystemName] = 'SeoExpress';
UPDATE [Module] SET [ModuleIconClass] = 'Tasks' WHERE [ModuleSystemName] = 'DM_Form_Extended';
UPDATE [Module] SET [ModuleIconClass] = 'Person' WHERE [ModuleSystemName] = 'UserManagementBackendExtended';
4/28/2020 9:03:39 AM Package 2015 from updates.xml.aspx
4/28/2020 9:03:39 AM - error: 'DW_DF_Paragraph_BottomSpace' is not a constraint.
Could not drop constraint. See previous errors. - System.Data.SqlClient.SqlException (0x80131904): 'DW_DF_Paragraph_BottomSpace' is not a constraint.
Could not drop constraint. See previous errors.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Dynamicweb.Frontend.Update.ProcessDatabase(XmlNode& xmlNode)
ClientConnectionId:24a22f0b-47b6-4ec9-97a9-bd864ed7230c
Error Number:3728,State:1,Class:16
ClientConnectionId before routing:913390d9-762d-453d-a6b8-cfa7f45ae528
Routing Destination:ea107b5d8e20.tr2065.northeurope1-a.worker.database.windows.net,11103
4/28/2020 9:03:39 AM - error: 'DW_DF_Paragraph_ImageHAlign' is not a constraint.
Could not drop constraint. See previous errors. - System.Data.SqlClient.SqlException (0x80131904): 'DW_DF_Paragraph_ImageHAlign' is not a constraint.
Could not drop constraint. See previous errors.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Dynamicweb.Frontend.Update.ProcessDatabase(XmlNode& xmlNode)
ClientConnectionId:24a22f0b-47b6-4ec9-97a9-bd864ed7230c
Error Number:3728,State:1,Class:16
ClientConnectionId before routing:913390d9-762d-453d-a6b8-cfa7f45ae528
Routing Destination:ea107b5d8e20.tr2065.northeurope1-a.worker.database.windows.net,11103
4/28/2020 9:03:39 AM - error: 'DW_DF_Paragraph_ImageHSpace' is not a constraint.
Could not drop constraint. See previous errors. - System.Data.SqlClient.SqlException (0x80131904): 'DW_DF_Paragraph_ImageHSpace' is not a constraint.
Could not drop constraint. See previous errors.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Dynamicweb.Frontend.Update.ProcessDatabase(XmlNode& xmlNode)
ClientConnectionId:24a22f0b-47b6-4ec9-97a9-bd864ed7230c
Error Number:3728,State:1,Class:16
ClientConnectionId before routing:913390d9-762d-453d-a6b8-cfa7f45ae528
Routing Destination:ea107b5d8e20.tr2065.northeurope1-a.worker.database.windows.net,11103
4/28/2020 9:03:39 AM - error: 'DW_DF_Paragraph_ImageVAlign' is not a constraint.
Could not drop constraint. See previous errors. - System.Data.SqlClient.SqlException (0x80131904): 'DW_DF_Paragraph_ImageVAlign' is not a constraint.
Could not drop constraint. See previous errors.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Dynamicweb.Frontend.Update.ProcessDatabase(XmlNode& xmlNode)
ClientConnectionId:24a22f0b-47b6-4ec9-97a9-bd864ed7230c
Error Number:3728,State:1,Class:16
ClientConnectionId before routing:913390d9-762d-453d-a6b8-cfa7f45ae528
Routing Destination:ea107b5d8e20.tr2065.northeurope1-a.worker.database.windows.net,11103
4/28/2020 9:03:39 AM - error: 'DW_DF_Paragraph_ImageVSpace' is not a constraint.
Could not drop constraint. See previous errors. - System.Data.SqlClient.SqlException (0x80131904): 'DW_DF_Paragraph_ImageVSpace' is not a constraint.
Could not drop constraint. See previous errors.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Dynamicweb.Frontend.Update.ProcessDatabase(XmlNode& xmlNode)
ClientConnectionId:24a22f0b-47b6-4ec9-97a9-bd864ed7230c
Error Number:3728,State:1,Class:16
ClientConnectionId before routing:913390d9-762d-453d-a6b8-cfa7f45ae528
Routing Destination:ea107b5d8e20.tr2065.northeurope1-a.worker.database.windows.net,11103
4/28/2020 9:03:39 AM Package 2016 from updates.xml.aspx
4/28/2020 9:03:39 AM Setting /Globalsettings/Settings/Updates/DisableTemplateUpdates has received a value "False".
4/28/2020 9:03:39 AM Setting /Globalsettings/Settings/CustomerAccess/ShowAreabox has received a value "True".
4/28/2020 9:03:40 AM Setting /Globalsettings/Settings/CustomerAccess/LockNavigationFolder has received a value "False".
4/28/2020 9:03:40 AM Setting /Globalsettings/Modules/ImportExport/checkToken has received a value "True".
4/28/2020 9:03:40 AM Package 2017 from updates.xml.aspx
4/28/2020 9:03:40 AM Standard SQL applied.
UPDATE [Module] SET [ModuleScript] = NULL WHERE [ModuleSystemName] = 'Workflow';
4/28/2020 9:03:40 AM Package 2018 from updates.xml.aspx
4/28/2020 9:03:40 AM Standard SQL applied.
IF (SELECT COUNT(*) FROM [Module] WHERE [ModuleSystemName] = 'UserManagementFrontend') > 0
DELETE FROM [Module] WHERE ModuleSystemName = 'UserManagementFrontendExtended';
Else
IF (SELECT COUNT(*) FROM [Module] WHERE [ModuleSystemName] = 'UserManagementFrontendExtended') > 0
UPDATE [Module] SET [ModuleSystemName] = 'UserManagementFrontend' WHERE [ModuleSystemName] = 'UserManagementFrontendExtended';
UPDATE [Module] SET [ModuleParagraphEditPath] = '/Admin/Module/UserManagement', [ModuleIconClass] = 'Lock' WHERE [ModuleSystemName] = 'UserManagementFrontend';
UPDATE [Paragraph] SET [ParagraphModuleSystemName] = 'UserManagementFrontend' WHERE [ParagraphModuleSystemName] = 'UserManagementFrontendExtended';
4/28/2020 9:03:40 AM Package 2019 from updates.xml.aspx
4/28/2020 9:03:40 AM Standard SQL applied.
DELETE FROM [EcomRecurringOrder] WHERE [RecurringOrderInterval] = 0
4/28/2020 9:03:40 AM Package 2020 from updates.xml.aspx
4/28/2020 9:03:40 AM Setting /Globalsettings/Settings/CustomerAccess/LockAccessToItems has received a value "True".
4/28/2020 9:03:40 AM Package 2021 from updates.xml.aspx
4/28/2020 9:03:40 AM Package 2022 from updates.xml.aspx
4/28/2020 9:03:40 AM Standard SQL applied.
UPDATE [Module] SET ModuleParagraph = 1 WHERE ModuleSystemName = 'UserManagementFrontend'
4/28/2020 9:03:40 AM Package 2023 from updates.xml.aspx
4/28/2020 9:03:40 AM Package 2024 from updates.xml.aspx
4/28/2020 9:03:40 AM - error: Column names in each table must be unique. Column name 'AccessUserAddressTitle' in table 'AccessUser' is specified more than once. - System.Data.SqlClient.SqlException (0x80131904): Column names in each table must be unique. Column name 'AccessUserAddressTitle' in table 'AccessUser' is specified more than once.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Dynamicweb.Frontend.Update.ProcessDatabase(XmlNode& xmlNode)
ClientConnectionId:24a22f0b-47b6-4ec9-97a9-bd864ed7230c
Error Number:2705,State:4,Class:16
ClientConnectionId before routing:913390d9-762d-453d-a6b8-cfa7f45ae528
Routing Destination:ea107b5d8e20.tr2065.northeurope1-a.worker.database.windows.net,11103
4/28/2020 9:03:40 AM Package 2025 from updates.xml.aspx
4/28/2020 9:03:40 AM - error: The operation failed because an index or statistics with name 'DW_IX_FormSubmitDataSubmitID' already exists on table 'FormSubmitData'. - System.Data.SqlClient.SqlException (0x80131904): The operation failed because an index or statistics with name 'DW_IX_FormSubmitDataSubmitID' already exists on table 'FormSubmitData'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Dynamicweb.Frontend.Update.ProcessDatabase(XmlNode& xmlNode)
ClientConnectionId:24a22f0b-47b6-4ec9-97a9-bd864ed7230c
Error Number:1913,State:1,Class:16
ClientConnectionId before routing:913390d9-762d-453d-a6b8-cfa7f45ae528
Routing Destination:ea107b5d8e20.tr2065.northeurope1-a.worker.database.windows.net,11103
4/28/2020 9:03:40 AM - error: The operation failed because an index or statistics with name 'DW_IX_FormSubmitFormID' already exists on table 'FormSubmit'. - System.Data.SqlClient.SqlException (0x80131904): The operation failed because an index or statistics with name 'DW_IX_FormSubmitFormID' already exists on table 'FormSubmit'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Dynamicweb.Frontend.Update.ProcessDatabase(XmlNode& xmlNode)
ClientConnectionId:24a22f0b-47b6-4ec9-97a9-bd864ed7230c
Error Number:1913,State:1,Class:16
ClientConnectionId before routing:913390d9-762d-453d-a6b8-cfa7f45ae528
Routing Destination:ea107b5d8e20.tr2065.northeurope1-a.worker.database.windows.net,11103
4/28/2020 9:03:40 AM - error: The operation failed because an index or statistics with name 'DW_IX_FormSubmitDate' already exists on table 'FormSubmit'. - System.Data.SqlClient.SqlException (0x80131904): The operation failed because an index or statistics with name 'DW_IX_FormSubmitDate' already exists on table 'FormSubmit'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Dynamicweb.Frontend.Update.ProcessDatabase(XmlNode& xmlNode)
ClientConnectionId:24a22f0b-47b6-4ec9-97a9-bd864ed7230c
Error Number:1913,State:1,Class:16
ClientConnectionId before routing:913390d9-762d-453d-a6b8-cfa7f45ae528
Routing Destination:ea107b5d8e20.tr2065.northeurope1-a.worker.database.windows.net,11103
4/28/2020 9:03:40 AM Package 2026 from updates.xml.aspx
4/28/2020 9:03:40 AM Standard SQL applied.
UPDATE [ScheduledTask] SET [TaskNamespace] = 'Dynamicweb.Indexing.Repositories.Tasks' WHERE [TaskNamespace] = 'Dynamicweb.Repositories.Tasks';
4/28/2020 9:03:40 AM Package 2027 from updates.xml.aspx
4/28/2020 9:03:40 AM - error: Column names in each table must be unique. Column name 'EmailName' in table 'EmailMarketingEmail' is specified more than once. - System.Data.SqlClient.SqlException (0x80131904): Column names in each table must be unique. Column name 'EmailName' in table 'EmailMarketingEmail' is specified more than once.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Dynamicweb.Frontend.Update.ProcessDatabase(XmlNode& xmlNode)
ClientConnectionId:24a22f0b-47b6-4ec9-97a9-bd864ed7230c
Error Number:2705,State:4,Class:16
ClientConnectionId before routing:913390d9-762d-453d-a6b8-cfa7f45ae528
Routing Destination:ea107b5d8e20.tr2065.northeurope1-a.worker.database.windows.net,11103
4/28/2020 9:03:40 AM Package 2028 from updates.xml.aspx
4/28/2020 9:03:40 AM Package 2029 from updates.xml.aspx
4/28/2020 9:03:40 AM Package 2030 from updates.xml.aspx
4/28/2020 9:03:40 AM - error: The operation failed because an index or statistics with name 'DW_IX_ItemListRelation_ListId' already exists on table 'ItemListRelation'. - System.Data.SqlClient.SqlException (0x80131904): The operation failed because an index or statistics with name 'DW_IX_ItemListRelation_ListId' already exists on table 'ItemListRelation'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Dynamicweb.Frontend.Update.ProcessDatabase(XmlNode& xmlNode)
ClientConnectionId:24a22f0b-47b6-4ec9-97a9-bd864ed7230c
Error Number:1913,State:1,Class:16
ClientConnectionId before routing:913390d9-762d-453d-a6b8-cfa7f45ae528
Routing Destination:ea107b5d8e20.tr2065.northeurope1-a.worker.database.windows.net,11103
4/28/2020 9:03:40 AM - error: The operation failed because an index or statistics with name 'DW_IX_ItemListRelation_ItemId' already exists on table 'ItemListRelation'. - System.Data.SqlClient.SqlException (0x80131904): The operation failed because an index or statistics with name 'DW_IX_ItemListRelation_ItemId' already exists on table 'ItemListRelation'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Dynamicweb.Frontend.Update.ProcessDatabase(XmlNode& xmlNode)
ClientConnectionId:24a22f0b-47b6-4ec9-97a9-bd864ed7230c
Error Number:1913,State:1,Class:16
ClientConnectionId before routing:913390d9-762d-453d-a6b8-cfa7f45ae528
Routing Destination:ea107b5d8e20.tr2065.northeurope1-a.worker.database.windows.net,11103
4/28/2020 9:03:40 AM Package 2031 from updates.xml.aspx
4/28/2020 9:03:40 AM Setting /Globalsettings/Settings/Dictionary/DisableTranslationMarksForAngel already exists.
4/28/2020 9:03:40 AM Package 2032 from updates.xml.aspx
4/28/2020 9:03:40 AM Folder D:\home\site\wwwroot\Dynamicweb\Solution\Templates\ExtranetExtended does not exist - creating.
4/28/2020 9:03:40 AM file D:\home\site\wwwroot\Dynamicweb\Applications\Application(9.8.5)\Admin\Update\\Files\Templates\ExtranetExtended\Extranet_SendPasswordRecoveryEmail.html added.
4/28/2020 9:03:40 AM Setting /Globalsettings/Modules/UserManagement/ExtranetPasswordSecurity/RecoveryTokenTimeout already exists.
4/28/2020 9:03:40 AM Package 2033 from updates.xml.aspx
4/28/2020 9:03:40 AM Standard SQL applied.
UPDATE [ScheduledTask]
SET [TaskAssembly] = 'Dynamicweb.EmailMarketing, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null', [TaskNamespace] = 'Dynamicweb.EmailMarketing'
WHERE [TaskNamespace] = 'Dynamicweb.Modules.EmailMarketing';
4/28/2020 9:03:40 AM Package 2034 from updates.xml.aspx
4/28/2020 9:03:40 AM Folder D:\home\site\wwwroot\Dynamicweb\Solution\System\Integration\Jobs\ModuleSpecificJobs\UserManagementModuleJobs\ExportJobs does not exist - creating.
4/28/2020 9:03:40 AM file D:\home\site\wwwroot\Dynamicweb\Applications\Application(9.8.5)\Admin\Update\\Files\System\Integration\Jobs\ModuleSpecificJobs\UserManagementModuleJobs\ExportJobs\ExportUsers.xml added.
4/28/2020 9:03:40 AM Package 2035 from updates.xml.aspx
4/28/2020 9:03:40 AM - error: There is already an object named 'Dashboard' in the database. - System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'Dashboard' in the database.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Dynamicweb.Frontend.Update.ProcessDatabase(XmlNode& xmlNode)
ClientConnectionId:24a22f0b-47b6-4ec9-97a9-bd864ed7230c
Error Number:2714,State:6,Class:16
ClientConnectionId before routing:913390d9-762d-453d-a6b8-cfa7f45ae528
Routing Destination:ea107b5d8e20.tr2065.northeurope1-a.worker.database.windows.net,11103
4/28/2020 9:03:40 AM - error: There is already an object named 'DashboardWidget' in the database. - System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DashboardWidget' in the database.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Dynamicweb.Frontend.Update.ProcessDatabase(XmlNode& xmlNode)
ClientConnectionId:24a22f0b-47b6-4ec9-97a9-bd864ed7230c
Error Number:2714,State:6,Class:16
ClientConnectionId before routing:913390d9-762d-453d-a6b8-cfa7f45ae528
Routing Destination:ea107b5d8e20.tr2065.northeurope1-a.worker.database.windows.net,11103
4/28/2020 9:03:40 AM Package 2036 from updates.xml.aspx
4/28/2020 9:03:40 AM Conditional present - escaping.
4/28/2020 9:03:40 AM Package 2037 from updates.xml.aspx
4/28/2020 9:03:40 AM Conditional present - escaping.
4/28/2020 9:03:40 AM Package 2038 from updates.xml.aspx
4/28/2020 9:03:40 AM Conditional present - escaping.
4/28/2020 9:03:40 AM Package 2039 from updates.xml.aspx
4/28/2020 9:03:40 AM Conditional present - escaping.
4/28/2020 9:03:40 AM Package 2040 from updates.xml.aspx
4/28/2020 9:03:40 AM file D:\home\site\wwwroot\Dynamicweb\Solution\Templates\eCom\CustomerCenter\MyListDetails.html already exists.
4/28/2020 9:03:40 AM Package 2041 from updates.xml.aspx
4/28/2020 9:03:40 AM Conditional present - escaping.
4/28/2020 9:03:40 AM Package 2042 from updates.xml.aspx
4/28/2020 9:03:40 AM Conditional present - escaping.
4/28/2020 9:03:40 AM Conditional present - escaping.
4/28/2020 9:03:40 AM Conditional present - escaping.
4/28/2020 9:03:40 AM Package 2043 from updates.xml.aspx
4/28/2020 9:03:40 AM Standard SQL applied.
ALTER TABLE [RecycleBin] ALTER COLUMN [RecycleBinDeletedAt] [datetime] not null
4/28/2020 9:03:40 AM Package 2044 from updates.xml.aspx
4/28/2020 9:03:40 AM Conditional present - escaping.
4/28/2020 9:03:41 AM Conditional present - escaping.
4/28/2020 9:03:41 AM Conditional present - escaping.
4/28/2020 9:03:41 AM Package 2045 from updates.xml.aspx
4/28/2020 9:03:41 AM Package 2046 from updates.xml.aspx
4/28/2020 9:03:41 AM Setting /Globalsettings/ItemTypes/GoogleFontApiKey already exists.
4/28/2020 9:03:41 AM Package 2047 from updates.xml.aspx
4/28/2020 9:03:41 AM file D:\home\site\wwwroot\Dynamicweb\Solution\Templates\Filepublish\FilepublishList.cshtml already exists.
4/28/2020 9:03:41 AM Package 2048 from updates.xml.aspx
4/28/2020 9:03:41 AM Standard SQL applied.
UPDATE [Module] SET [ModuleParagraph] = 1 WHERE [ModuleSystemName] = 'eCom_ShowList'
4/28/2020 9:03:41 AM Package 2049 from updates.xml.aspx
4/28/2020 9:03:41 AM - error: Column names in each table must be unique. Column name 'PageDisplayMode' in table 'Page' is specified more than once. - System.Data.SqlClient.SqlException (0x80131904): Column names in each table must be unique. Column name 'PageDisplayMode' in table 'Page' is specified more than once.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Dynamicweb.Frontend.Update.ProcessDatabase(XmlNode& xmlNode)
ClientConnectionId:24a22f0b-47b6-4ec9-97a9-bd864ed7230c
Error Number:2705,State:4,Class:16
ClientConnectionId before routing:913390d9-762d-453d-a6b8-cfa7f45ae528
Routing Destination:ea107b5d8e20.tr2065.northeurope1-a.worker.database.windows.net,11103
4/28/2020 9:03:41 AM Package 2050 from updates.xml.aspx
4/28/2020 9:03:41 AM Conditional present - escaping.
4/28/2020 9:03:41 AM Package 2051 from updates.xml.aspx
4/28/2020 9:03:41 AM Conditional present - escaping.
4/28/2020 9:03:41 AM Package 2052 from updates.xml.aspx
4/28/2020 9:03:41 AM Conditional present - escaping.
4/28/2020 9:03:41 AM Package 2053 from updates.xml.aspx
4/28/2020 9:03:41 AM Package 2054 from updates.xml.aspx
4/28/2020 9:03:41 AM Package 2055 from updates.xml.aspx
4/28/2020 9:03:41 AM Package 2056 from updates.xml.aspx
4/28/2020 9:03:41 AM - error: Invalid column name 'ModuleDeprecated'. - System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'ModuleDeprecated'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Dynamicweb.Frontend.Update.ProcessDatabase(XmlNode& xmlNode)
ClientConnectionId:24a22f0b-47b6-4ec9-97a9-bd864ed7230c
Error Number:207,State:1,Class:16
ClientConnectionId before routing:913390d9-762d-453d-a6b8-cfa7f45ae528
Routing Destination:ea107b5d8e20.tr2065.northeurope1-a.worker.database.windows.net,11103
4/28/2020 9:03:41 AM Package 2057 from updates.xml.aspx
4/28/2020 9:03:41 AM Standard SQL applied.
ALTER TABLE [VersionData] ALTER COLUMN [VersionDataType] nvarchar(255) NULL
4/28/2020 9:03:41 AM Package 2058 from updates.xml.aspx
4/28/2020 9:03:41 AM Package 2059 from updates.xml.aspx
4/28/2020 9:03:41 AM Folder D:\home\site\wwwroot\Dynamicweb\Solution\Templates\ExtranetExtended does not exist - creating.
4/28/2020 9:03:41 AM file D:\home\site\wwwroot\Dynamicweb\Applications\Application(9.8.5)\Admin\Update\\Files\Templates\ExtranetExtended\Extranet_SendInfo.html added.
4/28/2020 9:03:41 AM Package 2060 from updates.xml.aspx
4/28/2020 9:03:41 AM Conditional present - escaping.
4/28/2020 9:03:41 AM Package 2061 from updates.xml.aspx
4/28/2020 9:03:41 AM Conditional present - escaping.
4/28/2020 9:03:41 AM Conditional present - escaping.
4/28/2020 9:03:41 AM Conditional present - escaping.
4/28/2020 9:03:41 AM Conditional present - escaping.
4/28/2020 9:03:41 AM Conditional present - escaping.
4/28/2020 9:03:41 AM Package 2062 from updates.xml.aspx
4/28/2020 9:03:41 AM - error: Multiple NULL constraints were specified for column 'TaskStartFromLastRun', table 'Task'. - System.Data.SqlClient.SqlException (0x80131904): Multiple NULL constraints were specified for column 'TaskStartFromLastRun', table 'Task'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Dynamicweb.Frontend.Update.ProcessDatabase(XmlNode& xmlNode)
ClientConnectionId:24a22f0b-47b6-4ec9-97a9-bd864ed7230c
Error Number:8150,State:0,Class:16
ClientConnectionId before routing:913390d9-762d-453d-a6b8-cfa7f45ae528
Routing Destination:ea107b5d8e20.tr2065.northeurope1-a.worker.database.windows.net,11103
4/28/2020 9:03:41 AM Package 2063 from updates.xml.aspx
4/28/2020 9:03:41 AM Conditional present - escaping.
4/28/2020 9:03:41 AM Package 2064 from updates.xml.aspx
4/28/2020 9:03:41 AM Conditional present - escaping.
4/28/2020 9:03:41 AM Package 2065 from updates.xml.aspx
4/28/2020 9:03:41 AM Folder D:\home\site\wwwroot\Dynamicweb\Solution\Templates\Searchv1 does not exist - creating.
4/28/2020 9:03:41 AM file D:\home\site\wwwroot\Dynamicweb\Applications\Application(9.8.5)\Admin\Update\\Files\Templates\Searchv1\SearchResultItem.html added.
4/28/2020 9:03:41 AM Package 2066 from updates.xml.aspx
4/28/2020 9:03:41 AM Setting /Globalsettings/Ecom/EconomicIntegration/Credentials/DynamicwebAppPublicToken already exists.
4/28/2020 9:03:41 AM Setting /Globalsettings/Ecom/EconomicIntegration/Credentials/DynamicwebAppSecretToken already exists.
4/28/2020 9:03:41 AM Package 2067 from updates.xml.aspx
4/28/2020 9:03:41 AM Conditional present - escaping.
4/28/2020 9:03:41 AM Package 2068 from updates.xml.aspx
4/28/2020 9:03:41 AM Standard SQL applied.
IF EXISTS (SELECT * FROM sys.indexes WHERE name = N'DW_IX_UnifiedPermission_Key_Name')
DROP INDEX DW_IX_UnifiedPermission_Key_Name ON UnifiedPermission;
IF EXISTS (SELECT * FROM sys.indexes WHERE name = N'DW_IX_UnifiedPermission_UserId_Key_Name')
DROP INDEX DW_IX_UnifiedPermission_UserId_Key_Name ON UnifiedPermission;
IF EXISTS (SELECT * FROM sys.indexes WHERE name = N'DW_IX_UnifiedPermission_UserId_Key_Name_SubName')
DROP INDEX DW_IX_UnifiedPermission_UserId_Key_Name_SubName ON UnifiedPermission;
4/28/2020 9:03:41 AM Standard SQL applied.
ALTER TABLE [UnifiedPermission] ALTER COLUMN [PermissionUserId] NVARCHAR(50) NULL;
ALTER TABLE [UnifiedPermission] ALTER COLUMN [PermissionKey] NVARCHAR(255) NULL;
ALTER TABLE [UnifiedPermission] ALTER COLUMN [PermissionName] NVARCHAR(100) NULL;
ALTER TABLE [UnifiedPermission] ALTER COLUMN [PermissionSubName] NVARCHAR(100) NULL;
CREATE NONCLUSTERED INDEX [DW_IX_UnifiedPermission_Key_Name] ON [UnifiedPermission]
(
[PermissionKey] ASC,
[PermissionName] ASC
)
CREATE NONCLUSTERED INDEX [DW_IX_UnifiedPermission_UserId_Key_Name_SubName] ON [UnifiedPermission]
(
[PermissionUserId] ASC,
[PermissionKey] ASC,
[PermissionName] ASC,
[PermissionSubName] ASC
) INCLUDE ([PermissionLevel])
4/28/2020 9:03:41 AM Package 2069 from updates.xml.aspx
4/28/2020 9:03:41 AM Conditional present - escaping.
4/28/2020 9:03:42 AM Conditional present - escaping.
4/28/2020 9:03:42 AM Package 2070 from updates.xml.aspx
4/28/2020 9:03:42 AM Conditional present - escaping.
4/28/2020 9:03:42 AM Package 2071 from updates.xml.aspx
4/28/2020 9:03:42 AM Standard SQL applied.
UPDATE [Module] SET [ModuleParagraphEditPath] = '/Admin/Module/DataProcessing/Default.aspx' WHERE [ModuleSystemName] = 'DataProcessing';
4/28/2020 9:03:42 AM Package 2072 from updates.xml.aspx
4/28/2020 9:03:42 AM Conditional present - escaping.
4/28/2020 9:03:42 AM Package 2073 from updates.xml.aspx
4/28/2020 9:03:42 AM Conditional present - escaping.
4/28/2020 9:03:42 AM Conditional present - escaping.
4/28/2020 9:03:42 AM Conditional present - escaping.
4/28/2020 9:03:42 AM Conditional present - escaping.
4/28/2020 9:03:42 AM Conditional present - escaping.
4/28/2020 9:03:42 AM Conditional present - escaping.
4/28/2020 9:03:42 AM Package 2074 from updates.xml.aspx
4/28/2020 9:03:42 AM Conditional present - escaping.
4/28/2020 9:03:42 AM Package 2075 from updates.xml.aspx
4/28/2020 9:03:42 AM file D:\home\site\wwwroot\Dynamicweb\Solution\Templates\DataPortability\Form\Form.cshtml already exists.
4/28/2020 9:03:42 AM Package 2076 from updates.xml.aspx
4/28/2020 9:03:42 AM file D:\home\site\wwwroot\Dynamicweb\Solution\System\DataPortability\Definitions\Default.xml already exists.
4/28/2020 9:03:42 AM Package 2077 from updates.xml.aspx
4/28/2020 9:03:42 AM Conditional present - escaping.
4/28/2020 9:03:42 AM Package 2078 from updates.xml.aspx
4/28/2020 9:03:42 AM file D:\home\site\wwwroot\Dynamicweb\Solution\Templates\CookieWarning\ModalDialogWarning_Categories.html already exists.
4/28/2020 9:03:42 AM Package 2079 from updates.xml.aspx
4/28/2020 9:03:42 AM Conditional present - escaping.
4/28/2020 9:03:42 AM Conditional present - escaping.
4/28/2020 9:03:42 AM Package 2080 from updates.xml.aspx
4/28/2020 9:03:42 AM file D:\home\site\wwwroot\Dynamicweb\Solution\Templates\eCom\ProductCatalog\ProductViewList.cshtml already exists.
4/28/2020 9:03:42 AM Package 2081 from updates.xml.aspx
4/28/2020 9:03:42 AM file D:\home\site\wwwroot\Dynamicweb\Solution\Templates\eCom\ProductCatalog\ProductViewDetail.cshtml already exists.
4/28/2020 9:03:42 AM Package 2082 from updates.xml.aspx
4/28/2020 9:03:42 AM Package 2083 from updates.xml.aspx
4/28/2020 9:03:42 AM file D:\home\site\wwwroot\Dynamicweb\Solution\Templates\Feeds\Amazon Images.cshtml already exists.
4/28/2020 9:03:42 AM file D:\home\site\wwwroot\Dynamicweb\Solution\Templates\Feeds\Amazon Inventory.cshtml already exists.
4/28/2020 9:03:42 AM file D:\home\site\wwwroot\Dynamicweb\Solution\Templates\Feeds\Amazon Prices.cshtml already exists.
4/28/2020 9:03:42 AM file D:\home\site\wwwroot\Dynamicweb\Solution\Templates\Feeds\Amazon Products.cshtml already exists.
4/28/2020 9:03:42 AM Package 2084 from updates.xml.aspx
4/28/2020 9:03:42 AM Package 2085 from updates.xml.aspx
4/28/2020 9:03:53 AM Package 2086 from updates.xml.aspx
4/28/2020 9:03:53 AM Conditional present - escaping.
4/28/2020 9:03:53 AM Conditional present - escaping.
4/28/2020 9:03:53 AM Package 2087 from updates.xml.aspx
4/28/2020 9:03:53 AM Conditional present - escaping.
4/28/2020 9:03:53 AM Package 2088 from updates.xml.aspx
4/28/2020 9:03:53 AM Conditional present - escaping.
4/28/2020 9:03:53 AM Package 2089 from updates.xml.aspx
4/28/2020 9:03:53 AM Standard SQL applied.
UPDATE [Module] SET [ModuleScript] = 'DataPortability/Default.aspx' WHERE [ModuleSystemName] = 'DataPortability';
4/28/2020 9:03:53 AM Package 2090 from updates.xml.aspx
4/28/2020 9:03:53 AM file D:\home\site\wwwroot\Dynamicweb\Solution\Templates\eCom\ProductCatalog\ProductViewListFacets.cshtml already exists.
4/28/2020 9:03:53 AM Package 2091 from updates.xml.aspx
4/28/2020 9:03:53 AM Standard SQL applied.
UPDATE [Module] SET [ModuleIconClass] = 'SwitchCamera' WHERE [ModuleSystemName] = 'DataPortability';
4/28/2020 9:03:53 AM Package 2092 from updates.xml.aspx
4/28/2020 9:03:53 AM Setting /Globalsettings/Settings/Auditing/EnableAuditing already exists.
4/28/2020 9:03:53 AM Package 2093 from updates.xml.aspx
4/28/2020 9:03:53 AM Conditional present - escaping.
4/28/2020 9:03:53 AM Package 2094 from updates.xml.aspx
4/28/2020 9:03:53 AM Conditional present - escaping.
4/28/2020 9:03:53 AM Conditional present - escaping.
4/28/2020 9:03:53 AM Conditional present - escaping.
4/28/2020 9:03:53 AM Package 2095 from updates.xml.aspx
4/28/2020 9:03:53 AM Setting /Globalsettings/System/Tracking/TableTimeInterval already exists.
4/28/2020 9:03:53 AM Setting /Globalsettings/System/Tracking/EnableTracking already exists.
4/28/2020 9:03:53 AM Setting /Globalsettings/System/Tracking/EnableLogging already exists.
4/28/2020 9:03:53 AM Package 2096 from updates.xml.aspx
4/28/2020 9:03:53 AM Package 2097 from updates.xml.aspx
4/28/2020 9:03:53 AM Conditional present - escaping.
4/28/2020 9:03:53 AM Package 2098 from updates.xml.aspx
4/28/2020 9:03:53 AM file D:\home\site\wwwroot\Dynamicweb\Solution\Templates\Filepublish\FilepublishList.cshtml already exists.
4/28/2020 9:03:53 AM Package 2099 from updates.xml.aspx
4/28/2020 9:03:53 AM Conditional present - escaping.
4/28/2020 9:03:53 AM Package 2100 from updates.xml.aspx
4/28/2020 9:03:53 AM Conditional present - escaping.
4/28/2020 9:03:53 AM Package 2101 from updates.xml.aspx
4/28/2020 9:03:53 AM Conditional present - escaping.
4/28/2020 9:03:53 AM Package 2102 from updates.xml.aspx
4/28/2020 9:03:53 AM Conditional present - escaping.
4/28/2020 9:03:53 AM Package 2103 from updates.xml.aspx
4/28/2020 9:03:53 AM Conditional present - escaping.
4/28/2020 9:03:53 AM Conditional present - escaping.
4/28/2020 9:03:53 AM Conditional present - escaping.
4/28/2020 9:03:53 AM Package 2104 from updates.xml.aspx
4/28/2020 9:03:53 AM file D:\home\site\wwwroot\Dynamicweb\Solution\System\BulkDataEdit\BasicForms.xml already exists.
4/28/2020 9:03:53 AM file D:\home\site\wwwroot\Dynamicweb\Solution\System\BulkDataEdit\DM_Form.xml already exists.
4/28/2020 9:03:53 AM file D:\home\site\wwwroot\Dynamicweb\Solution\System\BulkDataEdit\eCom_CartV2.xml already exists.
4/28/2020 9:03:53 AM file D:\home\site\wwwroot\Dynamicweb\Solution\System\BulkDataEdit\eCom_Catalog.xml already exists.
4/28/2020 9:03:53 AM file D:\home\site\wwwroot\Dynamicweb\Solution\System\BulkDataEdit\eCom_CustomerCenter.xml already exists.
4/28/2020 9:03:53 AM file D:\home\site\wwwroot\Dynamicweb\Solution\System\BulkDataEdit\UserManagementFrontend.xml already exists.
4/28/2020 9:03:53 AM file D:\home\site\wwwroot\Dynamicweb\Solution\System\BulkDataEdit\UserManagementFrontendExtended.xml already exists.
4/28/2020 9:03:53 AM Package 2105 from updates.xml.aspx
4/28/2020 9:03:53 AM Conditional present - escaping.
4/28/2020 9:03:54 AM Conditional present - escaping.
4/28/2020 9:03:54 AM Package 2106 from updates.xml.aspx
4/28/2020 9:03:54 AM Standard SQL applied.
UPDATE [Module] SET [ModuleAccess] = 1 WHERE [ModuleSystemName] = 'QueryPublisher'
4/28/2020 9:03:54 AM Package 2107 from updates.xml.aspx
4/28/2020 9:03:54 AM Conditional present - escaping.
4/28/2020 9:03:54 AM Conditional present - escaping.
4/28/2020 9:03:54 AM Package 2108 from updates.xml.aspx
4/28/2020 9:03:54 AM Conditional present - escaping.
4/28/2020 9:03:54 AM Conditional present - escaping.
4/28/2020 9:03:54 AM Package 2109 from updates.xml.aspx
4/28/2020 9:03:54 AM Conditional present - escaping.
4/28/2020 9:03:54 AM Package 2110 from updates.xml.aspx
4/28/2020 9:03:54 AM Package 2111 from updates.xml.aspx
4/28/2020 9:03:54 AM Package 2112 from updates.xml.aspx
4/28/2020 9:03:54 AM Package 2113 from updates.xml.aspx
4/28/2020 9:03:54 AM Conditional present - escaping.
4/28/2020 9:03:54 AM Package 2114 from updates.xml.aspx
4/28/2020 9:03:54 AM Package 2115 from updates.xml.aspx
4/28/2020 9:03:54 AM - error: Column names in each table must be unique. Column name 'AreaNofollow' in table 'Area' is specified more than once. - System.Data.SqlClient.SqlException (0x80131904): Column names in each table must be unique. Column name 'AreaNofollow' in table 'Area' is specified more than once.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Dynamicweb.Frontend.Update.ProcessDatabase(XmlNode& xmlNode)
ClientConnectionId:24a22f0b-47b6-4ec9-97a9-bd864ed7230c
Error Number:2705,State:4,Class:16
ClientConnectionId before routing:913390d9-762d-453d-a6b8-cfa7f45ae528
Routing Destination:ea107b5d8e20.tr2065.northeurope1-a.worker.database.windows.net,11103
4/28/2020 9:03:54 AM - error: Column names in each table must be unique. Column name 'AreaNoindex' in table 'Area' is specified more than once. - System.Data.SqlClient.SqlException (0x80131904): Column names in each table must be unique. Column name 'AreaNoindex' in table 'Area' is specified more than once.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Dynamicweb.Frontend.Update.ProcessDatabase(XmlNode& xmlNode)
ClientConnectionId:24a22f0b-47b6-4ec9-97a9-bd864ed7230c
Error Number:2705,State:4,Class:16
ClientConnectionId before routing:913390d9-762d-453d-a6b8-cfa7f45ae528
Routing Destination:ea107b5d8e20.tr2065.northeurope1-a.worker.database.windows.net,11103
4/28/2020 9:03:54 AM Package 2116 from updates.xml.aspx
4/28/2020 9:03:54 AM Conditional present - escaping.
4/28/2020 9:03:54 AM Conditional present - escaping.
4/28/2020 9:03:54 AM Package 2117 from updates.xml.aspx
4/28/2020 9:03:54 AM Conditional present - escaping.
4/28/2020 9:03:54 AM Conditional present - escaping.
4/28/2020 9:03:54 AM Conditional present - escaping.
4/28/2020 9:03:54 AM Conditional present - escaping.
4/28/2020 9:03:54 AM Package 2118 from updates.xml.aspx
4/28/2020 9:03:54 AM Conditional present - escaping.
4/28/2020 9:03:54 AM Package 2119 from updates.xml.aspx
4/28/2020 9:03:54 AM Package 2120 from updates.xml.aspx
4/28/2020 9:03:54 AM Conditional present - escaping.
4/28/2020 9:03:54 AM Package 2121 from updates.xml.aspx
4/28/2020 9:03:54 AM file D:\home\site\wwwroot\Dynamicweb\Solution\System\OMC\Marketing reports\Visits\Acquisition\Visitors - Campaign.xml already exists.
4/28/2020 9:03:54 AM file D:\home\site\wwwroot\Dynamicweb\Solution\System\OMC\Marketing reports\Visits\Acquisition\Visitors - Referrer type.xml already exists.
4/28/2020 9:03:54 AM file D:\home\site\wwwroot\Dynamicweb\Solution\System\OMC\Marketing reports\Visits\Acquisition\Visitors - Referrer.xml already exists.
4/28/2020 9:03:54 AM file D:\home\site\wwwroot\Dynamicweb\Solution\System\OMC\Marketing reports\Visits\Behavior\Visitors - New vs Returning.xml already exists.
4/28/2020 9:03:54 AM file D:\home\site\wwwroot\Dynamicweb\Solution\System\OMC\Marketing reports\Visits\Geo\Visitors - Country.xml already exists.
4/28/2020 9:03:54 AM file D:\home\site\wwwroot\Dynamicweb\Solution\System\OMC\Marketing reports\Visits\Technology\Visitors - Device.xml already exists.
4/28/2020 9:03:54 AM file D:\home\site\wwwroot\Dynamicweb\Solution\System\OMC\Marketing reports\Visits\Overview\Visitors - Day.xml already exists.
4/28/2020 9:03:54 AM file D:\home\site\wwwroot\Dynamicweb\Solution\System\OMC\Marketing reports\Visits\Overview\Visitors - Time of day.xml already exists.
4/28/2020 9:03:54 AM file D:\home\site\wwwroot\Dynamicweb\Solution\System\OMC\Marketing reports\Visits\Overview\Visitors - Website.xml already exists.
4/28/2020 9:03:54 AM file D:\home\site\wwwroot\Dynamicweb\Solution\System\OMC\Marketing reports\Visits\Overview\Visitors - Year.xml already exists.
4/28/2020 9:03:54 AM Package 2122 from updates.xml.aspx
4/28/2020 9:03:54 AM Conditional present - escaping.
4/28/2020 9:03:54 AM Conditional present - escaping.
4/28/2020 9:03:54 AM Conditional present - escaping.
4/28/2020 9:03:54 AM Conditional present - escaping.
4/28/2020 9:03:54 AM Conditional present - escaping.
4/28/2020 9:03:54 AM Conditional present - escaping.
4/28/2020 9:03:54 AM Conditional present - escaping.
4/28/2020 9:03:54 AM Package 2123 from updates.xml.aspx
4/28/2020 9:03:54 AM Conditional present - escaping.
4/28/2020 9:03:54 AM Package 2124 from updates.xml.aspx
4/28/2020 9:03:54 AM Conditional present - escaping.
4/28/2020 9:03:54 AM Package 2125 from updates.xml.aspx
4/28/2020 9:03:54 AM Conditional present - escaping.
4/28/2020 9:03:54 AM Conditional present - escaping.
4/28/2020 9:03:54 AM Package 2126 from updates.xml.aspx
4/28/2020 9:03:54 AM Conditional present - escaping.
4/28/2020 9:03:54 AM Package 2127 from updates.xml.aspx
4/28/2020 9:03:54 AM file D:\home\site\wwwroot\Dynamicweb\Solution\System\OMC\Marketing reports\Visits\Behavior\Visitors - Most viewed pages.xml already exists.
4/28/2020 9:03:54 AM Package 2128 from updates.xml.aspx
4/28/2020 9:03:54 AM Conditional present - escaping.
4/28/2020 9:03:54 AM Conditional present - escaping.
4/28/2020 9:03:54 AM Conditional present - escaping.
4/28/2020 9:03:54 AM Package 2129 from updates.xml.aspx
4/28/2020 9:03:54 AM Conditional present - escaping.
4/28/2020 9:03:54 AM Conditional present - escaping.
4/28/2020 9:03:54 AM Package 2130 from updates.xml.aspx
4/28/2020 9:03:54 AM Conditional present - escaping.
4/28/2020 9:03:54 AM Package 2131 from updates.xml.aspx
4/28/2020 9:03:54 AM Conditional present - escaping.
4/28/2020 9:03:54 AM Package 2132 from updates.xml.aspx
4/28/2020 9:03:54 AM Conditional present - escaping.
4/28/2020 9:03:54 AM Conditional present - escaping.
4/28/2020 9:03:54 AM Conditional present - escaping.
4/28/2020 9:03:54 AM Conditional present - escaping.
4/28/2020 9:03:54 AM Package 2133 from updates.xml.aspx
4/28/2020 9:03:54 AM Conditional present - escaping.
4/28/2020 9:03:54 AM Package 2134 from updates.xml.aspx
4/28/2020 9:03:54 AM file D:\home\site\wwwroot\Dynamicweb\Solution\Templates\CookieWarning\ModalDialogWarning_Categories.cshtml already exists.
4/28/2020 9:03:55 AM Updates initialized