Upgrade to 7.1.1 won't upgrade database schema and fail with error
Defect with the upgrade when SQL database is on SQL always on
Defect ID: 245141: Upgrade fails if the Change Auditor database is part of a SQL high availability group
Workaround
1. Stop the Changeauditor Coordinator service
2. Remove the Changeauditor database from the Always On configuration
3. Configure Changeauditor Coordinator to connect an individual SQL node using the "Coordinator configuration" tool
4. Start the Changeauditor Coordinator service and wait until the status shows "running"
5. Upgrade to 7.1.1
6. Once the upgrade is complete and the Coordinator status shows "running"
7. Stop the Changeauditor Coordinator service
8. Add the Changeauditor database to the Always On configuration
9. Configure Changeauditor Coordinator to connect to the Always on instance using the "Coordinator configuration" tool
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center