App Control: Server upgrade failed from 8.1.0 to 8.1.10
search cancel

App Control: Server upgrade failed from 8.1.0 to 8.1.10

book

Article ID: 288644

calendar_today

Updated On:

Products

Carbon Black App Control (formerly Cb Protection)

Issue/Introduction

  • Upgrade is successful until 8.1.4 . Upgrade failed during database migration from 8.1.4 to version 8.1.6 or 8.1.10.
  • Upgrade log output 
    14:19:03 UPGRADEDB: [14:15:21 92893/186078] ...Starting upgrade transaction from 8.1.4 to 8.1.6 ...
    14:19:03 UPGRADEDB:
    14:19:03 UPGRADEDB: [14:15:22 92898/186078] migrate_814_to_816.sql:15
    14:19:03 UPGRADEDB: [14:15:22 92905/186078] migrate_814_to_816.sql:20
    14:19:03 UPGRADEDB: [14:15:22 92965/186078] migrate_814_to_816.sql:78
    14:19:03 UPGRADEDB: [14:15:22 93180/186078] migrate_814_to_816.sql:291
    14:19:03 UPGRADEDB: [14:15:22 93254/186078] migrate_814_to_816.sql:349
    14:19:03 UPGRADEDB: [14:15:22 93275/186078] migrate_814_to_816.sql:368
    14:19:03 UPGRADEDB: [14:15:22 93310/186078] Invalid column name 'Processname'.
    14:19:03 ABORT: Executing C:\Windows\SysWOW64\netsh.exe firewall delete allowedprogram "C:\Users\_~1\AppData\Local\Temp{46D48902-1043-4DCA-A60B-9A29598DFA8F}{ECD2D524-718A-4A49-8026-337428C013EB}\ServerSetupPreReq.exe"
    14:19:07 POSTUPSQLM: [14:19:06 109/112]
    14:19:07 POSTUPSQLM: ...Finished with post-upgrade steps.
    14:19:08 ABORT: Restored previous Cb Protection Install package backup.
    14:19:08 ABORT: Cb Protection services were not started due to database upgrade failure.
    14:19:08 ABORT: Deleted temporary files from C:\Users\~1\AppData\Local\Temp{46D4.

Environment

  • App Control Server: 8.1.0.3546  upgrade to  8.1.10 (formerly CB Protection)

Cause

Character mismatch on database index 

Resolution

  1.  Before accepting the EULA ,edit C:\Users\<username>\AppData\Local\Temp\{somenumbers}\{somenumbers}\migrate_from_8.1.4.sql
  2. Locate & change 
    AND sr.procname LIKE '%' + Processname + '%'
    
    to
    
    AND sr.procname LIKE '%' + ProcessName + '%'
    
  3. Locate & change 
    ProcessName VARCHAR(64),     -- A process specified in the rule, will be matched using "like" 
    
    to
    
    ProcessName VARCHAR(64) COLLATE database_default,     -- A process specified in the rule, will be matched using "like"
  4. Save the changes and accept the EULA 

Additional Information

  • The extracted files before accepting the EULA would be in a location named like 
    • C:\Users\<username>\AppData\Local\Temp\ECD2D524-718A-4A49-8026-337428C013EB
  • For assistance in modifying script, contact Carbon Black Support