-
Title
Upgrade fail on database initialization when the CA database is configured with SQL Always On -
Description
Upgrade to 7.1.1 won't upgrade database schema and fail with error
- Database initialization not successful on ChangeAuditor. Value cannot be null. Parameter name: source- Object reference not set to an instance of an object. -
Cause
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
-
Resolution
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