How to verify when Orchestrator fails to upgrade with unknown error?
Perform the below procedure:
- Check dbo.AuditLogEntities table and dbo.AuditLogs table
- Verify if [dbo].[AuditLogEntities].[AuditLogId] shows a value unavailable in [dbo].[AuditLogs].[Id]
SELECT [AuditLogId] FROM [dbo].[AuditLogEntities] except select id from dbo.AuditLogs
- If such records exist, remove them or change the [AuditLogId] to be consistent with [Id]
DELETE FROM [dbo].[AuditLogEntities] WHERE AuditLogId = ### where "###" is the result from the first query