| Description |
Upgrading testTE from 16.4.1013.126 to 17.1.0912.228.
database:
\\fileserver\Projects\i21Web\Databases\copp
Copied copppfa01 to testTE prior to upgrade.
Here is the error log.
Error SQL72014: .Net SqlClient Data Provider: Msg 547, Level 16, State 0, Line 2853 The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_tblTFReportingComponentCriteria_tblTFReportingComponent". The conflict occurred in database "testTE", table "dbo.tblTFReportingComponent", column 'intReportingComponentId'.
Error SQL72045: Script execution error. The executed script:
ALTER TABLE [dbo].[tblAPPaymentDetail] WITH CHECK CHECK CONSTRAINT [FK_tblAPPaymentDetail_tblAPBill];
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] WITH CHECK CHECK CONSTRAINT [FK_dbo.tblAPBill_dbo.tblSMCurrency_intCurrencyID];
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.tblSMCompanyLocation_intShipToId];
ALTER TABLE [dbo].[tblAPBill
|