| Description |
Upgrading database from 16.4.0105.129 to 17.1.0420.44.
database:
\\fileserver\Projects\i21Web\Databases\CentralOhioFarmers
Logs:
Error SQL72014: .Net SqlClient Data Provider: Msg 547, Level 16, State 0, Line 2625 The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_tblTFTransaction_tblTFProductCode". The conflict occurred in database "testTE", table "dbo.tblTFProductCode", column 'intProductCodeId'.
Error SQL72045: Script execution error. The executed script:
ALTER TABLE [dbo].[tblPRPaycheckTax] WITH CHECK CHECK CONSTRAINT [FK_tblPRPaycheckTax_tblAPBill];
ALTER TABLE [dbo].[tblLGWarehouseInstructionHeader] WITH CHECK CHECK CONSTRAINT [FK_tblLGWarehouseInstructionHeader_tblAPBill_intBillId];
ALTER TABLE [dbo].[tblAPVoucherApprover] WITH CHECK CHECK CONSTRAINT [FK_tblAPVoucherApproval_tblAPBill];
ALTER TABLE [dbo].[tblPRPaycheckDeduction] WITH CHECK CHECK CONSTRAINT [FK_tblPRPaycheckDeduction_tblAPBill];
ALTER TABLE [dbo].[tblGRStorageHistory] WITH CHECK CHECK CONSTRAINT [FK_tblGRStorageHistory_tblAPBill_intBillId];
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.tblAPBillBatch_intBillBatchId];
ALTER TABLE [dbo].[tblAPBill] WITH CHECK CHECK CONSTRAINT [FK_dbo.tblAPBill_dbo.tblAPVendor_intVendo
|