Description |
Upgrade failed in 17.1.0615.53 into their Test coming from Live.
Here is the error in log.
Error SQL72014: .Net SqlClient Data Provider: Msg 547, Level 16, State 0, Line 255 The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_tblARInvoice_tblSMPaymentMethod_intPaymentMethodId". The conflict occurred in database "testT1", table "dbo.tblSMPaymentMethod", column 'intPaymentMethodID'.
Error SQL72045: Script execution error. The executed script:
ALTER TABLE [dbo].[tblAPBillDetail] WITH CHECK CHECK CONSTRAINT [FK_tblAPBillDetail_tblAPBill];
ALTER TABLE [dbo].[tblAPBill] WITH CHECK CHECK CONSTRAINT [FK_dbo.tblAPBill_dbo.tblEMEntity_intEntityId];
ALTER TABLE [dbo].[tblAPBill] WITH CHECK CHECK CONSTRAINT [FK_dbo.tblAPBill_dbo.tblEMEntityLocation_intShipFromId];
ALTER TABLE [dbo].[tblAPBill] WITH CHECK CHECK CONSTRAINT [FK_dbo.tblAPBill_dbo.tblSMCompanyLocation_intShipToId];
ALTER TABLE [dbo].[tblAPBill] WITH CHECK CHECK CONSTRAINT [FK_dbo.tblAPBill_dbo.tblGLAccount_intAccountId];
ALTER TABLE [dbo].[tblAPBill] WITH CHECK CHECK CONSTRAINT [FK_dbo.tblAPBill_dbo.tblAPBillBatch_intBillBatchId];
ALTER TABLE [dbo].[tblAPBill] WITH CHECK CHECK CONSTRAINT [FK_dbo.tblAPBill_dbo.tblSMTerm_intTermId];
ALTER TABLE [dbo].[tblAPBill] WITH CHECK CHECK CONSTRAINT [FK_dbo.tblAPBill_dbo.tblAPVendor_intVendorId];
ALTER TABLE [dbo].[tblAPBill] WITH CHECK CHECK CONSTRAINT [FK_dbo.tblAPBill_dbo.tblSMShipVia_intShipViaId];
ALTER TABLE [dbo].[tblAPBill
|