Check System Integrity fails with Azure SQL replicated DBs

iain.ferguson's Avatar

iain.ferguson

11 Jan, 2018 09:51 PM

Hi,

We are using an Azure SQL DB which which is geo replicated to meet our DR requirements. As part of this configuration Azure adds two additional schemas to the DB (DSS and TaskHosting) presumably to keep track of the internal replication state.

However this does cause the Octopus Integrity check to fail as it is not expecting to find these tables on the DB.

I have also noticed that during upgrades (from 3.X to 4.x) it tries and fails to remove these tables which isn't causing any issues we can see at the moment but could cause issues down the line if the update does actually manage to modify one of these tables. Also it's not great seeing lots of red errors when performing updates. :)

Would it be possible for Octopus to limit this check to just the dbo schema or some way of white-listing known differences on a DB to the expected Octopus schema.

Unexpected item: FK dss.FK__agent__subscript__3552E9B6 subscriptionid->id
Unexpected item: FK dss.FK__agent_ins__agent__345EC57D agentid->id
Unexpected item: FK dss.FK__ScheduleT__SyncG__2F9A1060 SyncGroupId->id
Unexpected item: FK dss.FK__syncgroup__datab__36470DEF databaseid->id
Unexpected item: FK dss.FK__syncgroup__hub_m__336AA144 hub_memberid->id
Unexpected item: FK dss.FK__syncgroup__subsc__32767D0B subscriptionid->id
Unexpected item: FK dss.FK__syncgroup__syncg__373B3228 syncgroupid->id
Unexpected item: FK dss.FK__task__actionid__2DB1C7EE actionid->id
Unexpected item: FK dss.FK__taskdepen__nextt__318258D2 nexttaskid->id
Unexpected item: FK dss.FK__taskdepen__prevt__308E3499 prevtaskid->id
Unexpected item: FK dss.FK__userdatab__subsc__2EA5EC27 subscriptionid->id
Unexpected item: FK TaskHosting.FK__MessageQu__JobId__2C88998B JobId->JobId
Unexpected item: FK TaskHosting.FK__ScheduleT__Sched__370627FE Schedule->ScheduleId
Unexpected item: IDX dss.IX_SubscriptionId_Name name
Unexpected item: IDX dss.IX_SubscriptionId_Name NONCLUSTERED 1
Unexpected item: IDX dss.IX_SubscriptionId_Name subscriptionid
Unexpected item: IDX dss.IX_SyncGroupMember_SyncGroupId_DatabaseId databaseid
Unexpected item: IDX dss.IX_SyncGroupMember_SyncGroupId_DatabaseId NONCLUSTERED 1
Unexpected item: IDX dss.IX_SyncGroupMember_SyncGroupId_DatabaseId syncgroupid
Unexpected item: IDX dss.PK__action__3213E83F47B66DFC CLUSTERED 0
Unexpected item: IDX dss.PK__action__3213E83F47B66DFC id
Unexpected item: IDX dss.PK__agent__3213E83F042F78C3 CLUSTERED 0
Unexpected item: IDX dss.PK__agent__3213E83F042F78C3 id
Unexpected item: IDX dss.PK__agent_in__3213E83FC3DEF56A CLUSTERED 0
Unexpected item: IDX dss.PK__agent_in__3213E83FC3DEF56A id
Unexpected item: IDX dss.PK__agent_ve__3214EC072E1CDB2B CLUSTERED 0
Unexpected item: IDX dss.PK__agent_ve__3214EC072E1CDB2B Id
Unexpected item: IDX dss.PK__configur__3214EC07B0FC7136 CLUSTERED 0
Unexpected item: IDX dss.PK__configur__3214EC07B0FC7136 Id
Unexpected item: IDX dss.PK__EnumType__3214EC07055240AE CLUSTERED 0
Unexpected item: IDX dss.PK__EnumType__3214EC07055240AE Id
Unexpected item: IDX dss.PK__MetaInfo__3214EC07767ADDAC CLUSTERED 0
Unexpected item: IDX dss.PK__MetaInfo__3214EC07767ADDAC Id
Unexpected item: IDX dss.PK__scaleuni__3214EC074A173E25 CLUSTERED 0
Unexpected item: IDX dss.PK__scaleuni__3214EC074A173E25 Id
Unexpected item: IDX dss.PK__subscrip__3213E83F5FA40C12 CLUSTERED 0
Unexpected item: IDX dss.PK__subscrip__3213E83F5FA40C12 id
Unexpected item: IDX dss.PK__syncgrou__3213E83F6F7E6F17 CLUSTERED 0
Unexpected item: IDX dss.PK__syncgrou__3213E83F6F7E6F17 id
Unexpected item: IDX dss.PK__syncgrou__3213E83F8B506C16 CLUSTERED 0
Unexpected item: IDX dss.PK__syncgrou__3213E83F8B506C16 id
Unexpected item: IDX dss.PK__task__3213E83F742C3D97 CLUSTERED 0
Unexpected item: IDX dss.PK__task__3213E83F742C3D97 id
Unexpected item: IDX dss.PK__userdata__3213E83FBBDC60AE CLUSTERED 0
Unexpected item: IDX dss.PK__userdata__3213E83FBBDC60AE id
Unexpected item: IDX dss.PK_ScheduleTask CLUSTERED 0
Unexpected item: IDX dss.PK_ScheduleTask SyncGroupId
Unexpected item: IDX dss.PK_TaskTask CLUSTERED 0
Unexpected item: IDX dss.PK_TaskTask nexttaskid
Unexpected item: IDX dss.PK_TaskTask prevtaskid
Unexpected item: IDX dss.UQ__agent_ve__0F5401349D924F68 NONCLUSTERED 1
Unexpected item: IDX dss.UQ__agent_ve__0F5401349D924F68 Version
Unexpected item: IDX TaskHosting.PK__Job__056690C2CD20CD41 CLUSTERED 0
Unexpected item: IDX TaskHosting.PK__Job__056690C2CD20CD41 JobId
Unexpected item: IDX TaskHosting.PK__MessageQ__C87C0C9C53E6C966 CLUSTERED 0
Unexpected item: IDX TaskHosting.PK__MessageQ__C87C0C9C53E6C966 MessageId
Unexpected item: IDX TaskHosting.PK__MetaInfo__3214EC07BFC680C3 CLUSTERED 0
Unexpected item: IDX TaskHosting.PK__MetaInfo__3214EC07BFC680C3 Id
Unexpected item: IDX TaskHosting.PK__Schedule__8DAD173A5BC1798E CLUSTERED 0
Unexpected item: IDX TaskHosting.PK__Schedule__8DAD173A5BC1798E ScheduleTaskId
Unexpected item: IDX TaskHosting.PK__Schedule__9C8A5B49C06C02DB CLUSTERED 0
Unexpected item: IDX TaskHosting.PK__Schedule__9C8A5B49C06C02DB ScheduleId
Unexpected item: USER_TABLE dss.action.creationtime datetime(8/23/3) 1
Unexpected item: USER_TABLE dss.action.id uniqueidentifier(16/0/0) 0
Unexpected item: USER_TABLE dss.action.lastupdatetime datetime(8/23/3) 1
Unexpected item: USER_TABLE dss.action.state int(4/10/0) 0
Unexpected item: USER_TABLE dss.action.syncgroupid uniqueidentifier(16/0/0) 1
Unexpected item: USER_TABLE dss.action.type int(4/10/0) 0
Unexpected item: USER_TABLE dss.agent.id uniqueidentifier(16/0/0) 0
Unexpected item: USER_TABLE dss.agent.is_on_premise bit(1/1/0) 0
Unexpected item: USER_TABLE dss.agent.lastalivetime datetime(8/23/3) 1
Unexpected item: USER_TABLE dss.agent.name DISPLAY_NAME(280/0/0) 1
Unexpected item: USER_TABLE dss.agent.password_hash PASSWORD_HASH(256/0/0) 1
Unexpected item: USER_TABLE dss.agent.password_salt PASSWORD_SALT(256/0/0) 1
Unexpected item: USER_TABLE dss.agent.state int(4/10/0) 1
Unexpected item: USER_TABLE dss.agent.subscriptionid uniqueidentifier(16/0/0) 1
Unexpected item: USER_TABLE dss.agent.version VERSION(80/0/0) 1
Unexpected item: USER_TABLE dss.agent_instance.agentid uniqueidentifier(16/0/0) 0
Unexpected item: USER_TABLE dss.agent_instance.id uniqueidentifier(16/0/0) 0
Unexpected item: USER_TABLE dss.agent_instance.lastalivetime datetime(8/23/3) 1
Unexpected item: USER_TABLE dss.agent_instance.version VERSION(80/0/0) 0
Unexpected item: USER_TABLE dss.agent_version.Comment nvarchar(400/0/0) 1
Unexpected item: USER_TABLE dss.agent_version.ExpiresOn datetime(8/23/3) 0
Unexpected item: USER_TABLE dss.agent_version.Id int(4/10/0) 0
Unexpected item: USER_TABLE dss.agent_version.Version nvarchar(100/0/0) 0
Unexpected item: USER_TABLE dss.configuration.ConfigKey nvarchar(200/0/0) 0
Unexpected item: USER_TABLE dss.configuration.ConfigValue nvarchar(512/0/0) 0
Unexpected item: USER_TABLE dss.configuration.Id int(4/10/0) 0
Unexpected item: USER_TABLE dss.configuration.LastModified datetime(8/23/3) 0
Unexpected item: USER_TABLE dss.EnumType.EnumId int(4/10/0) 0
Unexpected item: USER_TABLE dss.EnumType.Id int(4/10/0) 0
Unexpected item: USER_TABLE dss.EnumType.LastModified datetime(8/23/3) 0
Unexpected item: USER_TABLE dss.EnumType.Name nvarchar(200/0/0) 0
Unexpected item: USER_TABLE dss.EnumType.Type varchar(100/0/0) 0
Unexpected item: USER_TABLE dss.MetaInformation.Id int(4/10/0) 0
Unexpected item: USER_TABLE dss.MetaInformation.State bit(1/1/0) 0
Unexpected item: USER_TABLE dss.MetaInformation.Timestamp datetime(8/23/3) 0
Unexpected item: USER_TABLE dss.MetaInformation.Version bigint(8/19/0) 1
Unexpected item: USER_TABLE dss.MetaInformation.VersionBuild int(4/10/0) 0
Unexpected item: USER_TABLE dss.MetaInformation.VersionMajor int(4/10/0) 0
Unexpected item: USER_TABLE dss.MetaInformation.VersionMinor int(4/10/0) 0
Unexpected item: USER_TABLE dss.MetaInformation.VersionService int(4/10/0) 0
Unexpected item: USER_TABLE dss.MetaInformation.VersionString varchar(50/0/0) 1
Unexpected item: USER_TABLE dss.scaleunitlimits.Id int(4/10/0) 0
Unexpected item: USER_TABLE dss.scaleunitlimits.LastModified datetime(8/23/3) 0
Unexpected item: USER_TABLE dss.scaleunitlimits.MaxValue int(4/10/0) 0
Unexpected item: USER_TABLE dss.scaleunitlimits.Name nvarchar(200/0/0) 0
Unexpected item: USER_TABLE dss.ScheduleTask.DequeueCount tinyint(1/3/0) 0
Unexpected item: USER_TABLE dss.ScheduleTask.ExpirationTime datetime(8/23/3) 1
Unexpected item: USER_TABLE dss.ScheduleTask.Id uniqueidentifier(16/0/0) 0
Unexpected item: USER_TABLE dss.ScheduleTask.Interval bigint(8/19/0) 0
Unexpected item: USER_TABLE dss.ScheduleTask.LastUpdate datetime(8/23/3) 0
Unexpected item: USER_TABLE dss.ScheduleTask.PopReceipt uniqueidentifier(16/0/0) 1
Unexpected item: USER_TABLE dss.ScheduleTask.State tinyint(1/3/0) 0
Unexpected item: USER_TABLE dss.ScheduleTask.SyncGroupId uniqueidentifier(16/0/0) 0
Unexpected item: USER_TABLE dss.ScheduleTask.Type int(4/10/0) 0
Unexpected item: USER_TABLE dss.subscription.creationtime datetime(8/23/3) 1
Unexpected item: USER_TABLE dss.subscription.EnableDetailedProviderTracing bit(1/1/0) 1
Unexpected item: USER_TABLE dss.subscription.id uniqueidentifier(16/0/0) 0
Unexpected item: USER_TABLE dss.subscription.lastlogintime datetime(8/23/3) 1
Unexpected item: USER_TABLE dss.subscription.name DISPLAY_NAME(280/0/0) 1
Unexpected item: USER_TABLE dss.subscription.policyid int(4/10/0) 1
Unexpected item: USER_TABLE dss.subscription.subscriptionstate tinyint(1/3/0) 0
Unexpected item: USER_TABLE dss.subscription.syncserveruniquename nvarchar(512/0/0) 1
Unexpected item: USER_TABLE dss.subscription.tombstoneretentionperiodindays int(4/10/0) 0
Unexpected item: USER_TABLE dss.subscription.version VERSION(80/0/0) 1
Unexpected item: USER_TABLE dss.subscription.WindowsAzureSubscriptionId uniqueidentifier(16/0/0) 1
Unexpected item: USER_TABLE dss.syncgroup.conflict_resolution_policy int(4/10/0) 0
Unexpected item: USER_TABLE dss.syncgroup.hub_memberid uniqueidentifier(16/0/0) 1
Unexpected item: USER_TABLE dss.syncgroup.hubhasdata bit(1/1/0) 1
Unexpected item: USER_TABLE dss.syncgroup.id uniqueidentifier(16/0/0) 0
Unexpected item: USER_TABLE dss.syncgroup.lastupdatetime datetime(8/23/3) 1
Unexpected item: USER_TABLE dss.syncgroup.name DISPLAY_NAME(280/0/0) 1
Unexpected item: USER_TABLE dss.syncgroup.ocsschemadefinition DB_SCHEMA(-1/0/0) 1
Unexpected item: USER_TABLE dss.syncgroup.schema_description xml(-1/0/0) 1
Unexpected item: USER_TABLE dss.syncgroup.state int(4/10/0) 1
Unexpected item: USER_TABLE dss.syncgroup.subscriptionid uniqueidentifier(16/0/0) 1
Unexpected item: USER_TABLE dss.syncgroup.sync_enabled bit(1/1/0) 0
Unexpected item: USER_TABLE dss.syncgroup.sync_interval int(4/10/0) 0
Unexpected item: USER_TABLE dss.syncgroupmember.databaseid uniqueidentifier(16/0/0) 0
Unexpected item: USER_TABLE dss.syncgroupmember.hubJobId uniqueidentifier(16/0/0) 1
Unexpected item: USER_TABLE dss.syncgroupmember.hubstate int(4/10/0) 0
Unexpected item: USER_TABLE dss.syncgroupmember.hubstate_lastupdated datetime(8/23/3) 0
Unexpected item: USER_TABLE dss.syncgroupmember.id uniqueidentifier(16/0/0) 0
Unexpected item: USER_TABLE dss.syncgroupmember.jobId uniqueidentifier(16/0/0) 1
Unexpected item: USER_TABLE dss.syncgroupmember.lastsynctime datetime(8/23/3) 1
Unexpected item: USER_TABLE dss.syncgroupmember.lastsynctime_zerofailures_hub datetime(8/23/3) 1
Unexpected item: USER_TABLE dss.syncgroupmember.lastsynctime_zerofailures_member datetime(8/23/3) 1
Unexpected item: USER_TABLE dss.syncgroupmember.memberhasdata bit(1/1/0) 1
Unexpected item: USER_TABLE dss.syncgroupmember.memberstate int(4/10/0) 0
Unexpected item: USER_TABLE dss.syncgroupmember.memberstate_lastupdated datetime(8/23/3) 0
Unexpected item: USER_TABLE dss.syncgroupmember.name DISPLAY_NAME(280/0/0) 0
Unexpected item: USER_TABLE dss.syncgroupmember.noinitsync bit(1/1/0) 0
Unexpected item: USER_TABLE dss.syncgroupmember.scopename nvarchar(200/0/0) 0
Unexpected item: USER_TABLE dss.syncgroupmember.syncdirection int(4/10/0) 0
Unexpected item: USER_TABLE dss.syncgroupmember.syncgroupid uniqueidentifier(16/0/0) 0
Unexpected item: USER_TABLE dss.task.actionid uniqueidentifier(16/0/0) 0
Unexpected item: USER_TABLE dss.task.agentid uniqueidentifier(16/0/0) 1
Unexpected item: USER_TABLE dss.task.completedtime datetime(8/23/3) 1
Unexpected item: USER_TABLE dss.task.creationtime datetime(8/23/3) 1
Unexpected item: USER_TABLE dss.task.dependency_count int(4/10/0) 0
Unexpected item: USER_TABLE dss.task.id uniqueidentifier(16/0/0) 0
Unexpected item: USER_TABLE dss.task.lastheartbeat datetime(8/23/3) 1
Unexpected item: USER_TABLE dss.task.lastresettime datetime(8/23/3) 1
Unexpected item: USER_TABLE dss.task.owning_instanceid uniqueidentifier(16/0/0) 1
Unexpected item: USER_TABLE dss.task.pickuptime datetime(8/23/3) 1
Unexpected item: USER_TABLE dss.task.priority int(4/10/0) 1
Unexpected item: USER_TABLE dss.task.request TASK_REQUEST_RESPONSE(-1/0/0) 1
Unexpected item: USER_TABLE dss.task.response TASK_REQUEST_RESPONSE(-1/0/0) 1
Unexpected item: USER_TABLE dss.task.retry_count int(4/10/0) 0
Unexpected item: USER_TABLE dss.task.state int(4/10/0) 1
Unexpected item: USER_TABLE dss.task.taskNumber bigint(8/19/0) 0
Unexpected item: USER_TABLE dss.task.type int(4/10/0) 1
Unexpected item: USER_TABLE dss.task.version bigint(8/19/0) 0
Unexpected item: USER_TABLE dss.taskdependency.nexttaskid uniqueidentifier(16/0/0) 0
Unexpected item: USER_TABLE dss.taskdependency.prevtaskid uniqueidentifier(16/0/0) 0
Unexpected item: USER_TABLE dss.UIHistory.agentid uniqueidentifier(16/0/0) 0
Unexpected item: USER_TABLE dss.UIHistory.completionTime datetime2(8/27/7) 0
Unexpected item: USER_TABLE dss.UIHistory.databaseid uniqueidentifier(16/0/0) 0
Unexpected item: USER_TABLE dss.UIHistory.detailEnumId nvarchar(800/0/0) 0
Unexpected item: USER_TABLE dss.UIHistory.detailStringParameters nvarchar(-1/0/0) 1
Unexpected item: USER_TABLE dss.UIHistory.id uniqueidentifier(16/0/0) 0
Unexpected item: USER_TABLE dss.UIHistory.isWritable bit(1/1/0) 1
Unexpected item: USER_TABLE dss.UIHistory.recordType int(4/10/0) 0
Unexpected item: USER_TABLE dss.UIHistory.serverid uniqueidentifier(16/0/0) 0
Unexpected item: USER_TABLE dss.UIHistory.syncgroupId uniqueidentifier(16/0/0) 0
Unexpected item: USER_TABLE dss.UIHistory.taskType int(4/10/0) 0
Unexpected item: USER_TABLE dss.userdatabase.agentid uniqueidentifier(16/0/0) 0
Unexpected item: USER_TABLE dss.userdatabase.connection_string varbinary(-1/0/0) 1
Unexpected item: USER_TABLE dss.userdatabase.database nvarchar(512/0/0) 1
Unexpected item: USER_TABLE dss.userdatabase.db_schema DB_SCHEMA(-1/0/0) 1
Unexpected item: USER_TABLE dss.userdatabase.id uniqueidentifier(16/0/0) 0
Unexpected item: USER_TABLE dss.userdatabase.is_on_premise bit(1/1/0) 0
Unexpected item: USER_TABLE dss.userdatabase.jobId uniqueidentifier(16/0/0) 1
Unexpected item: USER_TABLE dss.userdatabase.last_schema_updated datetime(8/23/3) 1
Unexpected item: USER_TABLE dss.userdatabase.last_tombstonecleanup datetime(8/23/3) 1
Unexpected item: USER_TABLE dss.userdatabase.region nvarchar(512/0/0) 1
Unexpected item: USER_TABLE dss.userdatabase.server nvarchar(512/0/0) 1
Unexpected item: USER_TABLE dss.userdatabase.sqlazure_info xml(-1/0/0) 1
Unexpected item: USER_TABLE dss.userdatabase.state int(4/10/0) 0
Unexpected item: USER_TABLE dss.userdatabase.subscriptionid uniqueidentifier(16/0/0) 0
Unexpected item: USER_TABLE TaskHosting.Job.CompletedTaskCount int(4/10/0) 0
Unexpected item: USER_TABLE TaskHosting.Job.InitialInsertTimeUTC datetime(8/23/3) 0
Unexpected item: USER_TABLE TaskHosting.Job.InputData nvarchar(-1/0/0) 1
Unexpected item: USER_TABLE TaskHosting.Job.IsCancelled bit(1/1/0) 0
Unexpected item: USER_TABLE TaskHosting.Job.JobId uniqueidentifier(16/0/0) 0
Unexpected item: USER_TABLE TaskHosting.Job.JobType int(4/10/0) 0
Unexpected item: USER_TABLE TaskHosting.Job.TaskCount int(4/10/0) 0
Unexpected item: USER_TABLE TaskHosting.Job.TracingId uniqueidentifier(16/0/0) 1
Unexpected item: USER_TABLE TaskHosting.MessageQueue.ExecTimes tinyint(1/3/0) 0
Unexpected item: USER_TABLE TaskHosting.MessageQueue.InitialInsertTimeUTC datetime(8/23/3) 0
Unexpected item: USER_TABLE TaskHosting.MessageQueue.InsertTimeUTC datetime(8/23/3) 0
Unexpected item: USER_TABLE TaskHosting.MessageQueue.JobId uniqueidentifier(16/0/0) 1
Unexpected item: USER_TABLE TaskHosting.MessageQueue.MessageData nvarchar(-1/0/0) 1
Unexpected item: USER_TABLE TaskHosting.MessageQueue.MessageId uniqueidentifier(16/0/0) 0
Unexpected item: USER_TABLE TaskHosting.MessageQueue.MessageType int(4/10/0) 0
Unexpected item: USER_TABLE TaskHosting.MessageQueue.QueueId uniqueidentifier(16/0/0) 1
Unexpected item: USER_TABLE TaskHosting.MessageQueue.ResetTimes int(4/10/0) 0
Unexpected item: USER_TABLE TaskHosting.MessageQueue.TracingId uniqueidentifier(16/0/0) 1
Unexpected item: USER_TABLE TaskHosting.MessageQueue.UpdateTimeUTC datetime(8/23/3) 1
Unexpected item: USER_TABLE TaskHosting.MessageQueue.Version bigint(8/19/0) 0
Unexpected item: USER_TABLE TaskHosting.MessageQueue.WorkerId uniqueidentifier(16/0/0) 1
Unexpected item: USER_TABLE TaskHosting.MetaInformation.Id int(4/10/0) 0
Unexpected item: USER_TABLE TaskHosting.MetaInformation.State bit(1/1/0) 0
Unexpected item: USER_TABLE TaskHosting.MetaInformation.Timestamp datetime(8/23/3) 0
Unexpected item: USER_TABLE TaskHosting.MetaInformation.Version bigint(8/19/0) 1
Unexpected item: USER_TABLE TaskHosting.MetaInformation.VersionBuild int(4/10/0) 0
Unexpected item: USER_TABLE TaskHosting.MetaInformation.VersionMajor int(4/10/0) 0
Unexpected item: USER_TABLE TaskHosting.MetaInformation.VersionMinor int(4/10/0) 0
Unexpected item: USER_TABLE TaskHosting.MetaInformation.VersionService int(4/10/0) 0
Unexpected item: USER_TABLE TaskHosting.MetaInformation.VersionString varchar(50/0/0) 1
Unexpected item: USER_TABLE TaskHosting.Schedule.FreqInterval int(4/10/0) 0
Unexpected item: USER_TABLE TaskHosting.Schedule.FreqType int(4/10/0) 0
Unexpected item: USER_TABLE TaskHosting.Schedule.ScheduleId int(4/10/0) 0
Unexpected item: USER_TABLE TaskHosting.ScheduleTask.JobId uniqueidentifier(16/0/0) 0
Unexpected item: USER_TABLE TaskHosting.ScheduleTask.MessageId uniqueidentifier(16/0/0) 1
Unexpected item: USER_TABLE TaskHosting.ScheduleTask.NextRunTime datetime(8/23/3) 0
Unexpected item: USER_TABLE TaskHosting.ScheduleTask.QueueId uniqueidentifier(16/0/0) 0
Unexpected item: USER_TABLE TaskHosting.ScheduleTask.Schedule int(4/10/0) 1
Unexpected item: USER_TABLE TaskHosting.ScheduleTask.ScheduleTaskId uniqueidentifier(16/0/0) 0
Unexpected item: USER_TABLE TaskHosting.ScheduleTask.State int(4/10/0) 0
Unexpected item: USER_TABLE TaskHosting.ScheduleTask.TaskInput nvarchar(-1/0/0) 1
Unexpected item: USER_TABLE TaskHosting.ScheduleTask.TaskName nvarchar(256/0/0) 0
Unexpected item: USER_TABLE TaskHosting.ScheduleTask.TaskType int(4/10/0) 0
Unexpected item: USER_TABLE TaskHosting.ScheduleTask.TracingId uniqueidentifier(16/0/0) 0

Thanks.

  1. Support Staff 1 Posted by Alex Rolley on 12 Jan, 2018 12:16 AM

    Alex Rolley's Avatar

    Hi Iain,

    Thanks for getting in touch!

    This feature isn't on our current roadmap, so I would suggest raising a UserVoice so that we can gauge how much interest there is in this feature. Our Program Management team are actively monitoring our UserVoices so this is the best path to request future features.

    Thanks Iain, please let me know if there is anything else we can assist with,

    Regards,
    Alex

  2. 2 Posted by iain.ferguson on 14 Jan, 2018 11:35 PM

    iain.ferguson's Avatar
  3. Support Staff 3 Posted by Alex Rolley on 15 Jan, 2018 07:06 AM

    Alex Rolley's Avatar

    Hi Iain,

    Thanks for that, will make sure that this suggestion get's in front of our Program Management team :)

    Happy deploying!

    Alex

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac