Diagnostics Showing View error in database

This seemed to start about 14 hours ago and is being reported in the Diagnostic Log:

Task ID: ServerTasks-53468
Related IDs:
Task status: Failed
Task queued: Wednesday, 31 July 2019 9:27:31 AM -07:00
Task started: Wednesday, 31 July 2019 9:27:31 AM -07:00
Task completed: Wednesday, 31 July 2019 9:27:32 AM -07:00
Task duration: 2 seconds
Server version: 2019.6.3+Branch.tags-2019.6.3.Sha.309fb85ffe2054c1803cb3b67dfdca7aceefd88c
Server node: NP03VOCTO001

                | Failed: Check System Integrity

09:27:32 Info | Unexpected related document id format… [ Passed ]
09:27:32 Error | Schema… [ Failed ]
09:27:32 Info | Release channel belongs to the appropriate project… [ Passed ]
09:27:32 Info | Orphaned tenanted deployments… [ Passed ]
09:27:32 Info | Orphaned channels… [ Passed ]
09:27:32 Info | Orphaned releases… [ Passed ]
09:27:32 Info | Only one unfrozen deployment process per project… [ Passed ]
09:27:32 Fatal | One or more data errors were found.
|
| Failed: Schema
09:27:32 Error | Unexpected item: VIEW dbo.View_QA_DeploymentHistory.CompletedTime datetimeoffset(10/34/7) 1
| Unexpected item: VIEW dbo.View_QA_DeploymentHistory.Created datetimeoffset(10/34/7) 0
| Unexpected item: VIEW dbo.View_QA_DeploymentHistory.DeployedBy nvarchar(400/0/0) 1
| Unexpected item: VIEW dbo.View_QA_DeploymentHistory.DeploymentName nvarchar(400/0/0) 0
| Unexpected item: VIEW dbo.View_QA_DeploymentHistory.EnvironmentName nvarchar(400/0/0) 0
| Unexpected item: VIEW dbo.View_QA_DeploymentHistory.ProjectName nvarchar(400/0/0) 0
| Unexpected item: VIEW dbo.View_QA_DeploymentHistory.ReleaseVersion nvarchar(200/0/0) 0
| Unexpected item: VIEW dbo.View_QA_DeploymentHistory.StartTime datetimeoffset(10/34/7) 1
| Unexpected item: VIEW dbo.View_QA_DeploymentHistory.TaskState nvarchar(100/0/0) 0
| Unexpected item: VIEW dbo.View_QA_DeploymentHistory.TenantName nvarchar(400/0/0) 1

I am not really sure what to do to resolve this issue? Does some data need to be edited/removed from the View?

Thanks for any help.

-Loyal

Hi Loyal,

Thanks for getting in touch! I’m reaching out here to let you know I’ve responded to your email in regards to this schema failure due these views in the database. :slight_smile:

Best regards,

Kenny

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.