Hello,
We're attempting to upgrade our old Management Reporter database from 2012 (RU2) to 2012 (CU16). I followed the instructions in this article: .
The upgrade runs for about 90 minutes and then crashes. Deployment log contains the following error description. Need help please!
1/11/2023 10:10:58 AM - [2023-01-11 10:10:58.820]PostDeployment script starts executing.
Machine: BDCMRS500
1/11/2023 10:11:12 AM - Inserting repository link for reports...
Machine: BDCMRS500
1/11/2023 10:11:12 AM - Updating scheduled report groups...
Machine: BDCMRS500
1/11/2023 10:11:12 AM - Updating XBRL tables...
Machine: BDCMRS500
1/11/2023 10:11:12 AM - Checking existing data against newly created constraints
Machine: BDCMRS500
1/11/2023 10:11:13 AM - .Net SqlClient Data Provider: Msg 547, Level 16, State 0, Line 23 The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_File_Data". The conflict occurred in database "ManagementReporter2012", table "Reporting.Data", column 'Hash'.
Machine: BDCMRS500
1/11/2023 10:11:13 AM - Script execution error. The executed script:
ALTER TABLE [Reporting].[ControlTreeCriteria] WITH CHECK CHECK CONSTRAINT [FK_ControlTreeCriteria_XbrlDimensionNamespaceID];
ALTER TABLE [Reporting].[ControlNote] WITH CHECK CHECK CONSTRAINT [FK_ControlNote_ControlReference];
ALTER TABLE [Reporting].[ControlReference] WITH CHECK CHECK CONSTRAINT [FK_ControlReference_Data];
ALTER TABLE [Reporting].[ControlXbrlMappingSetDetail] WITH CHECK CHECK CONSTRAINT [FK_ControlXbrlCompanyMappingDetail_ControlReference];
ALTER TABLE [Reporting].[ControlColumnCriteria] WITH CHECK CHECK CONSTRAINT [FK_ControlColumnCriteria_XbrlDimensionNamespaceID];
ALTER TABLE [Reporting].[ControlRowCriteria] WITH CHECK CHECK CONSTRAINT [FK_ControlRowCriteria_ControlReference];
ALTER TABLE [Reporting].[ControlRowCriteria] WITH CHECK CHECK CONSTRAINT [FK_ControlRowCriteria_ControlReference2];
ALTER TABLE [Reporting].[ControlColumnCriteria] WITH CHECK CHECK CONSTRAINT [FK_ControlColumnCriteria_NamespaceID];
ALTER TABLE [Reporting].[ControlTreeCriteria] WITH CHECK CHECK
Machine: BDCMRS500
1/11/2023 10:11:13 AM - An error occurred while the batch was being executed.
Machine: BDCMRS500
1/11/2023 10:11:13 AM - Updating database (Failed)
Machine: BDCMRS500
1/11/2023 10:11:13 AM - The database deployment failed. Additional information: Microsoft.SqlServer.Dac.DacServicesException: Could not deploy package.
Warning SQL72015: The table [Connector].[VersionHistory] is being dropped, data loss could occur.
Warning SQL72015: The table [Reporting].[License] is being dropped, data loss could occur.
Error SQL72014: .Net SqlClient Data Provider: Msg 547, Level 16, State 0, Line 23 The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_File_Data". The conflict occurred in database "ManagementReporter2012", table "Reporting.Data", column 'Hash'.
Error SQL72045: Script execution error. The executed script:
ALTER TABLE [Reporting].[ControlTreeCriteria] WITH CHECK CHECK CONSTRAINT [FK_ControlTreeCriteria_XbrlDimensionNamespaceID];
ALTER TABLE [Reporting].[ControlNote] WITH CHECK CHECK CONSTRAINT [FK_ControlNote_ControlReference];
ALTER TABLE [Reporting].[ControlReference] WITH CHECK CHECK CONSTRAINT [FK_ControlReference_Data];
ALTER TABLE [Reporting].[ControlXbrlMappingSetDetail] WITH CHECK CHECK CONSTRAINT [FK_ControlXbrlCompanyMappingDetail_ControlReference];
ALTER TABLE [Reporting].[ControlColumnCriteria] WITH CHECK CHECK CONSTRAINT [FK_ControlColumnCriteria_XbrlDimensionNamespaceID];
ALTER TABLE [Reporting].[ControlRowCriteria] WITH CHECK CHECK CONSTRAINT [FK_ControlRowCriteria_ControlReference];
ALTER TABLE [Reporting].[ControlRowCriteria] WITH CHECK CHECK CONSTRAINT [FK_ControlRowCriteria_ControlReference2];
ALTER TABLE [Reporting].[ControlColumnCriteria] WITH CHECK CHECK CONSTRAINT [FK_ControlColumnCriteria_NamespaceID];
ALTER TABLE [Reporting].[ControlTreeCriteria] WITH CHECK CHECK
at Microsoft.SqlServer.Dac.DeployOperation.ThrowIfErrorManagerHasErrors()
at Microsoft.SqlServer.Dac.DeployOperation.<>c__DisplayClass14.<>c__DisplayClass16.<CreatePlanExecutionOperation>b__13()
at Microsoft.Data.Tools.Schema.Sql.Dac.OperationLogger.Capture(Action action)
at Microsoft.SqlServer.Dac.DeployOperation.<>c__DisplayClass14.<CreatePlanExecutionOperation>b__12(Object operation, CancellationToken token)
at Microsoft.SqlServer.Dac.Operation.Microsoft.SqlServer.Dac.IOperation.Run(OperationContext context)
at Microsoft.SqlServer.Dac.ReportMessageOperation.Microsoft.SqlServer.Dac.IOperation.Run(OperationContext context)
at Microsoft.SqlServer.Dac.DeployOperation.Microsoft.SqlServer.Dac.IOperation.Run(OperationContext context)
at Microsoft.SqlServer.Dac.OperationExtension.Execute(IOperation operation, DacLoggingContext loggingContext, CancellationToken cancellationToken)
at Microsoft.SqlServer.Dac.DacServices.InternalDeploy(IPackageSource packageSource, Boolean isDacpac, String targetDatabaseName, DacDeployOptions options, CancellationToken cancellationToken, DacLoggingContext loggingContext, Action`3 reportPlanOperation, Boolean executePlan)
at Microsoft.SqlServer.Dac.DacServices.Deploy(DacPackage package, String targetDatabaseName, Boolean upgradeExisting, DacDeployOptions options, Nullable`1 cancellationToken)
at Microsoft.Dynamics.Performance.Deployment.Database.DatabaseDeployer.TryPerformDeployment(Boolean forceNew)
Machine: BDCMRS500
1/11/2023 10:11:13 AM - Database deploy status: False
Machine: BDCMRS500
1/11/2023 10:11:13 AM - The database deployment failed. Check the deployment log for details. The database deployment failed. Check the deployment log for details.
Machine: BDCMRS500
1/11/2023 10:20:43 AM - The database deployment failed. Check the deployment log for details.