Check System Integrity fails with Schema error

rati_dzidziguri · 27 September 2016 11:25

I was recently asked to audit and do some maintenance on Octopus Deployment server version 3.4.9 whenever i run integrity check what i saw was the following error for schema.

Unexpected item: IDX dbo.PK__sysdiagr__C2B05B6198A44C1B CLUSTERED 0 
Unexpected item: IDX dbo.PK__sysdiagr__C2B05B6198A44C1B diagram_id 
Unexpected item: IDX dbo.UK_principal_name name
Unexpected item: IDX dbo.UK_principal_name NONCLUSTERED 1
Unexpected item: IDX dbo.UK_principal_name principal_id
Unexpected item: USER_TABLE dbo.sysdiagrams.definition varbinary(-1/0/0) 1
Unexpected item: USER_TABLE dbo.sysdiagrams.diagram_id int(4/10/0) 0 
Unexpected item: USER_TABLE dbo.sysdiagrams.name sysname(256/0/0) 0 
Unexpected item: USER_TABLE dbo.sysdiagrams.principal_id int(4/10/0) 0 
Unexpected item: USER_TABLE dbo.sysdiagrams.version int(4/10/0) 1

Company recently did in-place upgrade of Octopus and they are asking me to take care of this. so is there any way i can fix this error?

rati_dzidziguri · 27 September 2016 11:39

Here is the result of the query i found on this support page.

FK_DeploymentRelatedMachine_DeploymentId DeploymentId->Id
FK_EventRelatedDocument_EventId EventId->Id
IX_Artifact_TenantId NONCLUSTERED 0
IX_Artifact_TenantId TenantId
IX_Channel_ProjectId NONCLUSTERED 0
IX_Channel_ProjectId ProjectId
IX_Deployment_ChannelId ChannelId
IX_Deployment_ChannelId NONCLUSTERED 0
IX_Deployment_Index Created
IX_Deployment_Index EnvironmentId
IX_Deployment_Index Id
IX_Deployment_Index Name
IX_Deployment_Index NONCLUSTERED 0
IX_Deployment_Index ProjectGroupId
IX_Deployment_Index ProjectId
IX_Deployment_Index ReleaseId
IX_Deployment_Index TaskId
IX_Deployment_TenantId NONCLUSTERED 0
IX_Deployment_TenantId TenantId
IX_DeploymentHistory_Created Created
IX_DeploymentHistory_Created NONCLUSTERED 0
IX_DeploymentRelatedMachine_Deployment DeploymentId
IX_DeploymentRelatedMachine_Deployment NONCLUSTERED 0
IX_DeploymentRelatedMachine_Machine MachineId
IX_DeploymentRelatedMachine_Machine NONCLUSTERED 0
IX_EventRelatedDocument_EventId EventId
IX_EventRelatedDocument_EventId NONCLUSTERED 0
IX_EventRelatedDocument_RelatedDocumentId NONCLUSTERED 0
IX_EventRelatedDocument_RelatedDocumentId RelatedDocumentId
IX_Interruption_TenantId NONCLUSTERED 0
IX_Interruption_TenantId TenantId
IX_Machine_MachinePolicy MachinePolicyId
IX_Machine_MachinePolicy NONCLUSTERED 0
IX_ProjectTrigger_Project NONCLUSTERED 0
IX_ProjectTrigger_Project ProjectId
IX_Release_ChannelId ChannelId
IX_Release_ChannelId NONCLUSTERED 0
IX_ServerTask_Id_State Id
IX_ServerTask_Id_State NONCLUSTERED 0
IX_ServerTask_Id_State State
IX_ServerTask_Index ConcurrencyTag
IX_ServerTask_Index HasPendingInterruptions
IX_ServerTask_Index NONCLUSTERED 0
IX_ServerTask_Index QueueTime
IX_ServerTask_Index ServerNode
IX_ServerTask_Index State
IX_ServerTask_TenantId NONCLUSTERED 0
IX_ServerTask_TenantId TenantId
IX_TenantVariable_TenantId NONCLUSTERED 0
IX_TenantVariable_TenantId TenantId
PK__sysdiagr__C2B05B6198A44C1B CLUSTERED 0
PK__sysdiagr__C2B05B6198A44C1B diagram_id
PK_Account_Id CLUSTERED 0
PK_Account_Id Id
PK_ActionTemplate_Id CLUSTERED 0
PK_ActionTemplate_Id Id
PK_ApiKey_Id CLUSTERED 0
PK_ApiKey_Id Id
PK_Artifact_Id CLUSTERED 0
PK_Artifact_Id Id
PK_Certificate_Id CLUSTERED 0
PK_Certificate_Id Id
PK_Channel_Id CLUSTERED 0
PK_Channel_Id Id
PK_Configuration_Id CLUSTERED 0
PK_Configuration_Id Id
PK_DashboardConfiguration_Id CLUSTERED 0
PK_DashboardConfiguration_Id Id
PK_Deployment_Id CLUSTERED 0
PK_Deployment_Id Id
PK_DeploymentEnvironment_Id CLUSTERED 0
PK_DeploymentEnvironment_Id Id
PK_DeploymentHistory_DeploymentId CLUSTERED 0
PK_DeploymentHistory_DeploymentId DeploymentId
PK_DeploymentProcess_Id CLUSTERED 0
PK_DeploymentProcess_Id Id
PK_DeploymentRelatedMachine CLUSTERED 0
PK_DeploymentRelatedMachine Id
PK_Event_Id CLUSTERED 0
PK_Event_Id Id
PK_EventRelatedDocument CLUSTERED 0
PK_EventRelatedDocument Id
PK_Feed_Id CLUSTERED 0
PK_Feed_Id Id
PK_Interruption_Id CLUSTERED 0
PK_Interruption_Id Id
PK_Invitation_Id CLUSTERED 0
PK_Invitation_Id Id
PK_KeyAllocation_CollectionName CLUSTERED 0
PK_KeyAllocation_CollectionName CollectionName
PK_LibraryVariableSet_Id CLUSTERED 0
PK_LibraryVariableSet_Id Id
PK_Lifecycle_Id CLUSTERED 0
PK_Lifecycle_Id Id
PK_Machine_Id CLUSTERED 0
PK_Machine_Id Id
PK_MachinePolicy_Id CLUSTERED 0
PK_MachinePolicy_Id Id
PK_Mutex_Id CLUSTERED 0
PK_Mutex_Id Id
PK_NuGetPackage_Id CLUSTERED 0
PK_NuGetPackage_Id Id
PK_OctopusServerNode_Id CLUSTERED 0
PK_OctopusServerNode_Id Id
PK_Project_Id CLUSTERED 0
PK_Project_Id Id
PK_ProjectGroup_Id CLUSTERED 0
PK_ProjectGroup_Id Id
PK_ProjectTrigger_Id CLUSTERED 0
PK_ProjectTrigger_Id Id
PK_Proxy_Id CLUSTERED 0
PK_Proxy_Id Id
PK_Release_Id CLUSTERED 0
PK_Release_Id Id
PK_SchemaVersions_Id CLUSTERED 0
PK_SchemaVersions_Id Id
PK_ServerTask_Id CLUSTERED 0
PK_ServerTask_Id Id
PK_TagSet_Id CLUSTERED 0
PK_TagSet_Id Id
PK_Team_Id CLUSTERED 0
PK_Team_Id Id
PK_Tenant_Id CLUSTERED 0
PK_Tenant_Id Id
PK_TenantVariable_Id CLUSTERED 0
PK_TenantVariable_Id Id
PK_User_Id CLUSTERED 0
PK_User_Id Id
PK_UserRole_Id CLUSTERED 0
PK_UserRole_Id Id
PK_VariableSet_Id CLUSTERED 0
PK_VariableSet_Id Id
UK_principal_name name
UK_principal_name NONCLUSTERED 1
UK_principal_name principal_id
UQ_AccountUniqueName Name
UQ_AccountUniqueName NONCLUSTERED 1
UQ_ActionTemplateUniqueName Name
UQ_ActionTemplateUniqueName NONCLUSTERED 1
UQ_ApiKeyUnique ApiKeyHashed
UQ_ApiKeyUnique NONCLUSTERED 1
UQ_ChannelUniqueNamePerProject Name
UQ_ChannelUniqueNamePerProject NONCLUSTERED 1
UQ_ChannelUniqueNamePerProject ProjectId
UQ_DeploymentEnvironmentNameUnique Name
UQ_DeploymentEnvironmentNameUnique NONCLUSTERED 1
UQ_FeedNameUnique Name
UQ_FeedNameUnique NONCLUSTERED 1
UQ_LibraryVariableSetNameUnique Name
UQ_LibraryVariableSetNameUnique NONCLUSTERED 1
UQ_LifecycleNameUnique Name
UQ_LifecycleNameUnique NONCLUSTERED 1
UQ_MachineNameUnique Name
UQ_MachineNameUnique NONCLUSTERED 1
UQ_MachinePolicy Name
UQ_MachinePolicy NONCLUSTERED 1
UQ_ProjectGroupNameUnique Name
UQ_ProjectGroupNameUnique NONCLUSTERED 1
UQ_ProjectNameUnique Name
UQ_ProjectNameUnique NONCLUSTERED 1
UQ_ProjectSlugUnique NONCLUSTERED 1
UQ_ProjectSlugUnique Slug
UQ_ProjectTriggerNameUnique Name
UQ_ProjectTriggerNameUnique NONCLUSTERED 1
UQ_ProjectTriggerNameUnique ProjectId
UQ_ProxyNameUnique Name
UQ_ProxyNameUnique NONCLUSTERED 1
UQ_ReleaseVersionUnique NONCLUSTERED 1
UQ_ReleaseVersionUnique ProjectId
UQ_ReleaseVersionUnique Version
UQ_TagSetName Name
UQ_TagSetName NONCLUSTERED 1
UQ_TeamNameUnique Name
UQ_TeamNameUnique NONCLUSTERED 1
UQ_TenantName Name
UQ_TenantName NONCLUSTERED 1
UQ_TenantVariable EnvironmentId
UQ_TenantVariable NONCLUSTERED 1
UQ_TenantVariable OwnerId
UQ_TenantVariable TenantId
UQ_TenantVariable VariableTemplateId
UQ_UserRoleNameUnique Name
UQ_UserRoleNameUnique NONCLUSTERED 1
UQ_UserUsernameUnique NONCLUSTERED 1
UQ_UserUsernameUnique Username
USER_TABLE Account.AccountType nvarchar(100/0/0) 0
USER_TABLE Account.EnvironmentIds nvarchar(-1/0/0) 0
USER_TABLE Account.Id nvarchar(420/0/0) 0
USER_TABLE Account.JSON nvarchar(-1/0/0) 0
USER_TABLE Account.Name nvarchar(400/0/0) 0
USER_TABLE Account.TenantIds nvarchar(-1/0/0) 1
USER_TABLE Account.TenantTags nvarchar(-1/0/0) 1
USER_TABLE ActionTemplate.ActionType nvarchar(100/0/0) 0
USER_TABLE ActionTemplate.Id nvarchar(100/0/0) 0
USER_TABLE ActionTemplate.JSON nvarchar(-1/0/0) 0
USER_TABLE ActionTemplate.Name nvarchar(400/0/0) 0
USER_TABLE ActionTemplate.Version int(4/10/0) 0
USER_TABLE ApiKey.ApiKeyHashed nvarchar(400/0/0) 0
USER_TABLE ApiKey.Created datetimeoffset(10/34/7) 0
USER_TABLE ApiKey.Id nvarchar(100/0/0) 0
USER_TABLE ApiKey.JSON nvarchar(-1/0/0) 0
USER_TABLE ApiKey.UserId nvarchar(100/0/0) 0
USER_TABLE Artifact.Created datetimeoffset(10/34/7) 0
USER_TABLE Artifact.EnvironmentId nvarchar(100/0/0) 1
USER_TABLE Artifact.Filename nvarchar(400/0/0) 0
USER_TABLE Artifact.Id nvarchar(100/0/0) 0
USER_TABLE Artifact.JSON nvarchar(-1/0/0) 0
USER_TABLE Artifact.ProjectId nvarchar(100/0/0) 1
USER_TABLE Artifact.RelatedDocumentIds nvarchar(-1/0/0) 0
USER_TABLE Artifact.TenantId nvarchar(100/0/0) 1
USER_TABLE Certificate.Id nvarchar(100/0/0) 0
USER_TABLE Certificate.JSON nvarchar(-1/0/0) 0
USER_TABLE Certificate.Name nvarchar(400/0/0) 0
USER_TABLE Certificate.Thumbprint nvarchar(256/0/0) 0
USER_TABLE Channel.Id nvarchar(100/0/0) 0
USER_TABLE Channel.JSON nvarchar(-1/0/0) 0
USER_TABLE Channel.LifecycleId nvarchar(100/0/0) 1
USER_TABLE Channel.Name nvarchar(400/0/0) 0
USER_TABLE Channel.ProjectId nvarchar(100/0/0) 0
USER_TABLE Channel.TenantTags nvarchar(-1/0/0) 1
USER_TABLE Configuration.Id nvarchar(100/0/0) 0
USER_TABLE Configuration.JSON nvarchar(-1/0/0) 0
USER_TABLE DashboardConfiguration.Id nvarchar(100/0/0) 0
USER_TABLE DashboardConfiguration.IncludedEnvironmentIds nvarchar(-1/0/0) 0
USER_TABLE DashboardConfiguration.IncludedProjectIds nvarchar(-1/0/0) 0
USER_TABLE DashboardConfiguration.IncludedTenantIds nvarchar(-1/0/0) 1
USER_TABLE DashboardConfiguration.IncludedTenantTags nvarchar(-1/0/0) 1
USER_TABLE DashboardConfiguration.JSON nvarchar(-1/0/0) 0
USER_TABLE Deployment.ChannelId nvarchar(100/0/0) 0
USER_TABLE Deployment.Created datetimeoffset(10/34/7) 0
USER_TABLE Deployment.DeployedBy nvarchar(400/0/0) 0
USER_TABLE Deployment.DeployedToMachineIds nvarchar(-1/0/0) 1
USER_TABLE Deployment.EnvironmentId nvarchar(100/0/0) 0
USER_TABLE Deployment.Id nvarchar(100/0/0) 0
USER_TABLE Deployment.JSON nvarchar(-1/0/0) 0
USER_TABLE Deployment.Name nvarchar(400/0/0) 0
USER_TABLE Deployment.ProjectGroupId nvarchar(100/0/0) 0
USER_TABLE Deployment.ProjectId nvarchar(100/0/0) 0
USER_TABLE Deployment.ReleaseId nvarchar(100/0/0) 0
USER_TABLE Deployment.TaskId nvarchar(100/0/0) 1
USER_TABLE Deployment.TenantId nvarchar(100/0/0) 1
USER_TABLE DeploymentEnvironment.Id nvarchar(100/0/0) 0
USER_TABLE DeploymentEnvironment.JSON nvarchar(-1/0/0) 0
USER_TABLE DeploymentEnvironment.Name nvarchar(400/0/0) 0
USER_TABLE DeploymentEnvironment.SortOrder int(4/10/0) 0
USER_TABLE DeploymentHistory.ChannelId nvarchar(100/0/0) 1
USER_TABLE DeploymentHistory.ChannelName nvarchar(400/0/0) 1
USER_TABLE DeploymentHistory.CompletedTime datetimeoffset(10/34/7) 1
USER_TABLE DeploymentHistory.Created datetimeoffset(10/34/7) 0
USER_TABLE DeploymentHistory.DeployedBy nvarchar(400/0/0) 1
USER_TABLE DeploymentHistory.DeploymentId nvarchar(100/0/0) 0
USER_TABLE DeploymentHistory.DeploymentName nvarchar(400/0/0) 0
USER_TABLE DeploymentHistory.DurationSeconds int(4/10/0) 1
USER_TABLE DeploymentHistory.EnvironmentId nvarchar(100/0/0) 0
USER_TABLE DeploymentHistory.EnvironmentName nvarchar(400/0/0) 0
USER_TABLE DeploymentHistory.ProjectId nvarchar(100/0/0) 0
USER_TABLE DeploymentHistory.ProjectName nvarchar(400/0/0) 0
USER_TABLE DeploymentHistory.ProjectSlug nvarchar(420/0/0) 0
USER_TABLE DeploymentHistory.QueueTime datetimeoffset(10/34/7) 0
USER_TABLE DeploymentHistory.ReleaseId nvarchar(300/0/0) 0
USER_TABLE DeploymentHistory.ReleaseVersion nvarchar(200/0/0) 0
USER_TABLE DeploymentHistory.StartTime datetimeoffset(10/34/7) 1
USER_TABLE DeploymentHistory.TaskId nvarchar(100/0/0) 0
USER_TABLE DeploymentHistory.TaskState nvarchar(100/0/0) 0
USER_TABLE DeploymentHistory.TenantId nvarchar(100/0/0) 1
USER_TABLE DeploymentHistory.TenantName nvarchar(400/0/0) 1
USER_TABLE DeploymentProcess.Id nvarchar(300/0/0) 0
USER_TABLE DeploymentProcess.IsFrozen bit(1/1/0) 0
USER_TABLE DeploymentProcess.JSON nvarchar(-1/0/0) 0
USER_TABLE DeploymentProcess.OwnerId nvarchar(300/0/0) 0
USER_TABLE DeploymentProcess.RelatedDocumentIds nvarchar(-1/0/0) 1
USER_TABLE DeploymentProcess.Version int(4/10/0) 0
USER_TABLE DeploymentRelatedMachine.DeploymentId nvarchar(100/0/0) 0
USER_TABLE DeploymentRelatedMachine.Id int(4/10/0) 0
USER_TABLE DeploymentRelatedMachine.MachineId nvarchar(100/0/0) 0
USER_TABLE Event.Category nvarchar(100/0/0) 0
USER_TABLE Event.EnvironmentId nvarchar(100/0/0) 1
USER_TABLE Event.Id nvarchar(100/0/0) 0
USER_TABLE Event.JSON nvarchar(-1/0/0) 0
USER_TABLE Event.Message nvarchar(-1/0/0) 0
USER_TABLE Event.Occurred datetimeoffset(10/34/7) 0
USER_TABLE Event.ProjectId nvarchar(100/0/0) 1
USER_TABLE Event.RelatedDocumentIds nvarchar(-1/0/0) 0
USER_TABLE Event.TenantId nvarchar(100/0/0) 1
USER_TABLE Event.UserId nvarchar(100/0/0) 0
USER_TABLE Event.Username nvarchar(400/0/0) 0
USER_TABLE EventRelatedDocument.EventId nvarchar(100/0/0) 0
USER_TABLE EventRelatedDocument.Id int(4/10/0) 0
USER_TABLE EventRelatedDocument.RelatedDocumentId nvarchar(400/0/0) 0
USER_TABLE Feed.FeedUri nvarchar(1024/0/0) 0
USER_TABLE Feed.Id nvarchar(420/0/0) 0
USER_TABLE Feed.JSON nvarchar(-1/0/0) 0
USER_TABLE Feed.Name nvarchar(400/0/0) 0
USER_TABLE Interruption.Created datetimeoffset(10/34/7) 0
USER_TABLE Interruption.EnvironmentId nvarchar(100/0/0) 0
USER_TABLE Interruption.Id nvarchar(100/0/0) 0
USER_TABLE Interruption.JSON nvarchar(-1/0/0) 0
USER_TABLE Interruption.ProjectId nvarchar(100/0/0) 0
USER_TABLE Interruption.RelatedDocumentIds nvarchar(-1/0/0) 0
USER_TABLE Interruption.ResponsibleTeamIds nvarchar(-1/0/0) 0
USER_TABLE Interruption.Status nvarchar(100/0/0) 0
USER_TABLE Interruption.TaskId nvarchar(100/0/0) 0
USER_TABLE Interruption.TenantId nvarchar(100/0/0) 1
USER_TABLE Interruption.Title nvarchar(400/0/0) 0
USER_TABLE Invitation.Id nvarchar(100/0/0) 0
USER_TABLE Invitation.InvitationCode nvarchar(400/0/0) 0
USER_TABLE Invitation.JSON nvarchar(-1/0/0) 0
USER_TABLE KeyAllocation.Allocated int(4/10/0) 0
USER_TABLE KeyAllocation.CollectionName nvarchar(100/0/0) 0
USER_TABLE LibraryVariableSet.ContentType nvarchar(100/0/0) 0
USER_TABLE LibraryVariableSet.Id nvarchar(100/0/0) 0
USER_TABLE LibraryVariableSet.JSON nvarchar(-1/0/0) 0
USER_TABLE LibraryVariableSet.Name nvarchar(400/0/0) 0
USER_TABLE LibraryVariableSet.VariableSetId nvarchar(300/0/0) 1
USER_TABLE Lifecycle.Id nvarchar(100/0/0) 0
USER_TABLE Lifecycle.JSON nvarchar(-1/0/0) 0
USER_TABLE Lifecycle.Name nvarchar(400/0/0) 0
USER_TABLE Machine.EnvironmentIds nvarchar(-1/0/0) 0
USER_TABLE Machine.Id nvarchar(100/0/0) 0
USER_TABLE Machine.IsDisabled bit(1/1/0) 0
USER_TABLE Machine.JSON nvarchar(-1/0/0) 0
USER_TABLE Machine.MachinePolicyId nvarchar(100/0/0) 1
USER_TABLE Machine.Name nvarchar(400/0/0) 0
USER_TABLE Machine.Roles nvarchar(-1/0/0) 0
USER_TABLE Machine.TenantIds nvarchar(-1/0/0) 1
USER_TABLE Machine.TenantTags nvarchar(-1/0/0) 1
USER_TABLE MachinePolicy.Id nvarchar(100/0/0) 0
USER_TABLE MachinePolicy.IsDefault bit(1/1/0) 0
USER_TABLE MachinePolicy.JSON nvarchar(-1/0/0) 0
USER_TABLE MachinePolicy.Name nvarchar(400/0/0) 0
USER_TABLE Mutex.Id nvarchar(900/0/0) 0
USER_TABLE Mutex.JSON nvarchar(-1/0/0) 0
USER_TABLE NuGetPackage.Id nvarchar(900/0/0) 0
USER_TABLE NuGetPackage.JSON nvarchar(-1/0/0) 0
USER_TABLE NuGetPackage.PackageId nvarchar(200/0/0) 0
USER_TABLE NuGetPackage.Version nvarchar(698/0/0) 0
USER_TABLE NuGetPackage.VersionBuild int(4/10/0) 0
USER_TABLE NuGetPackage.VersionMajor int(4/10/0) 0
USER_TABLE NuGetPackage.VersionMinor int(4/10/0) 0
USER_TABLE NuGetPackage.VersionRevision int(4/10/0) 0
USER_TABLE NuGetPackage.VersionSpecial nvarchar(500/0/0) 1
USER_TABLE OctopusServerNode.Id nvarchar(100/0/0) 0
USER_TABLE OctopusServerNode.IsInMaintenanceMode bit(1/1/0) 0
USER_TABLE OctopusServerNode.JSON nvarchar(-1/0/0) 0
USER_TABLE OctopusServerNode.LastSeen datetimeoffset(10/34/7) 0
USER_TABLE OctopusServerNode.MaxConcurrentTasks int(4/10/0) 0
USER_TABLE OctopusServerNode.Name nvarchar(400/0/0) 0
USER_TABLE OctopusServerNode.Rank nvarchar(100/0/0) 0
USER_TABLE Project.AutoCreateRelease bit(1/1/0) 0
USER_TABLE Project.DeploymentProcessId nvarchar(100/0/0) 1
USER_TABLE Project.Id nvarchar(100/0/0) 0
USER_TABLE Project.IncludedLibraryVariableSetIds nvarchar(-1/0/0) 1
USER_TABLE Project.IsDisabled bit(1/1/0) 0
USER_TABLE Project.JSON nvarchar(-1/0/0) 0
USER_TABLE Project.LifecycleId nvarchar(100/0/0) 0
USER_TABLE Project.Name nvarchar(400/0/0) 0
USER_TABLE Project.ProjectGroupId nvarchar(100/0/0) 0
USER_TABLE Project.Slug nvarchar(420/0/0) 0
USER_TABLE Project.VariableSetId nvarchar(300/0/0) 1
USER_TABLE ProjectGroup.Id nvarchar(100/0/0) 0
USER_TABLE ProjectGroup.JSON nvarchar(-1/0/0) 0
USER_TABLE ProjectGroup.Name nvarchar(400/0/0) 0
USER_TABLE ProjectTrigger.Id nvarchar(100/0/0) 0
USER_TABLE ProjectTrigger.JSON nvarchar(-1/0/0) 0
USER_TABLE ProjectTrigger.Name nvarchar(400/0/0) 0
USER_TABLE ProjectTrigger.ProjectId nvarchar(100/0/0) 0
USER_TABLE ProjectTrigger.Type nvarchar(100/0/0) 1
USER_TABLE Proxy.Id nvarchar(100/0/0) 0
USER_TABLE Proxy.JSON nvarchar(-1/0/0) 0
USER_TABLE Proxy.Name nvarchar(400/0/0) 0
USER_TABLE Release.Assembled datetimeoffset(10/34/7) 0
USER_TABLE Release.ChannelId nvarchar(100/0/0) 0
USER_TABLE Release.Id nvarchar(300/0/0) 0
USER_TABLE Release.JSON nvarchar(-1/0/0) 0
USER_TABLE Release.ProjectDeploymentProcessSnapshotId nvarchar(300/0/0) 0
USER_TABLE Release.ProjectId nvarchar(300/0/0) 0
USER_TABLE Release.ProjectVariableSetSnapshotId nvarchar(300/0/0) 0
USER_TABLE Release.Version nvarchar(200/0/0) 0
USER_TABLE SchemaVersions.Applied datetime(8/23/3) 0
USER_TABLE SchemaVersions.Id int(4/10/0) 0
USER_TABLE SchemaVersions.ScriptName nvarchar(510/0/0) 0
USER_TABLE ServerTask.CompletedTime datetimeoffset(10/34/7) 1
USER_TABLE ServerTask.ConcurrencyTag nvarchar(200/0/0) 1
USER_TABLE ServerTask.Description nvarchar(-1/0/0) 0
USER_TABLE ServerTask.DurationSeconds int(4/10/0) 0
USER_TABLE ServerTask.EnvironmentId nvarchar(100/0/0) 1
USER_TABLE ServerTask.ErrorMessage nvarchar(-1/0/0) 1
USER_TABLE ServerTask.HasPendingInterruptions bit(1/1/0) 0
USER_TABLE ServerTask.HasWarningsOrErrors bit(1/1/0) 0
USER_TABLE ServerTask.Id nvarchar(100/0/0) 0
USER_TABLE ServerTask.JSON nvarchar(-1/0/0) 0
USER_TABLE ServerTask.Name nvarchar(40/0/0) 0
USER_TABLE ServerTask.ProjectId nvarchar(100/0/0) 1
USER_TABLE ServerTask.QueueTime datetimeoffset(10/34/7) 0
USER_TABLE ServerTask.ServerNode nvarchar(400/0/0) 1
USER_TABLE ServerTask.StartTime datetimeoffset(10/34/7) 1
USER_TABLE ServerTask.State nvarchar(100/0/0) 0
USER_TABLE ServerTask.TenantId nvarchar(100/0/0) 1
USER_TABLE sysdiagrams.definition varbinary(-1/0/0) 1
USER_TABLE sysdiagrams.diagram_id int(4/10/0) 0
USER_TABLE sysdiagrams.name sysname(256/0/0) 0
USER_TABLE sysdiagrams.principal_id int(4/10/0) 0
USER_TABLE sysdiagrams.version int(4/10/0) 1
USER_TABLE TagSet.Id nvarchar(100/0/0) 0
USER_TABLE TagSet.JSON nvarchar(-1/0/0) 0
USER_TABLE TagSet.Name nvarchar(400/0/0) 0
USER_TABLE TagSet.SortOrder int(4/10/0) 0
USER_TABLE Team.EnvironmentIds nvarchar(-1/0/0) 0
USER_TABLE Team.Id nvarchar(100/0/0) 0
USER_TABLE Team.JSON nvarchar(-1/0/0) 0
USER_TABLE Team.MemberUserIds nvarchar(-1/0/0) 0
USER_TABLE Team.Name nvarchar(400/0/0) 0
USER_TABLE Team.ProjectIds nvarchar(-1/0/0) 0
USER_TABLE Team.TenantIds nvarchar(-1/0/0) 1
USER_TABLE Team.TenantTags nvarchar(-1/0/0) 1
USER_TABLE Tenant.Id nvarchar(100/0/0) 0
USER_TABLE Tenant.JSON nvarchar(-1/0/0) 0
USER_TABLE Tenant.Name nvarchar(400/0/0) 0
USER_TABLE Tenant.ProjectIds nvarchar(-1/0/0) 0
USER_TABLE Tenant.TenantTags nvarchar(-1/0/0) 1
USER_TABLE TenantVariable.EnvironmentId nvarchar(100/0/0) 1
USER_TABLE TenantVariable.Id nvarchar(100/0/0) 0
USER_TABLE TenantVariable.JSON nvarchar(-1/0/0) 0
USER_TABLE TenantVariable.OwnerId nvarchar(100/0/0) 0
USER_TABLE TenantVariable.TenantId nvarchar(100/0/0) 0
USER_TABLE TenantVariable.VariableTemplateId nvarchar(100/0/0) 0
USER_TABLE User.Id nvarchar(100/0/0) 0
USER_TABLE User.IdentificationToken uniqueidentifier(16/0/0) 0
USER_TABLE User.IsActive bit(1/1/0) 0
USER_TABLE User.IsService bit(1/1/0) 0
USER_TABLE User.JSON nvarchar(-1/0/0) 0
USER_TABLE User.Username nvarchar(400/0/0) 0
USER_TABLE UserRole.Id nvarchar(100/0/0) 0
USER_TABLE UserRole.JSON nvarchar(-1/0/0) 0
USER_TABLE UserRole.Name nvarchar(400/0/0) 0
USER_TABLE VariableSet.Id nvarchar(300/0/0) 0
USER_TABLE VariableSet.IsFrozen bit(1/1/0) 0
USER_TABLE VariableSet.JSON nvarchar(-1/0/0) 0
USER_TABLE VariableSet.OwnerId nvarchar(300/0/0) 0
USER_TABLE VariableSet.RelatedDocumentIds nvarchar(-1/0/0) 1
USER_TABLE VariableSet.Version int(4/10/0) 0
VIEW Dashboard.ChannelId nvarchar(100/0/0) 0
VIEW Dashboard.CompletedTime datetimeoffset(10/34/7) 1
VIEW Dashboard.Created datetimeoffset(10/34/7) 0
VIEW Dashboard.CurrentOrPrevious varchar(1/0/0) 0
VIEW Dashboard.EnvironmentId nvarchar(100/0/0) 0
VIEW Dashboard.ErrorMessage nvarchar(-1/0/0) 1
VIEW Dashboard.HasPendingInterruptions bit(1/1/0) 0
VIEW Dashboard.HasWarningsOrErrors bit(1/1/0) 0
VIEW Dashboard.Id nvarchar(100/0/0) 0
VIEW Dashboard.ProjectId nvarchar(100/0/0) 0
VIEW Dashboard.QueueTime datetimeoffset(10/34/7) 0
VIEW Dashboard.ReleaseId nvarchar(100/0/0) 0
VIEW Dashboard.State nvarchar(100/0/0) 0
VIEW Dashboard.TaskId nvarchar(100/0/0) 1
VIEW Dashboard.Version nvarchar(200/0/0) 0
VIEW DeploymentSummary.CompletedTime datetimeoffset(10/34/7) 1
VIEW DeploymentSummary.Created datetimeoffset(10/34/7) 0
VIEW DeploymentSummary.CurrentOrPrevious varchar(1/0/0) 0
VIEW DeploymentSummary.EnvironmentId nvarchar(100/0/0) 0
VIEW DeploymentSummary.ErrorMessage nvarchar(-1/0/0) 1
VIEW DeploymentSummary.HasPendingInterruptions bit(1/1/0) 0
VIEW DeploymentSummary.HasWarningsOrErrors bit(1/1/0) 0
VIEW DeploymentSummary.Id nvarchar(100/0/0) 0
VIEW DeploymentSummary.ProjectId nvarchar(100/0/0) 0
VIEW DeploymentSummary.QueueTime datetimeoffset(10/34/7) 0
VIEW DeploymentSummary.ReleaseId nvarchar(100/0/0) 0
VIEW DeploymentSummary.State nvarchar(100/0/0) 0
VIEW DeploymentSummary.TaskId nvarchar(100/0/0) 1
VIEW DeploymentSummary.TenantId nvarchar(100/0/0) 1
VIEW DeploymentSummary.Version nvarchar(200/0/0) 0
VIEW IdsInUse.Id nvarchar(900/0/0) 0
VIEW IdsInUse.Name nvarchar(400/0/0) 0
VIEW IdsInUse.Type varchar(237/0/0) 0
VIEW MultiTenancyDashboard.ChannelId nvarchar(100/0/0) 0
VIEW MultiTenancyDashboard.CompletedTime datetimeoffset(10/34/7) 1
VIEW MultiTenancyDashboard.Created datetimeoffset(10/34/7) 0
VIEW MultiTenancyDashboard.CurrentOrPrevious varchar(1/0/0) 0
VIEW MultiTenancyDashboard.EnvironmentId nvarchar(100/0/0) 0
VIEW MultiTenancyDashboard.ErrorMessage nvarchar(-1/0/0) 1
VIEW MultiTenancyDashboard.HasPendingInterruptions bit(1/1/0) 0
VIEW MultiTenancyDashboard.HasWarningsOrErrors bit(1/1/0) 0
VIEW MultiTenancyDashboard.Id nvarchar(100/0/0) 0
VIEW MultiTenancyDashboard.ProjectId nvarchar(100/0/0) 0
VIEW MultiTenancyDashboard.QueueTime datetimeoffset(10/34/7) 0
VIEW MultiTenancyDashboard.ReleaseId nvarchar(100/0/0) 0
VIEW MultiTenancyDashboard.State nvarchar(100/0/0) 0
VIEW MultiTenancyDashboard.TaskId nvarchar(100/0/0) 1
VIEW MultiTenancyDashboard.TenantId nvarchar(100/0/0) 1
VIEW MultiTenancyDashboard.Version nvarchar(200/0/0) 0
VIEW ProjectCurrentDashboard.ChannelId nvarchar(100/0/0) 0
VIEW ProjectCurrentDashboard.CompletedTime datetimeoffset(10/34/7) 1
VIEW ProjectCurrentDashboard.Created datetimeoffset(10/34/7) 0
VIEW ProjectCurrentDashboard.CurrentOrPrevious varchar(1/0/0) 0
VIEW ProjectCurrentDashboard.EnvironmentId nvarchar(100/0/0) 0
VIEW ProjectCurrentDashboard.ErrorMessage nvarchar(-1/0/0) 1
VIEW ProjectCurrentDashboard.HasPendingInterruptions bit(1/1/0) 0
VIEW ProjectCurrentDashboard.HasWarningsOrErrors bit(1/1/0) 0
VIEW ProjectCurrentDashboard.Id nvarchar(100/0/0) 0
VIEW ProjectCurrentDashboard.ProjectId nvarchar(100/0/0) 0
VIEW ProjectCurrentDashboard.QueueTime datetimeoffset(10/34/7) 0
VIEW ProjectCurrentDashboard.ReleaseId nvarchar(100/0/0) 0
VIEW ProjectCurrentDashboard.State nvarchar(100/0/0) 0
VIEW ProjectCurrentDashboard.TaskId nvarchar(100/0/0) 1
VIEW ProjectCurrentDashboard.TenantId nvarchar(100/0/0) 1
VIEW ProjectCurrentDashboard.Version nvarchar(200/0/0) 0
VIEW Release_LatestByProjectChannel.Assembled datetimeoffset(10/34/7) 0
VIEW Release_LatestByProjectChannel.ChannelId nvarchar(100/0/0) 0
VIEW Release_LatestByProjectChannel.Id nvarchar(300/0/0) 0
VIEW Release_LatestByProjectChannel.JSON nvarchar(-1/0/0) 0
VIEW Release_LatestByProjectChannel.ProjectDeploymentProcessSnapshotId nvarchar(300/0/0) 0
VIEW Release_LatestByProjectChannel.ProjectId nvarchar(300/0/0) 0
VIEW Release_LatestByProjectChannel.ProjectVariableSetSnapshotId nvarchar(300/0/0) 0
VIEW Release_LatestByProjectChannel.RowNum bigint(8/19/0) 1
VIEW Release_LatestByProjectChannel.Version nvarchar(200/0/0) 0
VIEW Release_WithDeploymentProcess.DeploymentProcess_Id nvarchar(300/0/0) 0
VIEW Release_WithDeploymentProcess.DeploymentProcess_IsFrozen bit(1/1/0) 0
VIEW Release_WithDeploymentProcess.DeploymentProcess_JSON nvarchar(-1/0/0) 0
VIEW Release_WithDeploymentProcess.DeploymentProcess_OwnerId nvarchar(300/0/0) 0
VIEW Release_WithDeploymentProcess.DeploymentProcess_RelatedDocumentIds nvarchar(-1/0/0) 1
VIEW Release_WithDeploymentProcess.DeploymentProcess_Version int(4/10/0) 0
VIEW Release_WithDeploymentProcess.Release_Assembled datetimeoffset(10/34/7) 0
VIEW Release_WithDeploymentProcess.Release_ChannelId nvarchar(100/0/0) 0
VIEW Release_WithDeploymentProcess.Release_Id nvarchar(300/0/0) 0
VIEW Release_WithDeploymentProcess.Release_JSON nvarchar(-1/0/0) 0
VIEW Release_WithDeploymentProcess.Release_ProjectDeploymentProcessSnapshotId nvarchar(300/0/0) 0
VIEW Release_WithDeploymentProcess.Release_ProjectId nvarchar(300/0/0) 0
VIEW Release_WithDeploymentProcess.Release_ProjectVariableSetSnapshotId nvarchar(300/0/0) 0
VIEW Release_WithDeploymentProcess.Release_Version nvarchar(200/0/0) 0
VIEW ReleaseCurrentDashboard.ChannelId nvarchar(100/0/0) 0
VIEW ReleaseCurrentDashboard.CompletedTime datetimeoffset(10/34/7) 1
VIEW ReleaseCurrentDashboard.Created datetimeoffset(10/34/7) 0
VIEW ReleaseCurrentDashboard.CurrentOrPrevious varchar(1/0/0) 0
VIEW ReleaseCurrentDashboard.EnvironmentId nvarchar(100/0/0) 0
VIEW ReleaseCurrentDashboard.ErrorMessage nvarchar(-1/0/0) 1
VIEW ReleaseCurrentDashboard.HasPendingInterruptions bit(1/1/0) 0
VIEW ReleaseCurrentDashboard.HasWarningsOrErrors bit(1/1/0) 0
VIEW ReleaseCurrentDashboard.Id nvarchar(100/0/0) 0
VIEW ReleaseCurrentDashboard.ProjectId nvarchar(100/0/0) 0
VIEW ReleaseCurrentDashboard.QueueTime datetimeoffset(10/34/7) 0
VIEW ReleaseCurrentDashboard.ReleaseId nvarchar(100/0/0) 0
VIEW ReleaseCurrentDashboard.State nvarchar(100/0/0) 0
VIEW ReleaseCurrentDashboard.TaskId nvarchar(100/0/0) 1
VIEW ReleaseCurrentDashboard.TenantId nvarchar(100/0/0) 1
VIEW ReleaseCurrentDashboard.Version nvarchar(200/0/0) 0
VIEW TenantProject.ProjectId nvarchar(100/0/0) 0
VIEW TenantProject.TenantId nvarchar(100/0/0) 0

rati_dzidziguri · 27 September 2016 12:44

U can resolve this there was dbo.sysdiagrams table in octopus database which i removed manually and everything seems to be ok now.

Kenneth_Bates · 29 September 2016 02:43

Hi,

Thanks for reaching out! Removing that table manually is exactly the correct thing to do. This table is created by SQL Management Studio when creating a diagram of the database. It causes this issue during an integrity check as we’re not expecting it. The table can be added by accident and will cause no harm to the integrity of the Octopus Database. We’ve created a GitHub issue to fix it by ignoring the table if it is added.

Kind regards,

Kenny

Octopus_Support · 4 January 2017 06:08

Notice:

This issue has been closed due to inactivity. If you encounter the same or a similar issue and require help, please open a new discussion (if we asked for logs or extra details in this thread, consider including them in the new thread). If you are the creator of this thread and believe it should not be closed let us know via our support email.