Thread Info
  • State Verified Answer
  • Locked Locked
  • Replies 9 replies
  • Subscribers 1 subscriber
  • Views 4577 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

Upgrade from 4.7 to 5.0 Console Fail. Management service refuses to start.

mpendlebury

Just attempted to upgrade to Management console version 5.0 from 4.7

Installation appeared to go perfectly. Followed upgrade guide to the letter.

However, the management service now refuses to start.

A little investigation into the event logs shows.....

Sophos Managements Service :

Initialization failed.
Step: Migrating data if necessaryError: std::runtime_error. Database upgrade failed. Please see KBA 113946.Data: ErrorUnexpected

It would appear the database has not been upgraded. 

After more diggings I've checked the database instances using :

sqlcmd -E -S .\sophos -Q "select name from sysdatabases"

This returns all databases including SOPHOS45, SOPHOS47 (current version) and SOPHOS50

More digging I have tried to update the database manually....

upgradedb.exe -debug -sourceVersion=47

returns.....

25.04.2012 11:39:20      ... successfully completed.25.04.2012 11:39:20 Validating parameter values ...25.04.2012 11:39:20      ... successfully completed.25.04.2012 11:39:20 Transferring data to the new database ...25.04.2012 11:39:23 Error: std::exception thrown  SP Error: 55 (ErrorDataTransferFailed)25.04.2012 11:39:23 Exit code 5 (Failed to transfer data from the old database.)

Help please????? Thanks.

:24119


This thread was automatically locked due to age.
Parents
  • 0

    I'm now also having this problem, I'm pretty new to the whole upgrade process, I've upgraded 4.5 to 4.7 before and it went fine, but this time, simply cannot get it to work.

    I have tried upgradedb.bat and no luck, including resetting the db and using the cmd upgrade.

    I simply get this in the event viewer.

    Initialization failed.

Step: Migrating data if necessary
Error: std::runtime_error. Database upgrade failed. Please see KBA 113946.
Data: Could not find stored procedure 'dbo.FromXTo4'.
    :33943
Reply
  • 0

    I'm now also having this problem, I'm pretty new to the whole upgrade process, I've upgraded 4.5 to 4.7 before and it went fine, but this time, simply cannot get it to work.

    I have tried upgradedb.bat and no luck, including resetting the db and using the cmd upgrade.

    I simply get this in the event viewer.

    Initialization failed.

Step: Migrating data if necessary
Error: std::runtime_error. Database upgrade failed. Please see KBA 113946.
Data: Could not find stored procedure 'dbo.FromXTo4'.
    :33943
Children
No Data