This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Upgradedb.exe- from SCC 4.0 to SEC 5.1

Hi,

We have upgraded from SCC4.0 to SEC5.1 and it was installed successfully, but there's an error in the Event log it has Event ID 8004-Initialization failed. Step: Migrating data if necessary Error: std:runtime.error. Database upgrade failed. Please see KBA113946; so we used the upgradedb.exe tool but again there's an error and using the -debug option here's the output:

C:\Program Files (x86)\Sophos\Enterprise Console>upgradedb.exe -sourceVersion=2
-debug
13.02.2014 10:12:15 ... successfully completed.
13.02.2014 10:12:15 Validating parameter values ...
13.02.2014 10:12:15 Invalid source version: 2
13.02.2014 10:12:16 Exit code 1 (Invalid command line qualifier.)

I can see the following databases in our environment:

SOPHOS4, SOPHOS51, SOPHOSENC51, SOPHOSPATCH51

What is the correct parameter that must be used? Or proper way of migrating the data from the old db to the new one?

Thanks

:47285


This thread was automatically locked due to age.
  • Hello JExtreme,

    -sourceVersion=2

    as your old database is SOPHOS4 this parameter should be -sourceVersion=4. Did you assume the value should be 2 or have you found it in the logs. The installer attempts to do the upgrade, this is logged in the Sophos_Servernnmsi<timestamp>.log in %ProgramData%\Sophos\Management Installer\,  just search for sourceVersion. You'll find the output of the initial UpgradeDB.exe run in the lines starting with RunExecutable:.

    So just try again with -sourceVersion=4, it might be necessary to reset the new database first (use the -reset parameter).

    HTH

    Christian

    :47287
  • Hi Christian,

    Thanks for the reply.  I'm quite confused on the article here: http://www.sophos.com/en-us/support/knowledgebase/65420.aspx

    -sourceVersion=2
    specifies the SOPHOS2 database to upgrade from. This option is required for Small Business v4.x upgrades. 

    will try this one, and keep you posted, thanks!

    :47353
  • Hi Christian,

    It worked. Thanks for the clarification.  By the way, can you include in this article http://www.sophos.com/en-us/support/knowledgebase/65420.aspx:

    This: 

    The installer attempts to do the upgrade, this is logged in the Sophos_Servernnmsi<timestamp>.log in%ProgramData%\Sophos\Management Installer\,  just search for sourceVersion. You'll find the output of the initial UpgradeDB.exe run in the lines starting with RunExecutable:.

    or rather include all the database names with equivalent sourceversion that should be used? 

    Thanks,

    Jason

    :47355