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
Back up the DAS database
Stop the App Control Server and App Control Reporter services
In SQL Management Studio navigate to Databases > DAS > Tables
Right click dbo.Config_list and click "Design"
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
If the order is different from the one listed above, click and drag the columns to match
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
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.