App Control: Upgrade Fails with error "Implicit conversion from data type datetime to int is not allowed"

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 Carbon Black App Control Server failed with an error. 
  Implicit conversion from data type datetime to int is not allowed. Use the CONVERT function to run this query.

Environment

• App Control Server: 8.1.4
• Microsoft SQL Server: All Supported Versions

Cause

This is caused by an incorrect order of the columns in the dbo.Config_list table. 

Resolution

1. Back up the DAS database
2. Stop the App Control Server and App Control Reporter services
3. In SQL Management Studio navigate to Databases > DAS > Tables
4. Right click dbo.Config_list and click "Design"
5. Verify that the list of columns are in the following order:

   version
   type
   id
   deleted
   host_id
   data
   min_agent_version
   max_agent_version
   date_created
   platform_flags
   obsolete

6. If the order is different from the one listed above, click and drag the columns to match
7. Save the changes
   • If saving returns the following error:

     SQL Server Error: Saving Changes is not permitted. The changes you have made require the following tables to be dropped and recreated

   • Uncheck the box entitled Prevent saving changes that require table re-creation under Tools > Options > Designers
8. Restart the upgrade attempt

Additional Information

If there are no differences between the items above and your table, please open a case with technical support.