Hi,
Over the last couple of days we have noticed the Check System Integrity task has been failing. The raw log is below;-
Task ID: ServerTasks-65037
Task status: Failed
Task queued: 08 January 2019 09:52:42
Task started: 08 January 2019 09:52:42
Task completed: 08 January 2019 09:52:43
Task duration: 1 second
Server version: 2018.9.16+Branch.master.Sha.ddd39553d927caf52eeae6699dc605ae374e2e12
Server node: [redacted]| Failed: Check System Integrity
09:52:43 Info | Unexpected related document id format… [ Passed ]
09:52:43 Error | Schema… [ Failed ]
09:52:43 Info | Release channel belongs to the appropriate project… [ Passed ]
09:52:43 Info | Orphaned tenanted deployments… [ Passed ]
09:52:43 Info | Orphaned channels… [ Passed ]
09:52:43 Info | Orphaned releases… [ Passed ]
09:52:43 Info | Only one unfrozen deployment process per project… [ Passed ]
09:52:43 Fatal | One or more data errors were found.
|
| Failed: Schema
09:52:43 Error | Unexpected item: IDX dbo.IX_ProjectTrigger_Project Name
| Missing item: IDX dbo.IX_Artifact_TenantId NONCLUSTERED 0
| Missing item: IDX dbo.IX_Artifact_TenantId TenantId
| Missing item: IDX dbo.IX_Certificate_Created Created
| Missing item: IDX dbo.IX_Certificate_Created NONCLUSTERED 0
| Missing item: IDX dbo.IX_Certificate_Thumbprint NONCLUSTERED 0
| Missing item: IDX dbo.IX_Certificate_Thumbprint Thumbprint
| Missing item: IDX dbo.IX_Event_AutoId AutoId
| Missing item: IDX dbo.IX_Event_AutoId NONCLUSTERED 0
| Missing item: IDX dbo.IX_Machine_MachinePolicy MachinePolicyId
| Missing item: IDX dbo.IX_Machine_MachinePolicy NONCLUSTERED 0
| Missing item: IDX dbo.IX_TenantVariable_TenantId NONCLUSTERED 0
| Missing item: IDX dbo.IX_TenantVariable_TenantId TenantId
| Missing item: IDX dbo.IX_User_DisplayName DisplayName
| Missing item: IDX dbo.IX_User_DisplayName NONCLUSTERED 0
| Missing item: IDX dbo.IX_User_EmailAddress EmailAddress
| Missing item: IDX dbo.IX_User_EmailAddress NONCLUSTERED 0
| Missing item: IDX dbo.UQ_ProjectTriggerNameUnique Name
| Missing item: IDX dbo.UQ_ProjectTriggerNameUnique NONCLUSTERED 1
| Missing item: IDX dbo.UQ_ProjectTriggerNameUnique ProjectId
|
We are currently running with version v2018.9.16 and I am not aware of any changes since we upgraded. Any ideas what is causing this, if we should be concerned and if there is any resolution?
Many thanks