Not a question, already solved this myself after a lovely afternoon...
SEC upgrade fails from 5.2. to 5.5, Sophos Management service fails to start etc. etc.
Eventlog
Sophos Management Service, eventid 8004
Initialization failed.
Step: Migrating data if necessary
Error: std::runtime_error. Database upgrade failed. Please see KBA 113946.
Data: ErrorUnexpected
tried to run upgradedb.exe as per suggested kba: https://community.sophos.com/kb/en-us/65420
upgradedb.exe -debug -sourceVersion=52
but got hit with errors similar to:
27.09.2012 11:45:46 ... successfully completed. 27.09.2012 11:45:46 Validating parameter values ... 27.09.2012 11:45:46 Invalid source version: 50 27.09.2012 11:45:46 Exit code 1 (Invalid command line qualifier.)
upgradedb.exe is just a wrapper around some stored procedures, turns out sourceVersion=52 needs to be sourceVersion=520
1 - ran installDB.bat from the sec_550 installer Core directory to reinstall the new SOPHOS550 DB freshly
2 -upgradedb.exe -debug -sourceVersion=520 to migrate the data from SOPHOS52 DB to SOPHOS550 DB
3 - Sophos Management Service should now be able to start succesfully
This thread was automatically locked due to age.
