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

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

book

Article ID: 287016

calendar_today

Updated On:

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.