Description |
ISSUE:
I upgrading a copy of Fortbooks DB and this error is displaying on log
Error SQL72014: .Net SqlClient Data Provider: Msg 2627, Level 14, State 1, Line 64 Violation of UNIQUE KEY constraint 'tmp_ms_xx_constraint_UK_dbo.tblAPBill_strBillId'. Cannot insert duplicate key in object 'dbo.tmp_ms_xx_tblAPBill'. The duplicate key value is ().
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_tblAPBill] (
[intBillId] INT IDENTITY (1, 1) NOT NULL,
[intBillBatchId] INT NULL,
[strVendorOrderNumber] NVARCHAR (MAX) COLLATE Latin1_General_CI_AS NULL,
[intTermsId] INT DEFAULT 0 NOT NULL,
[intTaxId] INT NULL,
[dtmDate] DATETIME DEFAULT GETDATE() NOT NULL,
[dtmDueDate] DATETIME DEFAULT GETDATE() NOT NULL,
[intAccountId] INT DEFAULT 0 NOT NULL,
[strDescription] NVARCHAR (200) COLLATE Latin1_General_CI_AS NULL,
[strComment] NVARCHAR (200) COLLATE Latin1_General_CI_AS NULL,
[dblTotal] DECIMAL (18, 6) DEFAULT 0 NOT NULL,
[dblSubtotal] DECIMAL (18, 6) DEFAULT 0 NOT NULL,
[ysnPosted] BIT DEFAULT 0 NOT NULL,
[ysnPaid]
[~erick.delacruz] , please get a copy here.
D:\FTP Files\Liz\DB\FB\FOR 1440
Accepted:
Should update without error
|