After coordinator upgrade the service keeps disabling itself.
In the log file, SQL Database trying to upgrade but failing at 50%.
Error There is already an object named 'usp_DataIntegrationGetFirstAuditEventRecord' in the database. on line 44423 executing SQL:
SQL error(2714): There is already an object named 'usp_DataIntegrationGetFirstAuditEventRecord' in the database.;
Database initialization not successful on ChangeAuditor.
In SQL Management studio, locate the service account in Security | Logins
- View the Properties of the service account and select "User Mapping"
- Locate the entry for the "ChangeAuditor" database
Change the schema for the service account from "db_owner" to "dbo":
- In SQL management studio, go to for the in Security | Logins
- Right-click the user and select Properties
- Click "User Mapping"
- Select the entry for the ChangeAuditor database
- In the Default Schema column, click the "..." button
- Click "Browse"
- Select [dbo] in the list and click OK
2. Restart the CA coordinator and confirm if the upgrade progresses.
