Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 5 replies
  • Subscribers 1 subscriber
  • Views 2487 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.
Parents
  • 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
Reply
  • 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
Children
No Data