Thread Info
  • State Verified Answer
  • Locked Locked
  • Replies 4 replies
  • Subscribers 1 subscriber
  • Views 8413 views
  • Users 0 members are here
Options
Suggested
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

Sophos Management Console error upgradr

tedz

Hi,

Please advice us for our console cannot start the management console, the management service cannot start.

I look on the event viewer I found out this error:

Initialization failed.

Step: Migrating data if necessary

Error: std::runtime_error. Database upgrade failed. Please see KBA 113946.

Data: ErrorUnexpected

Sophos SEC V:4.7 upgrade to 5.1

Thanks in advance,

tedz

:39721


This thread was automatically locked due to age.
  • 0

    Hello tedz,

    apart from the from the left-over database mentioned in the article a there are other reasons that may cause the automatic upgrade to fail. Usually it does no harm running UpgradeDB.exe manually as suggested. If it fails again and you can't figure out why please post the log here.

    HTH

    Christian

    :39723
  • 0

    Hi Christian,

    Thank you for your reply.

    Here is the return error that used the command..

    S:\SophosProgram_DoNotDelete\Enterprise Console>upgradedb.exe -debug -sourceVers ion=47 -udl=sophos.udl 06.05.2013 10:40:40      ... successfully completed. 06.05.2013 10:40:40 Validating parameter values ... 06.05.2013 10:40:40      ... successfully completed. 06.05.2013 10:40:40 Transferring data to the new database ... 06.05.2013 10:40:45 Error: DBI exception thrown %1 could not be found.

    06.05.2013 10:40:45 Exit code 5 (Failed to transfer data from the old database.)

    Thanks,

    tedz

    :39827
  • 0

    Hi,

    You don't need to specify a UDL file unless you're running upgradedb.exe on a computer other than the Sophos Management server as a way to tell UpgradeDB.exe where the database instance and database is.  When you run upgradedb.exe on the management server it just reads this info from the registry.

    If the upgrade fails -- 

    Note: Tthe upgrade is just moving data from SOPHOS47 to SOPHOS51 in this case and then setting the upgradestatus in the upgrade table of SOPHOS52 to 2.

    If it fails to transfer the data it is also best to recreate the new database SOPHOS51 first using InstallDB.bat:

    http://www.sophos.com/en-us/support/knowledgebase/116768.aspx

    Then try UpgradeDB.exe again, in your case on the management server, as an administrator run:

    upgradedb.exe -debug -sourceVers ion=47

    If this still fails, have a look at:

    http://www.sophos.com/en-us/support/knowledgebase/65420.aspx

    You can see the stored procedure that actually gets called by UpgradeDB.exe,  running that manually will give you more specific info if there is a problem.

    Regards,

    Jak

    :39831
  • 0

    Hi Jak,

    Thank very much your advice can help us.

    If it fails to transfer the data it is also best to recreate the new database SOPHOS51 first using InstallDB.bat:

    http://www.sophos.com/en-us/support/knowledgebase/116768.aspx

    Then try UpgradeDB.exe again, in your case on the management server, as an administrator run:

    upgradedb.exe -debug -sourceVers ion=47

    I will drop the database sophos51 and manually create and run upgradedb.exe.

    Thank you so much.

    tedz

    :39833