Description |
Upgrading database from 16.2.0711.223 to 17.1.0420.44
database: testTE (copy 01 to te)
DATabase:
\\fileserver\Projects\i21Web\Databases\TriCountryFeeds
Log during error:
Error SQL72014: .Net SqlClient Data Provider: Msg 2627, Level 14, State 1, Line 24 Violation of UNIQUE KEY constraint 'tmp_ms_xx_constraint_AK_tblTFReportingComponentDestinationState1'. Cannot insert duplicate key in object 'dbo.tmp_ms_xx_tblTFReportingComponentDestinationState'. The duplicate key value is (0, 0).
Error SQL72045: Script execution error. The executed script:
BEGIN TRANSACTION;
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;
SET XACT_ABORT ON;
CREATE TABLE [dbo].[tmp_ms_xx_tblTFReportingComponentDestinationState] (
[intReportingComponentDestinationStateId] INT IDENTITY (1, 1) NOT NULL,
[intReportingComponentId] INT NOT NULL,
[intOriginDestinationStateId] INT NOT NULL,
[strType] NVARCHAR (50) COLLATE Latin1_General_CI_AS NULL,
[intConcurrencyId] INT DEFAULT ((1)) NULL,
CONSTRAINT [tmp_ms_xx_constraint_AK_tblTFReportingComponentDestinationState1] UNIQUE NONCLUSTERED ([intReportingComponentId] ASC, [intOriginDestinationStateId] ASC),
CONSTRAINT [tmp_ms_xx_constraint_PK_tblTFReportingComponentDestinationState1] PRIMARY KEY CLUSTERED ([intReportingComponentDestinationStateId] ASC)
);
ALTER TABLE [dbo].[tmp_ms_xx_tblTFReportingComponentDestinationState]
ADD CONSTRAINT [SD_tblTFReportingComponentDest
|