Return
-
Title
Archive Database Upgrade Fails When Installing Version 8.6.2 In A New Server. -
Description
If you have an existing Active Administrator server and instead of doing an in place upgrade you install Active Administrator in a new server it will install successfully, but when running AA Configuration Wizard and selecting existing databases, the following error may be seen:
If you click on View Full Log it shows that ActiveAdministrator database upgrades successfully, but the following error is seen during Archive Database upgrade:
[12/13/2022 21:07:57.96] [Information] Executing SQL script From_85_To_86.sql.
[12/13/2022 21:07:57.96] [Information] Changed database context to 'ActiveAdministrator_Archive_2022'.
[12/13/2022 21:07:57.97] [Information] Creating [dbo].[tblCertificateFolder]...
[12/13/2022 21:07:57.97] [Information] Creating [dbo].[tblCertificateFolderAssignment]...
[12/13/2022 21:07:58.01] [Information] Creating [dbo].[tblCertificateFolderComputer]...
[12/13/2022 21:07:58.04] [Information] Dropping and re-creating stored procedure DeleteCertificateComputer to remove folder-computer references.
[12/13/2022 21:07:58.05] [Information] Adding SelectedFolders to [dbo].[tblScheduledCertificateReportOptionSet]...
[12/13/2022 21:07:58.09] [Information] Modifying [dbo].[tblInactiveHistory]...
[12/13/2022 21:07:58.11] [Information] Modifying [dbo].[tblInactiveConfiguration]...
[12/13/2022 21:07:59.52] [Information] Database upgrade complete.
[12/13/2022 21:07:59.62] [09:07:59.62] Updating Active Directory Health data collectors and alerts.
[12/13/2022 21:07:59.63] [09:07:59.63] The network name cannot be found.
[12/13/2022 21:07:59.63] An error occurred while attempting to upgrade the Active Administrator databases.
-
Resolution
Running AA Configuration Wizard for a second time completes successfully and issue is no longer observed.