Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 5 replies
  • Subscribers 1 subscriber
  • Views 2485 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

Just upgraded from SEC 4.7 TO SEC 5.0

Anth

Hi We've just upgraded our Enterprise Console to 5.0 (As well as upgrading the database held on a separte SQL Server)

All seemed to go well during the process, though we are now getting the following error:

Initialization failed.

Step: Migrating data if necessary

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

Data: ErrorUnexpected

I have tried the tool upgradeDB with little effect. Any suggestions?

Thanks

:19575


This thread was automatically locked due to age.
  • 0

    HI,

    What SOPHOS databases do you have in your SOPHOS instance?

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

    will list them.

    You only need the SOPHOS47 if that's the latest version you are updating from.  I would detach the others using the SQL Management Studio tool.  You could delete them if you're feeling confident:

    sqlcmd -E -S .\sophos -Q "drop database SOPHOS3"
    sqlcmd -E -S .\sophos -Q "drop database SOPHOS4 "

    sqlcmd -E -S .\sophos -Q "drop database SOPHOS45"

    Then run as an Administrator:

    Upgradedb.exe -debug -sourceVersion=47

    NOTE: sourceVersion, requires the uppercase V.

    What does that display on screen?

    Regards,

    Jak

    :19577
  • 0
    I Have some problem after command: C:\Program Files (x86)\Sophos\Enterprise Console>Upgradedb.exe -debug -sourceVersion=45 message is: 16.01.2012 14:54:28 ... successfully completed. 16.01.2012 14:54:28 Validating parameter values ... 16.01.2012 14:54:28 ... successfully completed. 16.01.2012 14:54:28 Transferring data to the new database ... 16.01.2012 14:54:36 Error: std::exception thrown SP Error: 55 (ErrorDataTransferFailed) 16.01.2012 14:54:36 Exit code 5 (Failed to transfer data from the old database.) What can I do to fix it thanks
    :20899
  • 0

    Hello poki,

    are you attempting to upgrade from SEC4.5, that would be the SOPHOS45 database and therefore -sourceVersion=45. Seems to be a typo in Jak's post as it should be -sourceVersion=47 when upgrading from 4.7 (and 45 and the older ones having been been dropped just before).

    Anyway, I had a similar error and knowing that my source was fine I just used InstallDB.bat (from 5.0 on in the DB\Core folder) do make a fresh SOPHOS50 database after which the upgrade went fine.

    HTH

    Christian

    :20907
  • 0

    Christian is right, if you're upgrading from 4.7 it should be -sourceVersion=47, sorry for the typo .  I've updated the post above.

    Jak

    :20919
  • 0

    This helped me with my installation, thanks!!

    :21049