8.10.4 Server upgrade fails during migration section because of NULL yara tags

Products

• Carbon Black App Control (formerly Cb Protection)

Issue/Introduction

There is an error that happens during the Migrate section of the upgrade script that causes the following failure that is documented in the ServerInstall-<timestamp>.log:

<TIME> UPGRADEDB: [<TIME> #####/######] Cannot insert the value NULL into column 'tags', table 'das.dbo.Yara_Rule_Tag_Sets'; column does not allow nulls. INSERT fails.
<TIME> UPGRADEDB: Cannot insert the value NULL into column 'yara_rule_tag_set_id', table 'das.dbo.Yara_Rule_Tag_Set_Tags'; column does not allow nulls. INSERT fails.

Environment

• App Control Server: 8.10.2-8.10.4

Cause

The DAS database does not allow the insert of a NULL value into column 'yara_rule_tag_set_id' in the dbo.antibodies table.

Resolution

• App Control Engineering has created a script to remove NULL yara tag values from the database tables to make sure that none exist before attempting to upgrade.
• Reach out to support to get the script if needed.