Integrity check failed

Legacy Execution
1

Updated from beta 1 to beta 2 and the system integrity check is failing now. Looks like a simple schema issue. Perhaps a schema upgrade didn’t happen in the update process?

Task ID: ServerTasks-2663
Task status: Failed
Task queued: Friday, July 22, 2016 8:12 AM
Task started: Friday, July 22, 2016 8:12 AM
Task duration: less than a second
Server version: 3.4.0-beta.2+Branch.release/3.4.0-beta.2.Sha.4ad7ee5a5eceec486e11e30eb8d51473a4bd5f0a

                | Failed: Check System Integrity

08:12:31 Error | Schema… [ Failed ]
08:12:31 Info | Orphaned channels… [ Passed ]
08:12:31 Info | Only one unfrozen deployment process per project… [ Passed ]
08:12:31 Fatal | One or more data errors where found.
|
| Running: Schema
08:12:31 Error | Unexpected item: VIEW dbo.IdsInUse.Id nvarchar(420/0/0) 0
| Missing item: VIEW dbo.IdsInUse.Id nvarchar(900/0/0) 0
|

2

Hi Mark,

Sorry for the delay getting back to you! When a view is created and then the schema for the table is updated, we previously were not refreshing the view to match. Thus causing this in our system integrity check.
As you have probably gathered it should not have caused any issues with your data integrity.

This is our GitHub issue if you would like to track it: https://github.com/OctopusDeploy/Issues/issues/2596

Thanks for letting us know, and sorry about the troubles.
Vanessa

3

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.