I just noticed a Check System Integrity Task that is failing on our production Octopus server. What is going on? Is this something I need to worry about? Anything we can do to fix this?
Task ID: ServerTasks-27182
Task status: Failed
Task queued: 21. juni 2016 08:43
Task started: 21. juni 2016 08:43
Task duration: less than a second
Server version: 3.3.18+Branch.master.Sha.35d5fa30e1297f96d082e900e1d7a50edff2d789
| Failed: Check System Integrity
08:43:06 Error | Schema… [ Failed ]
08:43:06 Info | Orphaned channels… [ Passed ]
08:43:06 Info | Only one unfrozen deployment process per project… [ Passed ]
08:43:06 Fatal | One or more data errors where found.
|
| Running: Schema
08:43:06 Error | An error occured running the check
| Unable to cast object of type ‘System.DBNull’ to type ‘System.String’.
| System.InvalidCastException: Unable to cast object of type ‘System.DBNull’ to type ‘System.String’.
| at Octopus.Server.Orchestration.SystemIntegrityCheck.Checks.SchemaHasNotChangedCheck.<>c__DisplayClass7_0.b__0(IDataReader dr) in Y:\Work\refs\tags\3.3.18\source\Octopus.Server\Orchestration\SystemIntegrityCheck\Checks\SchemaHasNotChangedCheck.cs:line 76
| at Octopus.Core.RelationalStorage.RelationalTransaction.ExecuteReader(String query, CommandParameters args, Action`1 readerCallback) in Y:\Work\refs\tags\3.3.18\source\Octopus.Core\RelationalStorage\RelationalTransaction.cs:line 428
| at Octopus.Server.Orchestration.SystemIntegrityCheck.Checks.SchemaHasNotChangedCheck.GetCurrentSchema() in Y:\Work\refs\tags\3.3.18\source\Octopus.Server\Orchestration\SystemIntegrityCheck\Checks\SchemaHasNotChangedCheck.cs:line 79
| at Octopus.Server.Orchestration.SystemIntegrityCheck.Checks.SchemaHasNotChangedCheck.Execute() in Y:\Work\refs\tags\3.3.18\source\Octopus.Server\Orchestration\SystemIntegrityCheck\Checks\SchemaHasNotChangedCheck.cs:line 47
| at Octopus.Server.Orchestration.SystemIntegrityCheck.SystemIntegrityCheckTaskController.PerformCheck(ISystemIntegrityCheck check) in Y:\Work\refs\tags\3.3.18\source\Octopus.Server\Orchestration\SystemIntegrityCheck\SystemIntegrityCheckTaskController.cs:line 43
| Octopus.Server version 3.3.18 (3.3.18+Branch.master.Sha.35d5fa30e1297f96d082e900e1d7a50edff2d789)
|
Hi Jan,
Thanks for getting in touch! The error itself is that it is having problems reading the schema, and should not be a concern. However we would like to get to the bottom of why it cannot read your schema. Are you able to run the following query as the user that Octopus connects as and let us know the output.
SELECT o.[type_desc] COLLATE DATABASE_DEFAULT + ' ' + o.name + '.' + c.name + ' ' + t.name + '(' + Cast(c.max_length as varchar(10)) + '/' + Cast(c.[precision] as varchar(10))+ '/' + Cast(c.scale as varchar(10)) + ') ' + Cast(c.is_nullable as char(1))
FROM sys.objects o
INNER JOIN sys.columns c ON o.object_id = c.object_id
INNER JOIN sys.types t on c.user_type_id = t.user_type_id
WHERE o.[type] in ('U', 'V', 'IX')
UNION ALL
SELECT f.name + ' ' + pc.name + '->' + rc.name
FROM sys.foreign_keys f
INNER JOIN sys.foreign_key_columns fc on f.object_id = fc.constraint_object_id
INNER JOIN sys.all_columns pc on fc.parent_object_id = pc.object_id AND pc.column_id = fc.parent_column_id
INNER JOIN sys.all_columns rc on fc.referenced_object_id = rc.object_id AND rc.column_id = fc.referenced_column_id
UNION ALL
SELECT i.name + ' ' + i.type_desc COLLATE DATABASE_DEFAULT + ' ' + cast(i.is_unique_constraint as char(1))
FROM sys.indexes i
INNER JOIN sys.objects o on i.object_id = o.object_id
WHERE o.[type] = 'U'
UNION ALL
SELECT i.name + ' ' + c.name
FROM sys.indexes i
INNER JOIN sys.objects o on i.object_id = o.object_id
INNER JOIN sys.index_columns ic on ic.object_id = i.object_id AND ic.index_id = i.index_id
INNER JOIN sys.all_columns c on ic.object_id = c.object_id AND ic.column_id = c.column_id
WHERE o.[type] = 'U'
ORDER BY 1
Thanks!
Vanessa
The result is listed below. As you can see the first row returned as a NULL value. So that is probably the cause. We probably need a new query with more details to find out what the NULL row is
(No column name)
NULL
FK_EventRelatedDocument_EventId EventId->Id
IX_Channel_ProjectId NONCLUSTERED 0
IX_Channel_ProjectId ProjectId
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_DeploymentHistory_Created Created
IX_DeploymentHistory_Created NONCLUSTERED 0
IX_EventRelatedDocument_EventId EventId
IX_EventRelatedDocument_EventId Id
IX_EventRelatedDocument_EventId NONCLUSTERED 0
IX_EventRelatedDocument_RelatedDocumentId NONCLUSTERED 0
IX_EventRelatedDocument_RelatedDocumentId RelatedDocumentId
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
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_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_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_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_Team_Id CLUSTERED 0
PK_Team_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
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_ProjectGroupNameUnique Name
UQ_ProjectGroupNameUnique NONCLUSTERED 1
UQ_ProjectNameUnique Name
UQ_ProjectNameUnique NONCLUSTERED 1
UQ_ProjectSlugUnique NONCLUSTERED 1
UQ_ProjectSlugUnique Slug
UQ_ReleaseVersionUnique NONCLUSTERED 1
UQ_ReleaseVersionUnique ProjectId
UQ_ReleaseVersionUnique Version
UQ_TeamNameUnique Name
UQ_TeamNameUnique NONCLUSTERED 1
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 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 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 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.JSON nvarchar(-1/0/0) 0
USER_TABLE Deployment.Created datetimeoffset(10/34/7) 0
USER_TABLE Deployment.DeployedBy nvarchar(400/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 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.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 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 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.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.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.Name nvarchar(400/0/0) 0
USER_TABLE Machine.Roles nvarchar(-1/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(300/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(500/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.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 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.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 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 tmp_DeploymentProcess.Id nvarchar(300/0/0) 0
USER_TABLE tmp_DeploymentProcess.IsFrozen bit(1/1/0) 0
USER_TABLE tmp_DeploymentProcess.JSON nvarchar(-1/0/0) 0
USER_TABLE tmp_DeploymentProcess.OwnerId nvarchar(300/0/0) 0
USER_TABLE tmp_DeploymentProcess.Version int(4/10/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.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.Version nvarchar(400/0/0) 0
VIEW IdsInUse.Id nvarchar(300/0/0) 0
VIEW IdsInUse.Name nvarchar(400/0/0) 0
VIEW IdsInUse.Type varchar(168/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
I’ve now upgraded the server to Octopus version 3.3.19 and the Check System Integrity task now fail with a new schema error. Is this a problem with the check or a issue in our database? How can we fix this?
Task ID: ServerTasks-27306
Task status: Failed
Task queued: 22. juni 2016 08:55
Task started: 22. juni 2016 08:55
Task duration: less than a second
Server version: 3.3.19+Branch.master.Sha.86840c27e8b40146623df82b50dcc1f22ddb21f4
| Failed: Check System Integrity
08:55:24 Error | Schema… [ Failed ]
08:55:24 Info | Orphaned channels… [ Passed ]
08:55:24 Info | Only one unfrozen deployment process per project… [ Passed ]
08:55:24 Fatal | One or more data errors where found.
|
| Running: Schema
08:55:24 Error | Unexpected item: USER_TABLE dbo.tmp_DeploymentProcess.Id nvarchar(300/0/0) 0
| Unexpected item: USER_TABLE dbo.tmp_DeploymentProcess.IsFrozen bit(1/1/0) 0
| Unexpected item: USER_TABLE dbo.tmp_DeploymentProcess.JSON nvarchar(-1/0/0) 0
| Unexpected item: USER_TABLE dbo.tmp_DeploymentProcess.OwnerId nvarchar(300/0/0) 0
| Unexpected item: USER_TABLE dbo.tmp_DeploymentProcess.Version int(4/10/0) 0
|
Hi Jan,
We released a fix to handle that null value, but it will then still fail as you have an extra table (tmp_DeploymentProcess) that we are not expecting.
It will also log this daily as we so you will need to either ignore it failing and keep your changes. We introduced this for cases when import and migration tools were corrupting databases, but in your case it will keep registering as a mismatch.
To get a passed result you will need to delete this temporary table.
Vanessa
We will delete this tmp table if it’s not needed. This is not something that we have created. I assume it’s a leftover from migration from an earlier version of Octopus or one of the updates?
Hi Jan,
I’ve had it confirmed that this table would have been created by one of our early scripts. It should be safe to delete. But please take a backup of your database first.
Vanessa
Table deleted and problem solved
Thanks
/Jan