App Control: Server upgrade failed from 8.1.0 to 8.1.10

[#1]

Environment

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

Symptoms

• 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.

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 Notes

• 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 

Related Content

App Control: Supported Upgrade Paths