Check System Integrity Schema failed Errors

Hi,

When I checked Octopus diagnostic reports I see that Check System Integrity Schema failed with following errors. I read some old topics related similar issue and it appears it could be related to SQL scripts executed on DB but I wan tot make sure these errors wouldn’t break any functionality. As always thanks for your help.

Unexpected item: USER_TABLE dbo.Channel_20190807.DataVersion timestamp(8/0/0) 0
Unexpected item: USER_TABLE dbo.Channel_20190807.Id nvarchar(100/0/0) 0
Unexpected item: USER_TABLE dbo.Channel_20190807.JSON nvarchar(-1/0/0) 0
Unexpected item: USER_TABLE dbo.Channel_20190807.LifecycleId nvarchar(100/0/0) 1
Unexpected item: USER_TABLE dbo.Channel_20190807.Name nvarchar(400/0/0) 0
Unexpected item: USER_TABLE dbo.Channel_20190807.ProjectId nvarchar(100/0/0) 0
Unexpected item: USER_TABLE dbo.Channel_20190807.TenantTags nvarchar(-1/0/0) 1
Unexpected item: USER_TABLE dbo.DeploymentProcess_20190807.Id nvarchar(300/0/0) 0
Unexpected item: USER_TABLE dbo.DeploymentProcess_20190807.IsFrozen bit(1/1/0) 0
Unexpected item: USER_TABLE dbo.DeploymentProcess_20190807.JSON nvarchar(-1/0/0) 0
Unexpected item: USER_TABLE dbo.DeploymentProcess_20190807.OwnerId nvarchar(300/0/0) 0
Unexpected item: USER_TABLE dbo.DeploymentProcess_20190807.RelatedDocumentIds nvarchar(-1/0/0) 1
Unexpected item: USER_TABLE dbo.DeploymentProcess_20190807.Version int(4/10/0) 0
Unexpected item: USER_TABLE dbo.Project_20190807.AutoCreateRelease bit(1/1/0) 0
Unexpected item: USER_TABLE dbo.Project_20190807.ClonedFromProjectId nvarchar(100/0/0) 1
Unexpected item: USER_TABLE dbo.Project_20190807.DataVersion timestamp(8/0/0) 0
Unexpected item: USER_TABLE dbo.Project_20190807.DeploymentProcessId nvarchar(100/0/0) 1
Unexpected item: USER_TABLE dbo.Project_20190807.DiscreteChannelRelease bit(1/1/0) 0
Unexpected item: USER_TABLE dbo.Project_20190807.Id nvarchar(100/0/0) 0
Unexpected item: USER_TABLE dbo.Project_20190807.IncludedLibraryVariableSetIds nvarchar(-1/0/0) 1
Unexpected item: USER_TABLE dbo.Project_20190807.IsDisabled bit(1/1/0) 0
Unexpected item: USER_TABLE dbo.Project_20190807.JSON nvarchar(-1/0/0) 0
Unexpected item: USER_TABLE dbo.Project_20190807.LifecycleId nvarchar(100/0/0) 0
Unexpected item: USER_TABLE dbo.Project_20190807.Name nvarchar(400/0/0) 0
Unexpected item: USER_TABLE dbo.Project_20190807.ProjectGroupId nvarchar(100/0/0) 0
Unexpected item: USER_TABLE dbo.Project_20190807.Slug nvarchar(420/0/0) 0
Unexpected item: USER_TABLE dbo.Project_20190807.VariableSetId nvarchar(300/0/0) 1

Hey @ajaybre,

This is due to having a SQL database backup. The check is finding that it has extra tables it’s not expecting. This shouldnt impact anything day to day, but it may impact upgrades in the future. To alleviate this you could move the backup tables to a different database or archive them to a file.

Please let me know if this resolves it for you or if we need to dig deeper.

Thanks,
Jeremy