App Control: Upgrade fails with error Invalid column name 'hidden'

Products

• Carbon Black App Control (formerly Cb Protection)

Issue/Introduction

Upgrade is canceled with the error message:

A database script 'finalize' needed to install the Cb Protection Server failed with an error. 
Invalid column name 'hidden'

Environment

• App Control Server version 8.1.x

Cause

This is caused by a leftover config from a previous server upgrade.

Resolution

1. Stop the CB Protection Server and CB Protection Reporter services
2. Restore the DAS database from a full backup taken prior the upgrade
3. In SQL Management Studio navigate to Databases > DAS > Execute the following query:

   use das; select * from dbo.shepherd_configs where name like 'tmp_dbupgrade_step'

4. If the query result shows that the config is present, execute this query to delete it:

   use das; delete from dbo.shepherd_configs where name like 'tmp_dbupgrade_step'

5. Proceed with the upgrade attempt which should complete successfully

Additional Information

This issue is tracked internally as EP-10341