Description |
*Custer Grain*
Upgrading testT2 database error.
From 16.1.1003.392 to 17.1.0411.35
*Databse:
\\fileserver\Projects\i21Web\Databases\Custer Grain
*Southern Commodities*
Upgrading testTE
from 16.1.1003.392 to 17.1.0411.35
*Database
\\fileserver\Projects\i21Web\Databases\Southern Commodities
*Alabama Farmers TE*
Error SQL72014: .Net SqlClient Data Provider: Msg 2627, Level 14, State 1, Line 28 Violation of UNIQUE KEY constraint 'tmp_ms_xx_constraint_AK_tblTFReportingComponentProductCode1'. Cannot insert duplicate key in object 'dbo.tmp_ms_xx_tblTFReportingComponentProductCode'.
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_tblTFReportingComponentProductCode] (
[intReportingComponentProductCodeId] INT IDENTITY (1, 1) NOT NULL,
[intReportingComponentId] INT NOT NULL,
[intProductCodeId] INT NOT NULL,
[strType] NVARCHAR (50) COLLATE Latin1_General_CI_AS NULL,
[intConcurrencyId] INT DEFAULT ((1)) NULL,
CONSTRAINT [tmp_ms_xx_constraint_AK_tblTFReportingComponentProductCode1] UNIQUE NONCLUSTERED ([intReportingComponentId] ASC, [intProductCodeId] ASC),
CONSTRAINT [tmp_ms_xx_constraint_PK_tblTFReportingComponentProductCode1] PRIMARY KEY CLUSTERED ([intReportingComponentProductCodeId] ASC)
);
ALTER TABLE [dbo].[tmp_ms_xx_tblTFReportingComponentProductCode]
ADD CONSTRAINT [SD_tblTFReportingComponentProductCode_9aa5345fa40641c2b537935763ff2fff] DEFAULT 0 FOR [intR
|